| |
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 ? |
| April 04, 2009 04:30:29 |
#3 |
| jeetuparida |
Member Since: April 2009 Total Comments: 3 |
RE: How many ways you can delete the table records ?
|
There are two way to delete table record.
If you want to delete specify record to use delete command delete table table_name
but do you want to delete all the table record to use truncate table_name. |
| |
Back To Question | |
