How delete all data from table in sql?


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

Post New Answer

More SQL PLSQL Interview Questions

How delete a row in sql?

0 Answers  


How many disk partitions should I have?

0 Answers  


what is the difference between ereg_replace() and eregi_replace()? : Sql dba

0 Answers  


How to run sql functions in pl/sql?

0 Answers  


Why trigger is used in sql?

0 Answers  






What is pl/sql table? Why it is used?

0 Answers  


What are commit, rollback, and savepoint?

0 Answers  


How can check sql version from command line?

0 Answers  


I have a package in which a table was used in a procedure and compiled later i have dropped the table used in the package what would be the status of package specification and body

1 Answers   TCS,


I have a small PL/SQL Block assume in this way begin select * from emp where empno=100; exception when others then <Some Messages> when no_data_found then <Some Messages> when too_many_rows then <Some Messages> end; The question which he asked was whether this block will get executed normally or it will throw error ? If errored out then what is the reason for the error ? Could anybody please help me ? Regards Nakul Venkataraman

3 Answers   Satyam,


When do we use triggers?

0 Answers  


What is parameter substitution in sql?

0 Answers  


Categories