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
Which is better stored procedure or query?
Could you please provide oca (oracle 10g) dumps for my certification ?
What is the difference between a subquery and a join?
What is a data manipulation language?
What is rtm in testing?
Is there a pl/sql pragma similar to deterministic, but for the scope of one single sql select?
Can a key be both primary and foreign?
Can I create table without primary key?
How can a pl sql block be executed?
Can instead of triggers be used to fire once for each statement on a view?
What are the different types of sql commands?
how to implement one-to-one, one-to-many and many-to-many relationships while designing tables? : Sql dba
In pl/sql, what is bulk binding, and when/how would it help performance?
How delete a row in sql?
What are the sql versions?
