10/23/2023 0 Comments Oracle sql prompt user input![]() ![]() ![]() ![]() If the maximum length is exceeded, the terminal beeps (on some systems, this may cause the screen to flash instead). If INSERT or UPDATE references a variable whose length is greater than that defined in the database, the SQL is rejected and Production Reporting halts. Use MAXLEN to prevent entering data that is too long. If BATCH-MODE is specified and no more arguments are in the command line, a value of 3 is returned in the STATUS variable and the user is not prompted for input.įormat for entering a date (see Table 57, Date Edit Format Characters). Prevents the prompt from displaying before INPUT is processed. Numeric variable for a return status code. Prompt (literal not variable) displayed to the user. Text, numeric, or date variable for the input data.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |