Mamat Zone

				
SELECT TABLE_NAME, COLUMN_NAME, DATA_TYPE, DATA_LENGTH, LAST_ANALYZED
FROM DBA_TAB_COLUMNS
WHERE OWNER = 'KAI'
ORDER BY TABLE_NAME

 TABLE_NAME     COLUMN_NAME               DATA_TYPE                     DATA_LENGTH     LAST_ANALYZED    
 -------------  ------------------------  ----------------------------  --------------  ---------------- 
 LAPORAN_SLA    PEMASUKAN_PENAWARAN_AWAL  TIMESTAMP(6)                  11              (null)           
 LAPORAN_SLA    DEV_PENDAFTARAN           INTERVAL DAY(9) TO SECOND(6)  11              (null)           
 LAPORAN_SLA    DEV_PENUNJUKAN_PEMENANG   INTERVAL DAY(9) TO SECOND(6)  11              (null)           
 LAPORAN_SLA    DEV_PENETAPAN_PEMENANG    INTERVAL DAY(9) TO SECOND(6)  11              (null)           
 LAPORAN_SLA    DEV_EVALUASI_PENAWARAN    INTERVAL DAY(9) TO SECOND(6)  11              (null)           
 LAPORAN_SLA    TU_NM                     VARCHAR2                      100             (null)           
 LAPORAN_SLA    TA_EMAIL_1                VARCHAR2                      32              (null)           
 LAPORAN_SLA    PENUNJUKAN_PEMENANG_AWAL  TIMESTAMP(6)                  11              (null)