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.