Friday, September 26, 2008

Oracle Interview Questions and solution


What are the various types of Exceptions ?

User defined and Predefined Exceptions.

Can we define exceptions twice in same block ?
No.

What is the difference between a procedure and a function ?
Functions return a single variable by value whereas procedures do not return any variable by value. Rather they return multiple variables by passing variables by reference through their OUT parameter.

No comments:

Post a Comment

Thanks to given comments.......

My Blog List