Home » Other » Training & Certification » Difference bet Trunc,delete,drop
Difference bet Trunc,delete,drop [message #315656] Tue, 22 April 2008 05:57 Go to next message
navaneetha
Messages: 5
Registered: April 2008
Location: hyderabad
Junior Member
Pls explain me the diff bet truncate,delete and drop commands??
Re: Difference bet Trunc,delete,drop [message #315659 is a reply to message #315656] Tue, 22 April 2008 06:05 Go to previous messageGo to next message
Michel Cadot
Messages: 64144
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Please tell us what you think about it.
Hint: you will get many answers if you search a little bit.

Regards
Michel
Re: Difference bet Trunc,delete,drop [message #315841 is a reply to message #315659] Tue, 22 April 2008 23:31 Go to previous message
gopu_g
Messages: 54
Registered: March 2008
Location: mumbai
Member

Hi,
why dont you do it in your test db.
check this link you will get some information
http://www.oracle-training.cc/t_garmany_easyoracle_drop_delete_truncate_tables.htm

Regards
Gopu
Previous Topic: certification (merged)
Next Topic: UDF question
Goto Forum:
  


Current Time: Fri Dec 09 11:25:58 CST 2016

Total time taken to generate the page: 0.07750 seconds