what is the syntax of DROP command?

Answer Posted / ch.ramesh

Drop is used to drop the total table
from data base

syntax: drop table <tablename>



note: there is no rollback command for drop

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How many types of database triggers exist?

575


What are the different pseudo commands? Explain in general?

539


What is a cursor variable?

576


What privilege is needed for a user to connect to oracle server?

555


In which language oracle has been developed?

647






What is the difference between a hot backup and a cold backup in oracle?

573


 How to use an oracle sequence generator in a mapping?

570


How to connect to the server with user account: sys?

564


How to create a new oracle data file?

556


How to get execution path reports on query statements?

564


What is an oracle transaction?

588


What is background process in Oracle?

626


How to assign data of the deleted row to variables?

579


Can a parameter be passed to a cursor?

600


Can we store images in oracle database?

551