Αποτελέσματα Αναζήτησης
22 Φεβ 2023 · I have a query which is executed from the application server (weblogic) for a report module which uses bind variables. he query as shown in v$sql is shown below. select /*+ first_rows(100)*/ col1,col2 from tab where c1=:1 and c2 >=:2 and c3<=:3.
2 Νοε 2018 · Sometimes I want to capture the SQL a process is running, and often the quickest method is to use the session browser tool in Toad, SqlDeveloper, or just the v$session and v$sql tables directly. However what I obviously see is this: Select something From my_table t Where t.value = :1.
15 Μαρ 2021 · Now, when i query view GV$SQL_BIND_CAPTURE i don't see values for bind from 1 to 7, how can i find those? select INST_ID,SQL_ID,POSITION,NAME,VALUE_STRING from GV$SQL_BIND_CAPTURE where sql_id='g0fdjxptp64bh' and inst_id=1 order by POSITION
Example: Bind variable containing comma-separated list of values, e.g.:bindvar = 1,2,3,4,5 . select * from mytable where myfield in ( SELECT regexp_substr(:bindvar,'[^,]+', 1, level) items FROM dual CONNECT BY regexp_substr(:bindvar, '[^,]+', 1, level) is not null );
V$SQL_BIND_CAPTURE displays information on bind variables used by SQL cursors. Each row in the view contains information for one bind variable defined in a cursor. This includes:
9 Ιουλ 2011 · SELECT county_code,state_code FROM WMS__ASSET_COUNTY_STATE WHERE STATE_CODE IN (SELECT regexp_substr(:bindstateocde, '[^,]+', 1, LEVEL) token FROM dual CONNECT BY LEVEL <= length(:bindstateocde) - length(REPLACE(:bindstateocde, ',', '')) + 1) ;
24 Ιουλ 2008 · select b.sql_text, a.bind_vars, c.datatype, c.value from v$sql_cursor a, v$sql b, v$sql_bind_data c where b.address = a.parent_handle and a.curno = c.cursor_num and b.sql_id= '&v_sqlid' and b.child_number = &v_sqlcn /
