what is the syntax of DELETE command?
Answers were Sorted based on User's Feedback
delete from <tablename> [where <condition> ]
| Is This Answer Correct ? | 4 Yes | 2 No |
Answer / kalicharan karsh
delete from <tablename> [where <condition> ]
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / ajeet singh
For delete any record from table :-
delete form <tablename> where <condition>;
For delete any column fromm table :-
alter table <tablename>
drop column <columnname>;
| Is This Answer Correct ? | 0 Yes | 1 No |
Answer / guest
select * from tablename
where col1=xyz
delete col1;
| Is This Answer Correct ? | 2 Yes | 7 No |
What is snapshot is too old? Give and example for better understand.
What is the best way to do multi-row insert in oracle?
What privilege is needed for a user to insert rows to tables in another schema?
How to write date and time interval literals in oracle?
What is difference between a formal and an actual parameter?
How do we represent comments in oracle?
how can find the second max sal for every group(i.e i want group the data based on key and find the second max sal for every group
how to join query for one source type is oracle another source type is sql server ?
what is difference between sql plus and sql*plus? (not sql and sql plus).
Explain can a view based on another view?
What is a connect identifier?
waht is the difference between primary key and super key?