SELECT ROWID, INST_STAT_DTL_ID, INST_STAT_ID, TO_NUMBER(TO_CHAR(YEAR,'YYYY')), YEAR, VALUE, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, REQUEST_ID, PROGRAM_APPLICATION_ID, PROGRAM_ID, PROGRAM_UPDATE_DATE FROM IGS_OR_INST_STAT_DTL
SELECT ROWID
, INST_STAT_DTL_ID
, INST_STAT_ID
, TO_NUMBER(TO_CHAR(YEAR
, 'YYYY'))
, YEAR
, VALUE
, CREATED_BY
, CREATION_DATE
, LAST_UPDATED_BY
, LAST_UPDATE_DATE
, LAST_UPDATE_LOGIN
, REQUEST_ID
, PROGRAM_APPLICATION_ID
, PROGRAM_ID
, PROGRAM_UPDATE_DATE
FROM IGS_OR_INST_STAT_DTL
|
|
|