2014-09-17 13:23:48 +02:00

7 lines
207 B
SQL

col ksqrs_addrlen new_value ksqrs_addrlen
set termout off
select vsize(addr)*2 ksqrs_addrlen from x$dual;
set termout on
select * from x$ksqrs where addr = hextoraw(lpad(upper('&1'), &ksqrs_addrlen, '0'));