From MS SQL Server to Oracle [message #371309] |
Mon, 02 October 2000 11:17 |
Edward
Messages: 6 Registered: October 2000
|
Junior Member |
|
|
Hi,
What I usually do in MS SQL Server+Crystal Reports to create a report with lots of calculations is to use stored procedures and create reports based on them.
In SQL Server procedure I perform all the calculations, store the results in a temp table and then I put SELECT * FROM #TEMP_TABLE at the end - my report is ready. What can I do in Oracle to simulate this?
Thanks,
Ed
|
|
|