[SYMBOL] [A] [B] [C] [D] [E] [F] [G] [H] [I] [J] [L] [M] [N] [O] [P] [Q] [R] [S] [T] [U] [V] [W] V$, V_$ pseudoviews V7, V8 parameters (SET COMPATIBILITY) validating user input ACC[EPT] command SQL for values, prompting users for session-duration definitions TERMOUT setting and VAR[IABLE] command 2nd VAR[IANCE] parameter (COMPUTE command) VARCHAR2 datatype 2nd variables bind in substitution variables bind variable application queries, testing how and when 2nd REFCURSOR SELECTing bind variables declaring 2nd printing contents automatically substitution variables with bind versus substitution bind, displaying contents of CLOB printing limitations in shell scripts NCLOB printing numberic substition output type, displaying prompting users for values session-duration definitions TERMOUT setting and REFCURSOR printing resetting definitions substitution (user) variables bind variables with changing prefix character defining 2nd disabling troubleshooting verification substitution into bind variables VER[IFY] setting 2nd verification, turning off version of Oracle, specifying versions of SQL*Plus 2nd VIEW operation (EXPLAIN PLAN) views ALL_SOURCE view function source code ALL_USERS view definition of, viewing definitions of, viewing 2nd dynamic performance views naming of data dictionary performance views, accessing VIS[IBLE] parameter (SET SHIFTINOUT) |