cc_static_expr.sql

来自「OReilly Oracle PL SQL Programming第4版源代码」· SQL 代码 · 共 44 行

CREATE OR REPLACE PROCEDURE check_expressions
IS
BEGIN
-- =, !=, OR works fine.
$IF $$plsql_optimize_level != 1 OR $$plsql_optimize_level = 2
$THEN
   -- Placeholder 
$END
   NULL;
END check_expressions;
/
CREATE OR REPLACE PROCEDURE check_expressions
IS
BEGIN
-- >, <=, AND ok.
$IF $$plsql_optimize_level > 1 AND $$plsql_optimize_level <= 5 
$THEN
   -- Placeholder 
$END
   NULL;
END check_expressions;
/
CREATE OR REPLACE PROCEDURE check_expressions
IS
BEGIN
-- <> OK
$IF $$plsql_optimize_level <> 1  
$THEN
   -- Placeholder 
$END
   NULL;
END check_expressions;
/
CREATE OR REPLACE PROCEDURE check_expressions
IS
BEGIN
-- IS NULL and IS NOT NULL are OK
$IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL 
$THEN
   -- Placeholder 
$END
   NULL;
END check_expressions;
/