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;

What is a Segment ?

1 Answers  

what is the maximum number of indexes i can create for a table? What happens if i create indexes for all the columns of a table? Will it slow down the speed of retrieval

2 Answers  

Point out the difference between user tables and data dictionary?

0 Answers  

How to use "startup" command to start default instance?

0 Answers  

13. Display the second to fifth characters in each client name.

2 Answers   Wipro,

What are the different types of database objects?

0 Answers  

How can one skip any number of rows while loading the DB tables with SQL Loader? Similarly how can one skip any column?

1 Answers   IBM,

 How to use an oracle sequence generator in a mapping?

0 Answers   Informatica,

9)When information has to be stored w.r.t employees and their respective departments, which of the following is the Correct formulation of entries? A)Employee and department would together be represented as an entity. B)This is too less information to decide on entities. C)An employee would be one entity and a department would be another. D)Such a scenario cannot be modelled in RDBMS

2 Answers   Mind Tree,

Explain an index segment?

0 Answers  

How to insert a record into a table?

0 Answers  

How to write a query with a full outer join in oracle?

1 Answers