SELECT appno ,sysdate timestamp ,husid ,scotvec ,surname ,fnames, /*birthdate,*/ gender ,domicile ,nation ,ethnic ,disable ,yrllinst ,occcode ,qualent2 ,sbjqa1 ,sbjqa2 ,sbjqa3 ,sbjbid ,feeelig ,postcode ,ucasnum ,sec ,soc2000 ,previnst ,gceasn ,gceasts ,vceasn ,vceasts ,gcean ,gceats ,vcean ,vceats ,ksqn ,ksqts ,uksan ,uksats ,sahn ,sahts ,shn ,shts ,si2n ,si2ts ,ssgcn ,ssgcts ,scsn ,scsts ,aean ,aeats ,totalts ,birthdte FROM IGS_UC_ISTARJ_INTS WHERE 1 = 2
SELECT APPNO
, SYSDATE TIMESTAMP
, HUSID
, SCOTVEC
, SURNAME
, FNAMES
, /*BIRTHDATE
, */ GENDER
, DOMICILE
, NATION
, ETHNIC
, DISABLE
, YRLLINST
, OCCCODE
, QUALENT2
, SBJQA1
, SBJQA2
, SBJQA3
, SBJBID
, FEEELIG
, POSTCODE
, UCASNUM
, SEC
, SOC2000
, PREVINST
, GCEASN
, GCEASTS
, VCEASN
, VCEASTS
, GCEAN
, GCEATS
, VCEAN
, VCEATS
, KSQN
, KSQTS
, UKSAN
, UKSATS
, SAHN
, SAHTS
, SHN
, SHTS
, SI2N
, SI2TS
, SSGCN
, SSGCTS
, SCSN
, SCSTS
, AEAN
, AEATS
, TOTALTS
, BIRTHDTE
FROM IGS_UC_ISTARJ_INTS
WHERE 1 = 2
|
|
|