What is a temp table? how to denote temp table?
- 4 Answers
- 10223 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
What is difference between sybase and oracle?
When should I execute an sp_recompile in sybase?
Is sybase a database? Explain.
What are the main differences between 11.x and 12.x versions of sybase?
Explain the role of replication server in sybase.
How can I tell the datetime my server started?
What you need to do is issue an ase kill command on the connection then un-suspend the db?
What happen when we delete the table using trigger?
How do the blocker processes exist internally in sybase?
How do you check database space? What measures are there to increase the db space?
What is the default table size in sybase?
What is table partitioning in sybase?
Compare join and subquery in performance?
What is ceiling()?
Explain procedure cache?
