Why use truncate instead of delete?


No Answer is Posted For this Question
Be the First to Post Answer

Post New Answer

More SQL PLSQL Interview Questions

what is the cursor and use of cursor in pl/sql ?

4 Answers  


What is record type in pl sql?

0 Answers  


Can we enter data in a table in design view?

0 Answers  


Create table emp (id number(9), name varchar2(20),salary number(9,2)); The table has 100 records after table created.Now i nee to change id's Datatype is to be Varchar2(15). now Alter table emp modify(id varchar2(15),name varchar2(20), salary number(9,2)); Whether it will work or returns error? post answer with explanation.

13 Answers   Oracle, TCS,


What does fetching a cursor do?

0 Answers  






What are pl sql data types?

0 Answers  


Is coalesce faster than isnull?

0 Answers  


What is union and union all keyword in sql?

0 Answers  


Are left and right joins the same?

0 Answers  


What are the types of index in sql?

0 Answers  


Why do we use procedures?

0 Answers  


How can a function retun more than one value in oracle with proper example?

0 Answers  


Categories