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
What is bulk load in oracle?
List the types of joins used in writing subqueries?
Who developed oracle & when?
What is oracle open database communication (odbc)?
Other than making use of the statspack utility, what would you check when you are monitoring or running a health check on an Oracle 8i or 9i database?
How to connect to a remote server?
How to select some columns from a table in oracle?
Explain integrity constraints?
How to load data through external tables?
What are the logical operations?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
How to delete a column in an existing table?
How to add a new column to an existing table with a default value?
What is the quickest way to fetch the data from a table?
How many types of synonyms in Oracle?