Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of DROP command?
- 10 Answers
- 13483 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
DROP object <object name>;
object means database object like table,index,view,sequence
etc.
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / 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 |
Answer / 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 |
Answer / yeshwanth kumar b.k
hey there is addition to the above command is
DROP TABLE <table_name> [PURGE][CASCADE CONSTRAINTS];
| Is This Answer Correct ? | 0 Yes | 0 No |
How to convert characters to dates in oracle?
what is a Nested Loop join?
Is there any function in oracle similar like group_concat of mysql?
What is the difference between a user and a schema in oracle?
How to call a stored procedure inside a trigger? Give an example.
WHT ARE THE AGGREATE FUNCTIONS?
1.how to extract the second highest salary from emp table having sal as a column which contains the salary of all employee of an organisation.
What is the function of Redo Log ?
Display the order number and the number of months since the order was shipped for all orders that have been shipped in the last year (365 days). (Hint: Unshipped orders will have a null value).
can anyone help me ? an index has been done on the primary key of a table. an update operation was performed on that table. now my question is 1> what abt the performance ? means faster or slower due to indexing ? 2> does the operation affect to the primary key constraint ?
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
What is Library Cache in Oracle?
Oracle General 
