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 would you do with an in-doubt distributed transaction?
What is Normalization ?
55 Answers ACS, Genpact, Graphix Solution, IBM, Keane India Ltd, TCS, Vault,
Explain an index segment?
What is rowid and rownum in oracle?
How to write date and time literals in oracle?
19. Display all clients whose name begins with the letter J or contains the letter M anywhere or contains E as the third letter.
Explain constraining triggers.
How many types of tables are there in oracle?
select * from emp what happened internally when we write this query in the sql prompt?
Hi can anyone tell me where are the dumps found of OCA certification.. Also the materials to be studied for the preparation.
can u plz provide me oca sql dumps please i need them
How a database is related to tablespaces?