Accept « SQL Plus « Oracle PL / SQL






  1. Oracle PL / SQL
  2. SQL Plus
  3. Accept
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
7.Read value from prompt and output with pl/sql