Advertisement Space
Dynamic SQL Recipes
Dynamic SQL
Recipes for working with dynamic SQL in Oracle, including REF cursors, session management, runtime SQL execution, and performance optimization.
Get Columns from Ref Cursor
How to get column names and types from a REF CURSOR at runtime using DBMS_SQL or XMLSequence.
Learn more →Display Oracle Session ID (SID)
Multiple ways to find the current Oracle session ID for use with v$session and other views.
Learn more →Deterministic Functions to improve Performance
Use deterministic functions and function-based indexes to dramatically improve query performance.
Learn more →Execute Immediate — Dynamic SQL in PL/SQL
Build and execute SQL statements at runtime with bind variables, dynamic DML, and dynamic cursors.
Learn more →