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;

you are a universe designer and report developer in BO, what type of information you gather from client?Briefly explain plz

0 Answers   iFlex,

What is Redo Log Buffer in Oracle?

0 Answers   MCN Solutions,

What are privileges and grants?

0 Answers  

What is difference between a formal and an actual parameter?

1 Answers  

How many types of tables are there in oracle?

0 Answers  

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.

0 Answers   TCS,

What happens if you use a wrong connect identifier?

0 Answers  

WHAT IS ecc 6.0

0 Answers  

what is the difference between rollback & commit? can a foreign key has null value?

6 Answers  

WHAT IS THE DIFFERENCE BETWEEN PRIMARY KEY(PK) CONSTRAINT AND UNIQUE KEY(UK) + NOT NULL(NN) CONSTRAINT ASSIGN TO A COLUMN ? INSTEAD OF ASSIGNING PK ,WE CAN ASSIGN UK + NN TO A COLUMN. WHAT ARE THE MARRITS AND DEMARITS BETWEEN THE ABOVE TWO?THE ABOVE TWO ARE SAME,THEY DON'T ALLOW DUPLICATE AS WELL AS NULL VALUES.

3 Answers  

What is a database schema in oracle?

0 Answers  

How to update values on multiple rows in oracle?

0 Answers