Category: PL/SQL INTERVIEW QUESTIONS

ALL_TAB_COLUMNS and ALL_TAB_COLS are the views in Oracle that describes the columns of the tables, views, and clusters accessible to the current user. The only difference between two views …

Difference between Procedure and Function? Function  must return a value and procedure need not. Function can be used in SQL queries with some restrictions. Procedure cannot be called directly …