| |
GeekInterview.com > Interview Questions > Oracle > SQL Plus
| Print | |
Question: How many ways you can delete the table records ?
Answer: In how many ways can I delete all the contents of a table and the entire table. Explain with syntax ? |
| May 05, 2009 07:05:47 |
#5 |
| Arpit Gautam |
Member Since: May 2009 Total Comments: 1 |
RE: How many ways you can delete the table records ?
|
If you want to delete only few rows from Table then use
Delete Table <Tablename>
where <condiition>
It will just delete the data but not unhold the space.
If you want to remove whole data then
Truncate table <Tablename>
will remove all rows and unhold the space.
Delete Table <Tablename> will also do that but it won't unhold the space. |
| |
Back To Question | |
