Using Temporary Table [message #57563] |
Mon, 23 June 2003 08:07 |
Velu Natarajan
Messages: 16 Registered: July 2002
|
Junior Member |
|
|
Dear ALL,
Can any on form me a effective syntax to Dear All,
Recently I came to know about Temporary tables on Oracle. It very good feature. Just, I planned to use this in my application as I am using crystal report and VB with Oracle. for reporting purpose at necessary areas we create a table and put data into that and process report on that. If, I use TEMPORARY TABLES for this work. I like to know will any problem affect my data.
Pls brief me on TEMPORARY TABLES. Whats that DELETE ON COMMIT and DELETE ON END SESSION.
Thanks!
Velu N
|
|
|