Answer Posted / ruchika jena
If u want to drop a table then the command is
drop table <table_name>;
If u want to drop a column_name then the command is
alter table <table_name> drop column <column_name>;
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.
how the Oracle Prepares the Execution Plan and how it chooses the Optimal one?
How to create a table in a specific tablespace?
How do I uninstall oracle 11g?
How do I spool in oracle?
Explain the use of record option in exp command.
What is meant by joins?
What is analyze command used for?
What is a lookup table in oracle?
How do I use os authentication with weblogic jdriver for oracle and connection pools?
A table t is there.If you perform insert ,update and delete then the trigger will fire.What is the minimum no of trigger required for a table.
What is the difference between view and materialized view in Oracle?
What is an external table?
Differentiate between function and procedure in oracle.
Are truncate and delete commands same? If so why?
