Home > Oracle > Bind Variables in sql statements

Bind Variables in sql statements

bind variable values are written to V$SQL_BIND_CAPTURE and can be identified by the following script


SELECT child_number,position,name,datatype_string,value_string FROM v$sql_bind_capture WHERE sql_id = '3k4tbu20h1n5v' ORDER BY 1,2;


CHILD_NUMBER   POSITION NAME       DATATYPE_STRING VALUE_STRING
------------ ---------- ---------- --------------- --------------------
           1          1 :B1        CHAR(32)        SX
           1          2 :B2        NUMBER          0
           1          3 :B3        NUMBER          137189
           1          4 :B4        CHAR(32)        1800-01-0100.00.00
           1          5 :B5        CHAR(32)        2010-03-1000.00.00
           1          6 :B1        CHAR(32)        SX
           1          7 :B2        NUMBER          0
           1          8 :B3        NUMBER          137189
           1          9 :B4        CHAR(32)        1800-01-0100.00.00
           1         10 :B5        CHAR(32)        2010-03-1000.00.00
           1         11 :B1        CHAR(32)        SX

CHILD_NUMBER   POSITION NAME       DATATYPE_STRING VALUE_STRING
------------ ---------- ---------- --------------- --------------------
           1         12 :B2        NUMBER          0
           1         13 :B3        NUMBER          137189
           1         14 :B4        CHAR(32)        1800-01-0100.00.00
           1         15 :B5        CHAR(32)        2010-03-1000.00.00

Advertisements
Categories: Oracle
  1. No comments yet.
  1. No trackbacks yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: