Answer / santhosh

1) Delete [From] <Table_Name>

Answer / harsha vardhan reddy

delete from <tablename> [where <condition> ]

Answer / guest

delete from tablename where condition;

Answer / kalicharan karsh

delete from <tablename> [where <condition> ]

Answer / sujata

delete from emp;

Answer / anju sharma

delete from tablename

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>;

Answer / guest

select * from tablename

where col1=xyz
delete col1;

why dont we assign not null constraint as table level constraint.

0 Answers  

How do I spool in oracle?

0 Answers  

You have one employee table having 3 entries emp_id, Mgr_id and salary. Mgr_id is also referencing emp_id. so now find out the emp_id which are having the second highest salary, under a particular manager.

3 Answers   Amazon, HCL,

create one table to capture an employee details with a primary key.

1 Answers   CTS,

What are oracle functions?

0 Answers  

Explain enable novalidate constraint.

0 Answers  

what is reindexing?

0 Answers   Tata Technologies,

What do you mean by a database transaction & what all tcl statements are available in oracle?

0 Answers  

Explain what are the different type of segments?

0 Answers  

What are data pump export and import modes?

0 Answers  

i must get table name, constraint type, constrain name with using concads "||" and it must be in string type, then with join processes i need code please help immidiately

1 Answers  

which language is used to develop the oracle........?

4 Answers   Infosys,