SELECT appno ,choiceno ,sysdate timestamp ,lastchange ,inst ,course ,campus ,faculty ,home ,decision ,decisiondate ,decisionnumber ,reply ,summaryconditions ,entrymonth ,entryyear ,entrypoint ,choicecancelled ,action ,substitution ,datesubstituted ,previousinst ,previouscourse ,previouscampus ,ucasamendment ,routebpref ,routebround ,detail ,extraround FROM IGS_UC_ISTARC_INTS WHERE 1 = 2
SELECT APPNO
, CHOICENO
, SYSDATE TIMESTAMP
, LASTCHANGE
, INST
, COURSE
, CAMPUS
, FACULTY
, HOME
, DECISION
, DECISIONDATE
, DECISIONNUMBER
, REPLY
, SUMMARYCONDITIONS
, ENTRYMONTH
, ENTRYYEAR
, ENTRYPOINT
, CHOICECANCELLED
, ACTION
, SUBSTITUTION
, DATESUBSTITUTED
, PREVIOUSINST
, PREVIOUSCOURSE
, PREVIOUSCAMPUS
, UCASAMENDMENT
, ROUTEBPREF
, ROUTEBROUND
, DETAIL
, EXTRAROUND
FROM IGS_UC_ISTARC_INTS
WHERE 1 = 2
|
|
|