Way of passing of variables to a SQL routine

Question

Define the way of passing of variables to a SQL routine.

Answer 1

Level: Low

By employ of the & symbol. For passing within variables the numbers 1 to 8 can be utilized (as &1, &2,...,&8) to pass the values after the exact command in the SQLPLUS session. So, to be prompted for an exact variable, place the ampersand variable within the code itself:

"choose * by dba_tables where owner=&owner_name;". Employ of twice ampersands informs SQLPLUS to reconstitute the value for every subsequent employ of the variable, a particular ampersand will cause a re-prompt for the value if not an ACCEPT statement is used to acquire the value by the user.