text: 
  
  create external table IF NOT EXISTS CUST
  (
  	CUST_ID	INT,	
  	LAST_NAME	STRING,	
  	FIRST_NAME	STRING,	
  	STREET_ADDRESS	STRING,	
  	POSTAL_CODE	STRING,	
  	CITY_ID	INT,	
  	CITY	STRING,	
  	STATE_PROVINCE_ID	INT,	
  	STATE_PROVINCE	STRING,	
  	COUNTRY_ID	INT,	
  	COUNTRY	STRING,	
  	CONTINENT_ID	INT,	
  	CONTINENT	STRING,	
  	AGE	INT,	
  	COMMUTE_DISTANCE	INT,	
  	CREDIT_BALANCE	INT,	
  	EDUCATION	STRING,	
  	EMAIL	STRING,	
  	FULL_TIME	STRING,	
  	GENDER	STRING,	
  	HOUSEHOLD_SIZE	INT,	
  	INCOME	INT,	
  	INCOME_LEVEL	STRING,	
  	INSUFF_FUNDS_INCIDENTS	INT,	
  	JOB_TYPE	STRING,	
  	LATE_MORT_RENT_PMTS	INT,	
  	MARITAL_STATUS	STRING,	
  	MORTGAGE_AMT	INT,	
  	NUM_CARS	INT,	
  	NUM_MORTGAGES	INT,	
  	PET	STRING,	
  	PROMOTION_RESPONSE	INT,	
  	RENT_OWN	STRING,	
  	SEG	INT,	
  	WORK_EXPERIENCE	INT,	
  	YRS_CURRENT_EMPLOYER	INT,	
  	YRS_CUSTOMER	INT,	
  	YRS_RESIDENCE	INT,	
  	COUNTRY_CODE	STRING,	
  	USERNAME	STRING
  )
  ROW FORMAT DELIMITED FIELDS TERMINATED BY '\;'
  LOCATION '/user/oracle/oggdemo/warehouse/cust';
  