SELECT school ,sitecode ,sysdate timestamp ,schoolname ,namechangedate ,formername ,ncn ,edexcelncn ,dfeecode ,country ,lea ,ucasstatus ,estabgrp ,schooltype ,statsdate ,noroll ,no5th ,no6th ,nohe ,address1 ,address2 ,address3 ,address4 ,postcode ,mailsort ,townkey ,countykey ,countrycode FROM IGS_UC_CVSCH_INTS WHERE 1 = 2
SELECT SCHOOL
, SITECODE
, SYSDATE TIMESTAMP
, SCHOOLNAME
, NAMECHANGEDATE
, FORMERNAME
, NCN
, EDEXCELNCN
, DFEECODE
, COUNTRY
, LEA
, UCASSTATUS
, ESTABGRP
, SCHOOLTYPE
, STATSDATE
, NOROLL
, NO5TH
, NO6TH
, NOHE
, ADDRESS1
, ADDRESS2
, ADDRESS3
, ADDRESS4
, POSTCODE
, MAILSORT
, TOWNKEY
, COUNTYKEY
, COUNTRYCODE
FROM IGS_UC_CVSCH_INTS
WHERE 1 = 2
|
|
|