About this document
Oracle SQL Pragmas and Functions Overview by tota111 is a document available to read on EtoBox.
Pragma is a PL/SQL keyword used to provide compiler instructions. Types include AUTONOMOUS_TRANSACTION and RESTRICT_REFERENCES. Views and materialized views allow querying of remote data locally. Collections include index-by tables, nested tables, and varrays. DBMS_JOB allows scheduling jobs. High water mark tracks maximum block usage. PCTFREE and PCTUSED control block space usage for updates. Explicit cursors handle multiple rows while implicit cursors handle single rows. REF cursors provide flexibility in
- Author
- tota111
- Language
- EN