DBA Hub

📋Steps in this guide1/1

VARIABLE new feature in Oracle 12.2 DBACLASS

You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2: SQL> variable text char SQL> exec :text:='X' PL/SQL procedure successfully completed. SQL> select * from DUAL where DUMMY=:text; D - X Now in 12.2 is so simple SQL> variable text char='X' SQL> select * from DUAL where DUMMY=:text; […]

oracle clusteringintermediate
by OracleDba
13 views
1

Overview

You may use SQL*Plus to test queries with bind variables. Here is what you do before 12.2: Now in 12.2 is so simple

Code/Command (click line numbers to comment):

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
SQL> variable text char
SQL> exec :text:='X'

PL/SQL procedure successfully completed.

SQL> select * from DUAL where DUMMY=:text;

D
-
X

SQL> variable text char='X'
SQL> select * from DUAL where DUMMY=:text;

D
-
X

Comments (0)

Please to add comments

No comments yet. Be the first to comment!