programming font를 바꿔볼라구... by fowler

2012-04-20-quiz.doc



Database-n-SQL-4.pdf


quiz.zip


---------------------------------------------------------------------------------------------------------------------------------------------

6번 참고자료


 CREATE TABLE fish_info (

  common varchar2(50) NOT NULL,

  species varchar2(50) NOT NULL,

  location varchar2(50) NOT NULL,

  weight varchar2(15) NOT NULL 

);



INSERT INTO fish_info VALUES ('bass, largemouth' ,'M. salmoides' ,'Montgomery Lake, GA', '22 lb 4 oz'); 

INSERT INTO fish_info VALUES ('walleye', 'S. vitreus', 'Old Hickory Lake, TN', '25 lb 0 oz'); 

INSERT INTO fish_info VALUES ('trout, cutthroat', 'O. Clarki', 'Pyramid Lake, NV', '41 lb 0 oz'); 

INSERT INTO fish_info VALUES ('perch, yellow', 'P. Flavescens', 'Bordentown, NJ', '4 lb 3 oz'); 

INSERT INTO fish_info VALUES ('bluegill', 'L. Macrochirus', 'Ketona Lake, AL', '4 lb 12 oz'); 

INSERT INTO fish_info VALUES ('gar, longnose', 'L. Osseus', 'Trinity River, TX', '50 lb 5 oz'); 

INSERT INTO fish_info VALUES ('crappie, white', 'P. annularis', 'Enid Dam, MS', '5 lb 3 oz'); 

INSERT INTO fish_info VALUES ('pickerel, grass', 'E. americanus', 'Dewart Lake, IN', '1 lb 0 oz'); 

INSERT INTO fish_info VALUES ('goldfish', 'C. auratus', 'Lake Hodges, CA', '6 lb 10 oz'); 

INSERT INTO fish_info VALUES ('salmon, chinook', 'O. Tshawytscha', 'Kenai River, AK', '97 lb 4 oz'); 

---------------------------------------------------------------------------------------------------------------------------------------------------------------------------



MONOFUR

http://www.dafont.com/monofur.font


------------------

CREATE TABLE cookie_sales (
  cookie_id number(11) constraint cookies_pk primary key,
  first_name varchar2(20) NOT NULL,
  sales number(4,2) NOT NULL,
  sale_date date NOT NULL
);

create sequence cookie_seq
start with 1
increment by 1;

INSERT INTO cookie_sales  VALUES ('1','Lindsey',32.02,'2007-03-12');
INSERT INTO cookie_sales  VALUES ('2','Nicole',26.53,'2007-03-12');
INSERT INTO cookie_sales  VALUES ('3','Britney',11.25,'2007-03-12');
INSERT INTO cookie_sales  VALUES ('4','Ashley',18.96,'2007-03-12');
INSERT INTO cookie_sales  VALUES ('5','Lindsey',9.16,'2007-03-11');
INSERT INTO cookie_sales  VALUES ('6','Nicole',1.52,'2007-03-11');
INSERT INTO cookie_sales  VALUES ('7','Britney',43.21,'2007-03-11');
INSERT INTO cookie_sales  VALUES ('8','Ashley',8.05,'2007-03-11');
INSERT INTO cookie_sales  VALUES ('9','Lindsey',17.62,'2007-03-10');
INSERT INTO cookie_sales  VALUES ('10','Nicole',24.19,'2007-03-10');
INSERT INTO cookie_sales  VALUES ('11','Britney',3.40,'2007-03-10');
INSERT INTO cookie_sales  VALUES ('12','Ashley',15.21,'2007-03-10');
INSERT INTO cookie_sales  VALUES ('13','Lindsey',0.00,'2007-03-09');
INSERT INTO cookie_sales  VALUES ('14','Nicole',31.99,'2007-03-09');
INSERT INTO cookie_sales  VALUES ('15','Britney',2.58,'2007-03-09');
INSERT INTO cookie_sales  VALUES ('16','Ashley',0.00,'2007-03-09');
INSERT INTO cookie_sales  VALUES ('17','Lindsey',2.34,'2007-03-08');
INSERT INTO cookie_sales  VALUES ('18','Nicole',13.44,'2007-03-08');
INSERT INTO cookie_sales  VALUES ('19','Britney',8.78,'2007-03-08');
INSERT INTO cookie_sales  VALUES ('20','Ashley',26.82,'2007-03-08');
INSERT INTO cookie_sales  VALUES ('21','Lindsey',3.71,'2007-03-07');
INSERT INTO cookie_sales  VALUES ('22','Nicole',0.56,'2007-03-07');
INSERT INTO cookie_sales  VALUES ('23','Britney',34.19,'2007-03-07');
INSERT INTO cookie_sales  VALUES ('24','Ashley',7.77,'2007-03-07');
INSERT INTO cookie_sales  VALUES ('25','Lindsey',16.23,'2007-03-06');
INSERT INTO cookie_sales  VALUES ('26','Nicole',0.00,'2007-03-06');
INSERT INTO cookie_sales  VALUES ('27','Britney',4.50,'2007-03-06');
INSERT INTO cookie_sales  VALUES ('28','Ashley',19.22,'2007-03-06');