Member Avatar for David_OHS

Would like to create a temp table at the start of my Code for pull only a small result set that I then can use for my final result.

Thank you,
David

  • 2 Contributors
  • 5 Replies
  • 105 Views
  • 1 Week Discussion Span
  • Latest Post Latest Post by debasisdas
Member Avatar for debasisdas

Which code ? are you using any application ?

Member Avatar for David_OHS

I am using Crystal Reports which passes the SQL code to the server. The database and server are hosted by a 3rd party and we can not create any views, Stored Proc or tables.

The main table has over 5 million records. I want to create a temp table that cuts down the records set and then process the report from the smaller record set. We were using SQL Servers but the data has been moved over to an Oracle database and I am new to Oracle.

I know what code to write to get the results from SQL Servers but it's doesn't work the same in Oracle.

Thanks for the help,
David

Member Avatar for debasisdas

if you do not have privileges to create views how can you create a table ?

Member Avatar for David_OHS

I just want to create a temp table for just the time I need to run my code. Can I do that without create privileges.

Member Avatar for debasisdas

You can't do that.
Ask your administrator to create a Global Temporary table for you.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.