plsql101_script_accept.txt

来自「orale培训教材包括了所有的sql说明和实例」· 文本 代码 · 共 20 行

edit d:\plsql101_test4.sql

/* Insert the following commands into the script file
SET VERIFY OFF
SET ECHO OFF

ACCEPT v_earliest_date PROMPT 'Earliest date you would like to see? (dd-mm月-yy): '
ACCEPT v_latest_date PROMPT 'Thank you. Latest date you would like to see? (dd-mm月-yy): '
SELECT product_name, quantity, purchase_date
FROM   plsql101_purchase
WHERE  purchase_date BETWEEN '&v_earliest_date' AND '&v_latest_date'
ORDER BY product_name, quantity
;

SET VERIFY ON
SET ECHO ON
*/

@d:\plsql101_test4