в 13:45, 26 мая 2010

2010-05-26T13:45:19Z

Admin: 1 версия

2010-05-26T09:59:38Z

1 версия

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

==LIKE operator in PL/SQL==



<source lang="sql">

SQL> DECLARE
2 lv_training_code_txt VARCHAR2(10) := "T_Code";
3 lv_non_training_code_txt VARCHAR2(10) := "TUSC";
4 PROCEDURE training_class_check (p_class_check VARCHAR) IS
5 BEGIN
6 IF p_class_check LIKE "T_%" THEN
7 DBMS_OUTPUT.PUT_LINE(p_class_check ||" is a Training Class");
8 ELSE
9 DBMS_OUTPUT.PUT_LINE(p_class_check ||" is a Non-Training Class");
10 END IF;
11 END training_class_check;
12
13 BEGIN
14 training_class_check(lv_training_code_txt);
15 training_class_check(lv_non_training_code_txt);
16 END;
17 /
T_Code is a Training Class
TUSC is a Training Class
PL/SQL procedure successfully completed.
SQL>
SQL>
--
</source>

==LIKE operator returns boolean value==



<source lang="sql">

SQL>
SQL> DECLARE
2 lv_test_bln BOOLEAN;
3 BEGIN
4 lv_test_bln := UPPER("true") LIKE "TRE%";
5 IF lv_test_bln THEN
6 DBMS_OUTPUT.PUT_LINE("Result: TRUE");
7 ELSE
8 DBMS_OUTPUT.PUT_LINE("Result: FALSE");
9 END IF;
10 END;
11 /
Result: FALSE
PL/SQL procedure successfully completed.
SQL>
</source>

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

Oracle PL/SQL/PL SQL/LIKE - История изменений

в 13:45, 26 мая 2010

Admin: 1 версия