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 |
Why does oracle 9i treat an empty string as null?
State and explain the different types of data models?
What is query image?
How to check your oracle database 10g xe installation?
Does oracle partitioning improve performance?
How to use subqueries with the exists operator in oracle?
How to define default values for formal parameters?
Explain what are synonyms used for?
how to find the n'th highest salary from emp ?
What are the values that can be specified for OPTIMIZER_GOAL parameter of the ALTER SESSION Command ?
Explain the family trees and connection by clause
1) What is ONE_SIZE_FITS_ALL approach? 2) Explain the Common & Variable Header of DATA FILE? 3) What are the Drawbacks to using OMF DB? and the Advantages? 4) List out the Advantages of Undo T.spaces over the Undo SEGMENT? 5) Difference between the Temporary tablespace with TEMPFILE and the Tablespace with TEMPORARY Keyword? 6) What are the situation extents are freeing for reuse.