what is try_catch block in procedure



what is try_catch block in procedure..

Answer / Pankaj Dhaka

In PL/SQL, a 'try_catch' block is used for exception handling. It allows you to enclose a block of code within a 'try' section and catch any exceptions that may occur during the execution of that code using a 'catch' section. The 'catch' section specifies what actions should be taken when an exception occurs, such as displaying an error message or performing alternative operations.

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More SQL PLSQL Interview Questions

Give the order of sql select?

1 Answers  


Which sql most popular?

1 Answers  


What is difference between primary and secondary key?

1 Answers  


How do I order by ascending in sql?

1 Answers  


What are the properties of a transaction?

1 Answers  


Can you rollback after commit?

1 Answers  


What is synchronized subquery?

1 Answers  


Which join condition can be specified using on clause?

1 Answers  


What is differance unique key and primary key.

7 Answers   EDS,


What is the difference between alter trigger and drop trigger statements?

1 Answers  


What is pl sql in oracle?

1 Answers  


What cursor type do you use to retrieve multiple recordsets?

17 Answers   Apollo, CTS, IonIdea, Microsoft, Oracle, TCS, Vmoksha, Wipro,


Categories