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

14 lines
239 B
SQL

SELECT
indx,
LPAD('0x'||TRIM(TO_CHAR(indx, 'XXXX')),7) hex,
ksllwnam,
ksllwlbl
FROM
x$ksllw
WHERE
indx like '&1'
OR TRIM(TO_CHAR(indx, 'XXXX')) LIKE UPPER('&1')
OR ksllwnam like '&1'
OR ksllwlbl like '&1'
/