接受选择提示"输入1进行贷记操作,输入2进行借记操作:";
我想要的输出是
Enter 1 for performing credit and,
Enter 2 for performing debit operation:
我试过这种方法
accept choice prompt"Enter 1 for performing debit"|| chr(13) ||"2 for credit operation : ";
但它的印刷是这样的,我无法给出价值。
SP2-0003: Ill-formed ACCEPT command starting as || chr(13) ||"Enter 2 for debit operation : "
这样行吗?
SQL> @so_test
Enter 1 for performing credit operation, and
Enter 2 for perforning debit operation: 2
EMPNO ENAME
---------- ----------
7521 WARD
7782 CLARK
7902 FORD
SQL>
那么,so_test.sql?
的内容是什么
SET VER OFF
PROMPT Enter 1 for performing credit operation, and
ACCEPT choice PROMPT 'Enter 2 for perforning debit operation: '
SELECT empno, ename
FROM emp
WHERE INSTR (empno, &choice) > 0;
我不知道一旦你输入选择,你会真正做什么,所以我执行了一个伪查询(只是为了表明它有效(。
只是想明确一点:你的问题有点错。它是关于SQL*Plus,而不是PL/SQL。