what is the syntax of DROP command?

Answer Posted / yeshwanth kumar b.k

hey there is addition to the above command is

DROP TABLE <table_name> [PURGE][CASCADE CONSTRAINTS];

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Explain the use of file option in exp command.

601


What are the ansi data types supported in oracle?

521


Oracle

1849


What are the uses of Database Trigger ?

1101


What is a read write transaction in oracle?

604






Explain the dml?

598


What is backup in Oracle?

569


How to store pictures on to the database?

530


Explain what are the advantages of views?

610


15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.

1699


how to do daily transactions with out sql* loader control file regesterd in apps?

1221


What is the difference between PFILE and SPFILE in Oracle?

578


What is the meaning of recursive hints in oracle?

532


How to convert a string to a date in oracle database?

542


What is SQL access advisor in Oracle?

632