전체 쿼리조회

set line 120

set pagesize 50

col name for a20

col value for a10

col deflt for a10

col type for a10

col description for a50

select a.ksppinm name, b.ksppstvl value,b.ksppstdf deflt,

decode (a.ksppity, 1, 'boolean',

                2, 'string',

                3, 'number',

                4, 'file',

                a.ksppity) type,

a.ksppdesc description

from sys.x$ksppi a, sys.x$ksppcv b

where a.indx = b.indx and a.ksppinm like '\_%' escape '\'

order by name

 

강조부분을 빼야 all 조회

원하는것만 찾을려면 where절에 추가해넣으면 된다.