Re: sql problem

  • From: Tony Adolph <tony.adolph.dba@xxxxxxxxx>
  • To: kerry.osborne@xxxxxxxxxxx
  • Date: Wed, 17 Mar 2010 11:43:57 +1300

What about:

select '(child '||child_number||') B' || bc.POSITION || ':' bind,
bc.VALUE_STRING, bc.DATATYPE_STRING
  from gv$sql_bind_capture bc
 where sql_id = '&var_sql'
 order by child_number, position;

Tony

Other related posts:

  1. Home
  2. oracle-l
  3. Archive
  4. 03-2010