Discussion :: Introduction to SQL - General Questions (Q.No.7)
Vinod said: (Jul 1, 2011) | |
Once the table is dropped from data base by using drop the data will be exists in recycle bin .... so we can get it back by using >flashback ....... command if we drop the table by using >drop table customer purge; (drop+purge) the whole data will be loss from recycle bin so we will no get it back ..... even by using >flashback ...... command also |
Ruthvik said: (Aug 31, 2011) | |
Flash back is a command that is added from oracle 10g only, if we drop a table on oracle 8i or 9i we can't get it back. |
Manche Shekhar said: (Nov 8, 2011) | |
If you want to remove a table from the database then we use drop command. Drop is a DDL command. The syntax is: Drop table <tablename>; From oracle 10g onwards if u remove a table ,we can get back by using Flashback command: The syntax is: Flashback table <tablename> before drop; If you want to remove a table perminently then we use purge command. Drop table <tablename> purge; |
Vishwa said: (Jan 29, 2012) | |
But we can delete table from database by using Delete Command. So Both B and C correct. |
Snehal said: (Nov 14, 2013) | |
Then what is use of truncate command and what is difference between delete and truncate command? Can we undo these commands? |
Snehal said: (Nov 14, 2013) | |
What is use of truncate command?can we undo delete and truncate command?And difference between delete and truncate command? |
Lovesh said: (Feb 12, 2014) | |
Truncate command is used to delete the complete data from an existing table. syntax: TRUNCATE TABLE table_name; |
Santosh Yepuri said: (Feb 20, 2014) | |
Delete Command Can delete specific record but in Truncate command it is not possible to delete specific record. And in Truncate command Where clause not support. |
Parvez said: (Feb 29, 2016) | |
Truncate command clear the records and free the memory. Wheres delete command doesn't free the memory. |
Nicat said: (Dec 16, 2016) | |
Truncate is used for Emptying the interior.(Clear records from table). Example we have students table. If we use the truncate command, only deleted records, not column names. |
Post your comments here:
Name *:
Email : (optional)
» Your comments will be displayed only after manual approval.