Drop is used to drop the total table from data base syntax: drop table

what is the syntax of DROP command?

Question Posted / ch.ramesh

10 Answers
13104 Views
I also Faced
E-Mail Answers

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 to start your 10g xe server?

970

How to create an oracle testing table?

1006

Explain what are synonyms used for?

980

What is difference between truncate and delete?

973

How do I find the database name in oracle?

979

Can a formula column referred to columns in higher group ?

2455

How can we find out the duplicate values in an oracle table?

993

What is a nvl function?

956

What is a synonym? What are its various types?

1043

Can any one explain me when i execute below query.. select months_between('07-JUL-12','10-FEB-12') from dual; Out put:- 4.90322581 How oracle calculate?

1322

How to install oracle odbc drivers?

1038

How to start an oracle instance?

951

How to run queries on external tables?

988

Explain a synonym?

969

various types of hints and their usage

2624