Oracle Database Programming: dynamic SQL

Oracle Database Programming: dynamic SQL: it is a string at compile time, and it is only found to be an SQL statement at run time. When SQL statements cannot be used directly, dynamic SQL is used. dynamic SQL is divided into early binding (Fast Running) and late binding (fast execution). Try to use early binding. Bind variables: Reduce the number of SQL compilations and improve execution efficiency. SQL statements and data warehouses (Data Mining) with few execution opportunities are not suitable for variable binding. The bound variable name starts with a colon and binds the variable with (using variable name. Execute immediate (immediate execution) to call a string SQL statement in dynamic SQL ).