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 SGA ? How it is different from Ver 6.0 and Ver 7.0 ?
Which Database is the best for the Security issue ? 1. DB2 2.SQL Server 3.MySQL 4.ORACLE
What is Hash Index?
What are set operators?
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).
Explain oracle insert into command?
what are steps for interface? where is exchange rate defined in which table?
In the oracle version 9.3.0.5.0, what does each number shows?
If a parameter is used in a query without being previously defined, what diff. exist betw. report 2.0 and 2.5 when the query is applied ?
What do you mean by a database transaction & what all tcl statements are available in oracle?
Can you have more than one content canvas view attached with a window ?
How to bring a tablespace offline?