Explain the truncate in Oracle?

1.	Explain the truncate in Oracle?
Answer» The TRUNCATE STATEMENT removes all the RECORDS from the table in the ORACLE database. If once the TRUNCATE statement truncate the table then the data cannot be recovered back. Example Syntax:- TRUNCATE TABLE table_name

Answer»

The TRUNCATE STATEMENT removes all the RECORDS from the table in the ORACLE database. If once the TRUNCATE statement truncate the table then the data cannot be recovered back.

Example

Syntax:- TRUNCATE TABLE table_name

Discussion

No Comment Found

Related InterviewSolutions

Explain self joins in oracle?
What is Oracle join syntax?
Please explain oracle left join with an example?
Please explain joins in oracle?
What is the dynamic SQL in Oracle?
Please explain drop constraint Oracle?
What are the various constraints used in Oracle?
What is translate in Oracle?
How to execute the package in Oracle?
What are packages in pl SQL and also explain its advantages?

Explain the truncate in Oracle?

Discussion

No Comment Found

Related InterviewSolutions

Reply to Comment