Home » RDBMS Server » Server Administration » From MS SQL Server to Oracle
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
Previous Topic: Create relationship with a table......
Next Topic: Text file access through Plsql
Goto Forum:
  


Current Time: Wed Apr 24 05:53:42 CDT 2024