What is a temp table? how to denote temp table?
- 4 Answers
- 10253 Views
- Oracle, I also Faced
- E-Mail Answers
Answer Posted / leena bejoy
Any table with name starting with '#' is automatically put
into tempdb database.
Temp tables allow developers to create and scan tables
within a stored procedure - and
have the tables totally isolated from all other database
connections. This is very
valuable when results need to be processed several times
within a loop, or when
a complex result set is expected (like a crosstab). Note
that temp table transactions
are logged within tempdb (exception: select into create
statements).
| Is This Answer Correct ? | 10 Yes | 0 No |
Post New Answer View All Answers
List similarities and differences between oracle & sybase.
How do I create a partitioned table that spans multiple devices in sybase?
Explain index covering? List its merits.
How to implement if-then-else in a select clause in sybase?
What is the default table size in sybase?
What is the use of 'with check' option in views?
How can set the multipal database ?
How do I open a sybase database?
What are the operating systems in which sybase could take its presence?
What is replication server?
What is replication in sybase?
How to find the time taken for rollback of the processed?
What is isql in sybase?
Is sybase sql?
Explain the advantages of data integration suite in sybase.
