SQL*Plus how to accept text variable from prompt?

by

You have to specify the data type as part of the ACCEPT statement. If none is given, it assumes a number.

Try ACCEPT myVariable CHAR PROMPT 'Input value: '; instead.

More Related Contents:

  1. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  2. Place to store PL/SQL block [closed]
  3. ANYONE CAN TELL ME THAT WHY THIS CODE IS GIVING ME AN ERROR OF TABLE OT CLUSTER KEY WORD IS MISSING? [closed]
  4. Get counts of all tables in a schema
  5. Determining location of relevant tnsnames.ora file
  6. Printing the value of a variable in SQL Developer
  7. ORA-12514 TNS:listener does not currently know of service requested in connect descriptor
  8. Oracle: Import CSV file
  9. PL/SQL – Use “List” Variable in Where In Clause
  10. Convert comma separated string to array in PL/SQL
  11. When or Why to use a “SET DEFINE OFF” in Oracle Database
  12. UTL_FILE.FOPEN() procedure not accepting path for directory?
  13. Oracle stored procedure with parameters for IN clause
  14. PL/SQL print out ref cursor returned by a stored procedure
  15. How to send email using Oracle 10 g Forms
  16. SQL Fiddle Output Error
  17. oracle PL/SQL how to calculate range ip for IPv6 cidr
  18. if (select count(column) from table) > 0 then
  19. Trying to export a Oracle via PL/SQL gives a date of 0000-00-00
  20. Oracle: how to INSERT if a row doesn’t exist
  21. Functions vs procedures in Oracle
  22. How to see refcursor result/output in Oracle SQL Developer? [duplicate]
  23. Reading clob line by line with pl\sql
  24. Why cannot I create triggers on objects owned by SYS?
  25. No more data to read from socket
  26. automating rollback script oracle
  27. How do I get column datatype in Oracle with PL-SQL with low privileges?
  28. How can I issue a single command from the command line through sql plus?
  29. Escaping single quote in PLSQL
  30. How to View Oracle Stored Procedure using SQLPlus?

Leave a Comment