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