what is the syntax of DELETE command?

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

More Oracle General Interview Questions

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?

0 Answers  


Describe the different type of Integrity Constraints supported by ORACLE ?

2 Answers  


How to recover a dropped index?

1 Answers  


What is clusters ?

2 Answers  






What is the difference between Sleep and Wait? (Java)

1 Answers   RBS,


Explain the use of inctype option in exp command.

0 Answers  


How to use "while" statements in oracle?

0 Answers  


How different is ms access and oracle?

0 Answers  


What is difference between sid and service name in oracle?

0 Answers  


What is oracle update statement with inner join ?

0 Answers  


What is data block in Oracle?

0 Answers   MCN Solutions,


Categories
  • Oracle General Interview Questions Oracle General (1789)
  • Oracle DBA (Database Administration) Interview Questions Oracle DBA (Database Administration) (261)
  • Oracle Call Interface (OCI) Interview Questions Oracle Call Interface (OCI) (10)
  • Oracle Architecture Interview Questions Oracle Architecture (90)
  • Oracle Security Interview Questions Oracle Security (38)
  • Oracle Forms Reports Interview Questions Oracle Forms Reports (510)
  • Oracle Data Integrator (ODI) Interview Questions Oracle Data Integrator (ODI) (120)
  • Oracle ETL Interview Questions Oracle ETL (15)
  • Oracle RAC Interview Questions Oracle RAC (93)
  • Oracle D2K Interview Questions Oracle D2K (72)
  • Oracle AllOther Interview Questions Oracle AllOther (241)