в 13:45, 26 мая 2010

2010-05-26T13:45:46Z

Admin: 1 версия

2010-05-26T10:04:17Z

1 версия

Новая страница

== Check $$PLSQL_OPTIMIZE_LEVEL==



<source lang="sql">
SQL>
SQL> CREATE OR REPLACE PROCEDURE post_processed
2 IS
3 BEGIN
4 $IF $$PLSQL_OPTIMIZE_LEVEL = 1
5 $THEN
6 -- Slow and easy
7 NULL;
8 $ELSE
9 -- Fast and modern and easy
10 NULL;
11 $END
12 END post_processed;
13 /
Procedure created.
SQL>
SQL> DECLARE
2 l_postproc_code dbms_preprocessor.source_lines_t;
3 l_row PLS_INTEGER;
4 BEGIN
5 l_postproc_code := dbms_preprocessor.get_post_processed_source ("PROCEDURE", USER, "POST_PROCESSED");
6 l_row := l_postproc_code.FIRST;
7
8 WHILE (l_row IS NOT NULL)
9 LOOP
10 DBMS_OUTPUT.put_line (LPAD (l_row, 3)|| " - "|| rtrim ( l_postproc_code (l_row),chr(10)));
11 l_row := l_postproc_code.NEXT (l_row);
12 END LOOP;
13
14 END;
15 /
PL/SQL procedure successfully completed.</source>

== $IF $$plsql_optimize_level==



<source lang="sql">
SQL>
SQL> CREATE OR REPLACE PROCEDURE check_expressions
2 IS
3 BEGIN
4 $IF $$plsql_optimize_level != 1 OR $$plsql_optimize_level = 2
5 $THEN
6 -- Placeholder
7 $END
8 NULL;
9 END check_expressions;
10 /
Procedure created.</source>

== $IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL==



<source lang="sql">
SQL> CREATE OR REPLACE PROCEDURE check_expressions
2 IS
3 BEGIN
4
5 $IF $$plsql_optimize_level IS NULL OR $$plsql_optimize_level IS NOT NULL
6 $THEN
7 -- Placeholder
8 $END
9 NULL;
10 END check_expressions;
11 /
Procedure created.
SQL></source>

← Предыдущая	Версия 13:45, 26 мая 2010
(нет различий)

Oracle PL/SQL Tutorial/SQL PLUS Session Environment/PLSQL OPTIMIZE LEVEL - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия