what is the syntax of DROP command?

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

normally database take to refresh time 2 hours. but client asked iwant to refresh with in 5 min that same database. do you have any option in BO and Oracle? explain me briefly...kavi

1929


How to update values on multiple rows in oracle?

758


What is the difference between translate and replace?

790


What is a Garbage Collection? and what is full recursive Garbage collection?

2578


How to convert characters to dates in oracle?

748


Query to retrieve record for a many to many relationship ?

2268


What is Undo Management Advisor in Oracle?

785


Write a trigger example in oracle?

766


How to revoke create session privilege from a user in oracle?

733


How to commit the current transaction in oracle?

771


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

769


How we can able to import our own template (users designed MS-Word templates) which has many tabular columns; need to pass some values generate by Oracle-reports9i? Actually need to import more than 400 MS-Word templates into Oracle Reports-9i to minimize layout design in Reports.

1798


Explain enable novalidate constraint.

788


How to define default values for formal parameters?

766


How to use "for" statements in oracle?

747