[php]
SQL> EXEC LS('SELECT * FROM DBA_TAB_COLS WHERE OWNER=''TEST'' AND TABLE_NAME=''TT''')
------------------ Record 1 ------------------
OWNER TEST
TABLE_NAME TT
COLUMN_NAME STR
DATA_TYPE VARCHAR2
DATA_TYPE_MOD
DATA_TYPE_OWNER
DATA_LENGTH 5
DATA_PRECISION
DATA_SCALE
NULLABLE Y
COLUMN_ID 1
DEFAULT_LENGTH
DATA_DEFAULT
NUM_DISTINCT
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
LAST_ANALYZED
SAMPLE_SIZE
CHARACTER_SET_NAME CHAR_CS
CHAR_COL_DECL_LENGTH 5
GLOBAL_STATS NO
USER_STATS NO
AVG_COL_LEN
CHAR_LENGTH 5
CHAR_USED B
V80_FMT_IMAGE NO
DATA_UPGRADED YES
HIDDEN_COLUMN NO
VIRTUAL_COLUMN NO
SEGMENT_COLUMN_ID 1
INTERNAL_COLUMN_ID 1
------------------ Record 2 ------------------
OWNER TEST
TABLE_NAME TT
COLUMN_NAME SYS_NC00002$
DATA_TYPE VARCHAR2
DATA_TYPE_MOD
DATA_TYPE_OWNER
DATA_LENGTH 4
DATA_PRECISION
DATA_SCALE
NULLABLE Y
COLUMN_ID
DEFAULT_LENGTH 15
DATA_DEFAULT SUBSTR("STR",4)
NUM_DISTINCT
LOW_VALUE
HIGH_VALUE
DENSITY
NUM_NULLS
NUM_BUCKETS
LAST_ANALYZED
SAMPLE_SIZE
CHARACTER_SET_NAME CHAR_CS
CHAR_COL_DECL_LENGTH 4
GLOBAL_STATS NO
USER_STATS NO
AVG_COL_LEN
CHAR_LENGTH 2
CHAR_USED B
V80_FMT_IMAGE NO
DATA_UPGRADED YES
HIDDEN_COLUMN YES
VIRTUAL_COLUMN YES
SEGMENT_COLUMN_ID
INTERNAL_COLUMN_ID 2
PL/SQL 过程已成功完成。
..
[/php]