Answer Posted / subhendu
Features:
1. If the TRUNCATE statement is issued against a temporary
table, only the session specific data is trucated. There is
no affect on the data of other sessions.
2. Data in temporary tables is automatically delete at the
end of the database session, even if it ends abnormally.
3. Indexes can be created on temporary tables. The content
of the index and the scope of the index is that same as the
database session.
4. Views can be created against temporary tables and
combinations of temporary and permanent tables.
5. Temporary tables can have triggers associated with them.
Export and Import utilities can be used to transfer the
table definitions, but no data rows are processed.
Is This Answer Correct ? | 5 Yes | 7 No |
Post New Answer View All Answers
How to place comments in pl/sql?
How can we find duplicate records in a table?
What information is needed to connect sql*plus an oracle server?
What is implicit cursor in pl sql?
How do I edit a stored procedure?
What is column?
How many triggers can be applied to a table?
What view means?
does sql support programming? : Sql dba
What will you get by the cursor attribute sql%notfound?
What is group by in sql?
Explain isolation levels. : Transact sql
What is trigger in pl sql with examples?
when is the use of update_statistics command? : Sql dba
Can there be more than one function with a similar name in a pl/sql block?