report4.sql

来自「oracle 11 源代码」· SQL 代码 · 共 7 行

SET ECHO OFF
SET VERIFY OFF

SELECT product_id, product_type_id, name, price
FROM products
WHERE product_type_id = &1
AND price > &2;