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.