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 |
Difference between primary key and unique key ?
77 Answers Accenture, B2B Software Technologies, Cognizant, HP Finsoft, IndiaNIC, Karomi Technology, Keane India Ltd, L&T, Onward eServices, R Systems, Shakti, Techtic Solutions,
When do I need to use a semicolon vs a slash in oracle sql?
Describe the different type of Integrity Constraints supported by ORACLE ?
How to recover a dropped index?
What is clusters ?
What is the difference between Sleep and Wait? (Java)
Explain the use of inctype option in exp command.
How to use "while" statements in oracle?
How different is ms access and oracle?
What is difference between sid and service name in oracle?
What is oracle update statement with inner join ?
What is data block in Oracle?