GeekInterview.com
   Home |  Tech FAQ  |   Interview Questions |  Placement Papers |  Tech Articles |  Learn |  Freelance Projects |  Online Testing |  Geeks Talk |  Job Postings |  Knowledge Base | Site Search |  Add/Ask Question

  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 ?


December 12, 2008 00:35:17 #2
 praveen_appu47   Member Since: December 2008    Total Comments: 1 
RE: How many ways you can delete the table records ?
 
There are two ways To delete all records in the table.
1. using delete
2. using truncate
In delete option we have used drop command. eg. drop table table_name;
for second one eg. truncate tablename; Both are delete the records in a table.
     

 

Back To Question