DROP object <object name>; object means database object like table

what is the syntax of DROP command?

Question Posted / samir kumar sahoo

Answer Posted / samir kumar sahoo

DROP object <object name>;

object means database object like table,index,view,sequence
etc.

Is This Answer Correct ?

1 Yes

0 No

Please Help Members By Posting Answers For Below Questions

What is the implicit cursor in oracle?

1044

Explain oracle’s system global area (sga).

1085

Explain the use of full option in exp command.

1063

Which dictionary tables and/or views would you look at to diagnose a locking issue?

1858

What is raw datatype in oracle?

1060

How to best split csv strings in oracle 9i?

992

What are the different oracle database objects?

1034

How to use fetch statement in a loop?

980

What to do if the startbd.bat failed to start the xe instance?

1022

What privilege is needed for a user to create tables in oracle?

910

why dont we assign not null constraint as table level constraint.

2689

Database is hung. Old and new user connections alike hang on impact. What do you do? Your SYS SQLPLUS session IS able to connect.

2100

Can we store images in oracle database?

952

What is dynamic proxy?

965

How does one get the view definition of fixed views/tables?

973