Answer given by Manoj is Absolutely correct.

diff between DELETE and TRUNCATE?.

Question Posted / shilpa.oracle

Answer Posted / shilpa.oracle

Is This Answer Correct ?

2 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Can the query output be sorted by multiple columns in oracle?

992

Explain what are synonyms used for?

1034

How to export data with a field delimiter?

1039

How to convert characters to dates in oracle?

1100

How to pass a parameter to a cursor in oracle?

1178

How would you best determine why your MVIEW couldnt FAST REFRESH?

1889

Give syntax for SQL and ORACLE joins.

1092

How to use an explicit cursor without open statements?

1055

What is an oracle user account?

990

Explain implicit cursor.

1030

what is the dual table in oracle?

991

What query tells you how much space a tablespace named test is taking up, and how much space is remaining?

2275

How do we get field details of a table?

978

Assuming that you are an End User How to find that in the payment Batch some of the Invoice was Missing To pay How to find That??

1727

can u plz provide me oca sql dumps please i need them

1947