Createworld.txt

From SQLZOO
Revision as of 11:43, 3 May 2016 by Andr3w (talk | contribs) (Created page with "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 acces...")
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to 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 :