Oracle Database - Stored Procedure

Card Puncher Data Processing

About

stored procedure in Oracle





Discover More
Card Puncher Data Processing
Oracle Database - AUTHID

The AUTHID property of a stored PL/SQL unit affects the name resolution and privilege checking of SQL statements that the unit issues at run time. The AUTHID property does not affect compilation, and has...
Card Puncher Data Processing
Oracle Database - PL/SQL - Result Sets from Stored Procedures

ORACLE supports procedures (functions) which returns result sets. Thus, a stored procedure can act as a table or a view. Here is an example on the HR schema with a cursor variable:



Share this page:
Follow us:
Task Runner