Oracle PL/SQL – Parameters, Variables, and Views

← Back to document page

Oracle PL/SQL – Parameters, Variables, and Views Using the Single ampersand characters to input column names, table names, and conditions SQL> select &col1, &col2, &col3 2 from &table_name 3 where &condition; Enter value for col1: last_name Enter value for col2: first_name Enter value for col3: wages old 1: select &col1, &col2, &col3

  Oracle, Variable, Parameters, View, Oracle pl sql parameters, And views