Interested to Buy Any Domain ? << Click Here >> for more details...
what is the syntax of DROP command?
- 10 Answers
- 13470 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 |
What will be the syntax to find current date and time in format "yyyy-mm-dd"?
> CREATE OR REPLACE FUNCTION FACTORIAL_1(factstr varchar2 ) 2 RETURN NUMBER AS 3 new_str VARCHAR2(4000) := factstr||'*' ; 4 fact number := 1 ; 5 BEGIN 6 7 WHILE new_str IS NOT NULL 8 LOOP 9 fact := fact * TO_NUMBER(SUBSTR(new_str,1,INSTR(new_str,'*')-1)); 10 new_str := substr( new_str,INSTR(new_str,'*')+1); 11 END LOOP; 12 13 RETURN fact; 14 15 END; explanation Above program?
What is BBED in Oracle?
How to speed up webrick?
what is host string in sql plus? how does it related to database?
How to drop a tablespace?
How to sort the query output in oracle?
How to rename an existing table?
What happens if the imported table already exists?
What is the difference between hot backup and cold backup in oracle? Tell about their benefits also.
how to tune oracle sql queries pls tell me step by step. urgent pls
How to find no of saturdays in a month using single sql ?
Oracle General 
