Createworld.txt

From SQLZOO
Jump to: navigation, search

DROP TABLE world; --r oracle: DROP TABLE world CASCADE CONSTRAINTS; CREATE TABLE world(

  name VARCHAR(50) NOT NULL
  ,continent VARCHAR(60)
  ,area DECIMAL(10) 		--r access:  ,area LONG
  ,population DECIMAL(11)	--r access:  ,population LONG
  ,gdp DECIMAL(14)		--r access:  ,gdp CURRENCY
  ,capital VARCHAR(60)
  ,tld VARCHAR(5)
  ,flag VARCHAR(255)
  ,PRIMARY KEY (name)
  );

GRANT ALL ON world TO andrew; --r access oracle : CREATE INDEX world ON world(continent); GRANT SELECT ON world TO PUBLIC; --r access :