& can be used to prompt input for different data types. How to prompt user for input in PL / SQL? In PL/SQL, user can be prompted to input a value using & character. Just as SQL*Plus treats the ampersand as a token to denote user input, Oracle SQL Developer does the same. Assign the resulting user variable to a PL/SQL variable, or use the value inline. Use an ampersand in front of a text string just like in SQL*Plus. FAQ about Oracle Sql Prompt For Input Data How to test user input in Oracle SQL? To test the input, you want to have Oracle SQL Developer prompt you for input.
0 Comments
Leave a Reply. |