Read value from prompt and output with pl/sql : Accept « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. Accept

Read value from prompt and output with pl/sql

    

SQL> SET ECHO OFF
SQL> ACCEPT not_can CHAR PROMPT 'Enter a table reference >'
SQL> DECLARE
  2     can VARCHAR2(60);
  3  BEGIN
  4     DBMS_UTILITY.CANONICALIZE('&not_can',can, 60);
  5     DBMS_OUTPUT.PUT_LINE(can);
  6  END;
  7  /


SQL>
SQL>








Related examples in the same category

1.ACCEPT variable value from user input
2.Use accept to get user input value and use them in a select statement
3.ACCEPT command creates a variable of datatype CHAR by default
4.Using the ACCEPT command
5.Read user input and use if to determine which table to print
6.Accept input and pass into a query