Explain the difference between drop and truncate commands in sql?


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

Post New Answer

More SQL PLSQL Interview Questions

in table there r so many rows write a query which two rows r updated last two day befor?

3 Answers   Exilant,


What language is oracle sql developer?

0 Answers  


Can a foreign key be a duplicate?

0 Answers  


How packaged procedures and functions are called from the following?

2 Answers  


Do ddl statements need commit?

0 Answers  






What is a mutating table

5 Answers   TCS, Tech Mahindra,


How to copy a table in another table with datas?

9 Answers  


How do I run a query in pl sql developer?

0 Answers  


In a package if we have 10 procedures or functions,How to know which will execute first?

1 Answers   Sollet Soft,


what are the properties and different types of sub-queries? : Sql dba

0 Answers  


Dear All, Question for this Week Find out possible error(s) (either at compile time or at runtime) in the following PL/SQL block. State the reason(s) and correct the errors. Declare Cursor C1 is select ename, sal, comm from emp; Begin For i in C1 Loop If i.comm between 299 and 999 then Dbms_output.put_line(i.Ename || ‘ ** Good Commission’); Elsif i.comm > 999 then Dbms_output.put_line(i.Empno || ‘ ** Very Good Commission’); close C1; Else Dbms_output.put_line(i.Ename || ‘ ** ’ ||nvl(i.comm,‘O’)); End if; End Loop; End;

7 Answers   Accenture,


What is before trigger?

0 Answers  


Categories