what is the syntax of DELETE command?

Categories >> Software >> Databases >> Oracle >> Oracle General
Suggest New Category

Question Posted / ppp

8 Answers
12276 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

what is the syntax of DELETE command?..

Answer / santhosh

1) Delete [From] <Table_Name>

Is This Answer Correct ?

10 Yes

2 No

what is the syntax of DELETE command?..

Answer / harsha vardhan reddy

delete from <tablename> [where <condition> ]

Is This Answer Correct ?

4 Yes

2 No

what is the syntax of DELETE command?..

Answer / guest

delete from tablename where condition;

Is This Answer Correct ?

3 Yes

2 No

what is the syntax of DELETE command?..

Answer / kalicharan karsh

delete from <tablename> [where <condition> ]

Is This Answer Correct ?

1 Yes

0 No

what is the syntax of DELETE command?..

Answer / sujata

delete from emp;

Is This Answer Correct ?

2 Yes

2 No

what is the syntax of DELETE command?..

Answer / anju sharma

delete from tablename

Is This Answer Correct ?

2 Yes

2 No

what is the syntax of DELETE command?..

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

what is the syntax of DELETE command?..

Answer / guest

select * from tablename

where col1=xyz
delete col1;

Is This Answer Correct ?

2 Yes

7 No

Post New Answer