ĐĎॹá>ţ˙ ›ţ˙˙˙—˜™š˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ěĽÁ7 đż8ŕbjbjUU ŞŇ7|7|ő×)˙˙˙˙˙˙lnnnnTr€Ń€Ń€Ń˜҄œŇ,rˆ5JÔŐÔŐ"öŐöŐöŐňňň5 5 5 5 5 5 5$Ň6 ň8T-5ňąîjňňň-5íýnnöŐöŐťB5íýíýíýň n¨öŐöŐ5íýň5íýęíý×~ +8ë4öŐČŐ †Ëň FĆrʀŃ'üĆ;3Řë4X50ˆ54ŘF9íýF9ë4íýrrnnnnŮCS 450 SQL Handout J. Dichter OracleŽ SQLPlus Editing SQL commands: SQL> select * from people; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M 6 rows selected. The SQLPlus LIST command prints the last command executed SQL> list 1* select * from people The SQLPlus command describe shows the attribute structure of a table SQL> describe people Name Null? Type ------------------------------- -------- ---- LAST NOT NULL CHAR(20) FIRST CHAR(20) BIRTHDAY DATE SSNUMBER NOT NULL CHAR(9) MARRIED CHAR(1) The SQLPlus run Command Reruns the Last Command SQL> SELECT birthday from PEOPLE; BIRTHDAY --------- 11-APR-55 03-MAY-62 12-JUN-44 09-SEP-88 23-NOV-51 16-DEC-65 6 rows selected. SQL> run 1* SELECT birthday from PEOPLE BIRTHDAY --------- 11-APR-55 03-MAY-62 12-JUN-44 09-SEP-88 23-NOV-51 16-DEC-65 6 rows selected. Editing your commands: use change, list n, and run SQL> select birthday 2 from people 3 where NOT UPPER(last) = 'SMITH'; BIRTHDAY --------- 23-NOV-51 16-DEC-65 SQL> list 1 1* select birthday SQL> change /birthday/first, birthday/ 1* select first, birthday SQL> run 1 select first, birthday 2 from people 3* where NOT UPPER(last) = 'SMITH' FIRST BIRTHDAY -------------------- --------- Robert 23-NOV-51 Adam 16-DEC-65 Deleting Parts of a Command SQL> select * 2 from people 3 where NOT UPPER(last) = 'SMITH'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M SQL> list 3 3* where NOT UPPER(last) = 'SMITH' SQL> del SQL> list 1 select * 2 from people 3* SQL> run 1 select * 2 from people 3* LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M 6 rows selected. Setting Titles for simple Reports SQLPlus commands TTITLE and BTITLE set the top and bottom titles of reports SQL> TTITLE CENTER 'ALL PEOPLE LISTING' SQL> BTITLE LEFT 'REPORT COMPLETE' SQL> select * 2 from people ; ALL PEOPLE LISTING LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M REPORT COMPLETE Modifying a Report SQL> TTITLE CENTER 'ALL PEOPLE' SKIP CENTER 'LISTING' SQL> select * from people; ALL PEOPLE LISTING LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M REPORT COMPLETE Toggling TITLES TTITLE OFF turns off the title TTITLE CLEAR removes the title Formatting Columns The SQLPlus COLUMN command can format columns. Here we list all current settings SQL> COLUMN COLUMN FIRST ON FORMAT A10 COLUMN LAST ON FORMAT A8 COLUMN object_node_plus_exp ON FORMAT a8 COLUMN plan_plus_exp ON FORMAT a60 COLUMN parent_id_plus_exp ON HEADING 'p' FORMAT 990 COLUMN id_plus_exp ON HEADING 'i' FORMAT 990 COLUMN LINE/COL ON FORMAT A8 COLUMN ROWLABEL ON FORMAT A15 Using COLUMN command SQL> column last heading 'Last|Name' SQL> select last from people; Last Name -------------------- Smith Smith Smith Smith Jones Jones Turning Off / Clearing COLUMN SQL> COLUMN last off SQL> column COLUMN last OFF HEADING 'Last|Name' headsep '|' COLUMN first OFF FORMAT A10 COLUMN other_plus_exp ON FORMAT a44 Clearing the COLUMN. This permanently removes the column SQL> COLUMN LAST clear Clearing ALL Columns. Try not to use this. SQL> CLEAR COLUMNS Ordering data by two or more attributes SQL> select * from people 2 order by last, birthday; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M Smith Alice 12-JUN-44 111223366 M Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Daniel 09-SEP-88 111567829 S 6 rows selected. Ordering by descending order SQL> select * from people 2 order by last, birthday desc; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Jones Adam 16-DEC-65 765667832 M Jones Robert 23-NOV-51 089554321 S Smith Daniel 09-SEP-88 111567829 S Smith Fred 03-MAY-62 454332121 M Smith Joseph 11-APR-55 050667744 M Smith Alice 12-JUN-44 111223366 M 6 rows selected. Ordering by attribute sequence number ( of FIELD in the QUERY ) SQL> select * from people order by 3; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Alice 12-JUN-44 111223366 M Jones Robert 23-NOV-51 089554321 S Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Jones Adam 16-DEC-65 765667832 M Smith Daniel 09-SEP-88 111567829 S 6 rows selected. Boolean Operators SQL> run 1 select * from people 2* where UPPER(last) = 'SMITH' AND first like '%l%' LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S SQL> select * from people; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M 6 rows selected. SQL> SELECT SSNUMBER from PEOPLE where first like '%a%' 2 OR MARRIED = 'S'; SSNUMBER --------- 111567829 089554321 765667832 Using Set Inclusion in Conditions SQL> select first, last from people where married IN ('M', '?', 'X'); FIRST LAST -------------------- -------------------- Joseph Smith Fred Smith Alice Smith Adam Jones SQL> RUN 1* select first, last from people where married NOT IN ('M', '?', 'X') FIRST LAST -------------------- -------------------- Daniel Smith Robert Jones Using a Range SQL> select * from people 2 where birthday > '01-JAN-50' AND birthday < '31-DEC-60'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Jones Robert 23-NOV-51 089554321 S SQL> select * from people 2 where birthday BETWEEN '01-JAN-50' AND '31-DEC-60'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Jones Robert 23-NOV-51 089554321 S Using pseudo Columns SQL> run 1* SELECT rownum, rowid, ssnumber from PEOPLE ROWNUM ROWID SSNUMBER ---------- ------------------ --------- 1 AAABnEAAFAAAAADAAB 050667744 2 AAABnEAAFAAAAADAAJ 454332121 3 AAABnEAAFAAAAADAAK 111223366 4 AAABnEAAFAAAAADAAL 111567829 5 AAABnEAAFAAAAADAAM 089554321 6 AAABnEAAFAAAAADAAN 765667832 rows selected. SYSDATE is a pseudo column for the current System Data and Time SQL> SELECT LAST, TO_CHAR(SYSDATE,'HH:MM:SS') TIME 2 FROM PEOPLE; LAST TIME -------------------- -------- Smith 08:03:57 Smith 08:03:57 Smith 08:03:57 Smith 08:03:57 … SQL> SELECT LAST, TO_CHAR(SYSDATE,'HH:MM:SS') TIME, SYSDATE 2 FROM PEOPLE; LAST TIME SYSDATE -------------------- -------- --------- Smith 08:03:28 10-MAR-99 Smith 08:03:28 10-MAR-99 Smith 08:03:28 10-MAR-99 Smith 08:03:28 10-MAR-99 …. Creating Synonyms SQL> create synonym P for people; Synonym created. SQL> select distinct last from P; LAST -------------------- Jones Smith SQL> drop synonym P; Synonym dropped. SQL> SQL> select distinct last from P; unknown command beginning "SQL> selec..." - rest of line ignored. The structure of the USER_SYNONYMS DD Table SQL> describe USER_SYNONYMS; Name Null? Type ------------------------------- -------- ---- SYNONYM_NAME NOT NULL VARCHAR2(30) TABLE_OWNER VARCHAR2(30) TABLE_NAME NOT NULL VARCHAR2(30) DB_LINK VARCHAR2(128) Listing Your Synonyms SQL> create synonym P for people; Synonym created. SQL> create synonym E for EMPLOYEES; Synonym created. SQL> select * from USER_SYNONYMS; SYNONYM_NAME TABLE_OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ DB_LINK -------------------------------------------------------------------------------- DEPT DICHTER DEPARTMENT E DICHTER EMPLOYEES SYNONYM_NAME TABLE_OWNER ------------------------------ ------------------------------ TABLE_NAME ------------------------------ DB_LINK -------------------------------------------------------------------------------- P DICHTER PEOPLE Oracle Commands SAVE/GET SQL> insert into people 2 values ('Smythe', 'Fred', '03-NOV-65', '221662341', 'M'); 1 row created. SQL> l2 2* values ('Smythe', 'Fred', '03-NOV-65', '221662341', 'M') SQL> c /Fred/Ann/ 2* values ('Smythe', 'Ann', '03-NOV-65', '221662341', 'M') SQL> c /03-NOV/11-APR/ 2* values ('Smythe', 'Ann', '11-APR-65', '221662341', 'M') SQL> c /221662341/056342228/ 2* values ('Smythe', 'Ann', '11-APR-65', '056342228', 'M') SQL> run 1 insert into people 2* values ('Smythe', 'Ann', '11-APR-65', '056342228', 'M') 1 row created. SQL> select * 2 from people; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Jones Adam 16-DEC-65 765667832 M Smythe Fred 03-NOV-65 221662341 M Smythe Ann 11-APR-65 056342228 M 8 rows selected. SQL> SAVE SEL Created file SEL SQL> GET SEL 1 select * 2* from people SQL> run 1 select * 2* from people Oracle Commands SAVE/GET SQL> get SEL 1 select * 2* from people SQL> input where LAST LIKE 'Sm%' SQL> list 1 select * 2 from people 3* where LAST LIKE 'Sm%' SQL> save SEL CREATE File "SEL.sql" already exists. Use "SAVE filename REPLACE". SQL> save SEL REPLACE Wrote file SEL The general syntax is SAVE commandfile [CREATE | REPLACE | APPEND] Oracle Command Start To run an SQL*PLUS command we can use either GET then RUN, or we can simply use START GET allows for viewing the file, editing, then running  START runs the command without verification dbase% cat SEL.sql SELECT * from PEOPLE where LAST LIKE 'Sm%'; We can run this file in SQL*PLUS as follows: SQL> START SEL SQL> select * 2 from people 3 where LAST LIKE 'Sm%'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Smythe Fred 03-NOV-65 221662341 M Smythe Ann 11-APR-65 056342228 M 6 rows selected. Wildcards in Pattern matching The underscore is a single character The percent character is any number of characters SQL> select * from people 2 where first like '_o%'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Jones Robert 23-NOV-51 089554321 S List records where the first name has a letter ‘Exception’ in it SQL> select * from people where UPPER(first) like '%E%'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Jones Robert 23-NOV-51 089554321 S Smythe Fred 03-NOV-65 221662341 M 6 rows selected. Using Arithmetic Expressions SQL> DESCRIBE CHILDREN Name Null? Type ---- --------------------------- -------- ---- FNAME NOT NULL VARCHAR2(20) MINIT VARCHAR2(1) LNAME NOT NULL VARCHAR2(20) PSSN NOT NULL CHAR(9) SSN NOT NULL CHAR(9) BDATE DATE GRADE NUMBER(38) GPA NUMBER SEX VARCHAR2(1) SQL> SELECT FNAME First_Name, BDATE Birthday, GPA 2 from CHILDREN; FIRST_NAME BIRTHDAY GPA -------------------- --------- ---------- Allen 11-APR-87 3.56 Albert 10-MAY-85 3.4 Allana 10-MAY-83 3.15 Albert 03-JUL-85 3.8 Eve 01-DEC-84 2.7 Sally 01-DEC-94 Adam 21-AUG-94 Ann 21-OCT-98 Lynn 21-OCT-98 SQL> SELECT FNAME First_Name, GPA/4 2 FROM CHILDREN 3 WHERE GPA > 3.0; FIRST_NAME GPA/4 -------------------- ---------- Allen .89 Albert .85 Allana .7875 Albert .95 Using Arithmetic Expressions SQL> SELECT FNAME, LNAME, GRADE+1 NEXT_YEAR 2 FROM CHILDREN 3 WHERE GRADE > 0; FNAME LNAME NEXT_YEAR -------------------- -------------------- ---------- Allen Smith 7 Albert Smith 9 Allana Smith 11 Albert Jones 9 Eve Jones 9 SQL> COLUMN GPA/4 FORMAT 9.99 HEADING 'GPA PERCENT' SQL> SELECT FNAME First, LNAME Last, GPA/4 2 FROM CHILDREN 3 WHERE GRADE > 0; FIRST LAST GPA PERCENT -------------------- -------------------- ----------- Allen Smith .89 Albert Smith .85 Allana Smith .79 Albert Jones .95 Eve Jones .68 SQL> RUN  1 SELECT FNAME First, LNAME Last, GPA/4 2 FROM CHILDREN 3 WHERE GRADE > 0 4* ORDER BY GPA/4 DESC FIRST LAST GPA PERCENT -------------------- -------------------- ----------- Albert Jones .95 Allen Smith .89 Albert Smith .85 Allana Smith .79 Eve Jones .68 Oracle Group Functions Group functions are applied to a set of records, rather than a single record attribute. Examples include: MAX, MIN, AVG, SUM, VARIANCE, STDDEV COUNT(*), COUNT(column), COUNT(distinct column) SQL> COLUMN MAX(BIRTHDAY) FORMAT A11 HEADING OLDEST SQL> COLUMN MIN(BIRTHDAY) FORMAT A11 HEADING YOUNGEST SQL> SELECT MAX(BIRTHDAY), MIN(BIRTHDAY) FROM PEOPLE; OLDEST YOUNGEST ----------- ----------- 09-SEP-88 12-JUN-44 SQL> SELECT ROUND(MAX(GPA),1) MAX_GPA, 2 ROUND(MIN(GPA),1) MIN_GPA, 3 ROUND(AVG(GPA),1) AVG_GPA FROM CHILDREN; MAX_GPA MIN_GPA AVG_GPA ---------- ---------- ---------- 3.8 2.7 3.3 Oracle Group Functions Counts all records SQL> SELECT COUNT(*) TOTAL_RECORDS FROM CHILDREN; TOTAL_RECORDS ------------- 9 Count only non-NULLs from GRADE attribute SQL> SELECT COUNT(*) TOTAL_RECORDS, COUNT(GRADE) IN_SCHOOL 2 FROM CHILDREN;  TOTAL_RECORDS IN_SCHOOL ------------- ---------- 5 Only count unique entries in the specified field SQL> SELECT COUNT(DISTINCT LNAME) FROM CHILDREN; COUNT(DISTINCTLNAME) -------------------- 3 Printing the standard deviation and variance SQL> COLUMN STDDEV(GPA) FORMAT 09.9 HEADING 'STANDARD|DEVIATION' SQL> COLUMN VARIANCE(GPA) FORMAT 09.9 HEADING VARIANCE SQL> SELECT STDDEV(GPA), VARIANCE(GPA) FROM CHILDREN;  STANDARD DEVIATION VARIANCE --------- -------- 00.2 Grouping Rows Counting the number of children per parent SSN (PSSN) SQL> SELECT PSSN, COUNT(*) NUMBER_OF_CHILDREN 2 FROM CHILDREN 3 GROUP BY PSSN; PSSN NUMBER_OF_CHILDREN --------- ------------------ 056342228 2 454332121 3 765667832 4 The same count, but here we access the PEOPLE table to get the parent name SQL> SELECT LAST, FIRST, COUNT(*) NUMBER_OF_CHILDREN 2 FROM CHILDREN, PEOPLE 3 WHERE PSSN = SSNUMBER 4 GROUP BY LAST, FIRST; LAST FIRST NUMBER_OF_CHILDREN -------------------- -------------------- ------------------ Jones Adam 4 Smith Fred 3 Smythe Ann 2 Similar, but ordering by the COUNT(*) column SQL> SELECT LAST, FIRST, COUNT(*) NUMBER_OF_CHILDREN  2 FROM CHILDREN, PEOPLE 3 WHERE PSSN = SSNUMBER 4 GROUP BY LAST, FIRST 5 ORDER BY COUNT(*); LAST FIRST NUMBER_OF_CHILDREN -------------------- -------------------- ------------------ Smythe Ann 2 Smith Fred 3 Jones Adam 4 The GROUP BY with HAVING clause The HAVING clause acts like a selection condition on the attributes which are being grouped Placing a condition on the group SQL> RUN 1 SELECT LAST, FIRST, COUNT(*) NUMBER_OF_CHILDREN 2 FROM CHILDREN, PEOPLE 3 WHERE PSSN = SSNUMBER 4 GROUP BY LAST, FIRST 5 HAVING COUNT(*) > 3 6* ORDER BY COUNT(*) LAST FIRST NUMBER_OF_CHILDREN -------------------- -------------------- ------------------ Jones Adam 4 Grouping by two different attributes SQL> RUN 1 SELECT LNAME, SEX, COUNT(*) 2 FROM CHILDREN 3* GROUP BY LNAME, SEX LNAME S COUNT(*) -------------------- - ---------- Jones F 2 Jones M 2 Smith F 1 Smith M 2 Smythe F 2 Error: ALL scalar attributes must be in GROUP BY clause  SQL> RUN 1 SELECT LNAME, SEX, COUNT(*) 2 FROM CHILDREN 3* GROUP BY LNAME SELECT LNAME, SEX, COUNT(*) * ERROR at line 1: ORA-00979: not a GROUP BY expression Group functions can be nested Basic SELECT with GROUP BY SQL> SELECT AVG(GPA), LNAME 2 FROM CHILDREN 3 GROUP BY LNAME; AVG(GPA) LNAME ---------- -------------------- 3.25 Jones 3.37 Smith Smythe Illegal because LNAME used for outer GROUP, and cannot be used again for inner GROUP SQL> RUN 1 SELECT MAX(AVG(GPA)), LNAME 2 FROM CHILDREN 3* GROUP BY LNAME SELECT MAX(AVG(GPA)), LNAME * ERROR at line 1: ORA-00937: not a single-group group function The correct syntax SQL> SELECT MAX(AVG(GPA)) 2 FROM CHILDREN 3 GROUP BY LNAME; MAX(AVG(GPA)) ------------- 3.37 Oracle Scalar Functions Oracle has a number of functions which operate on individual attributes. These come in many forms: Character Arithmetic Date Conversion Others SQL> SELECT LNAME, FNAME, SQRT(GPA) FROM CHILDREN WHERE GPA>0; LNAME FNAME SQRT(GPA) -------------------- -------------------- ---------- Smith Allen 1.88679623 Smith Albert 1.84390889 Smith Allana 1.77482393 Jones Albert 1.94935887 Jones Eve 1.64316767 Nesting scalar functions SQL> SELECT LNAME, FNAME, ROUND(SQRT(GPA),2) 2 FROM CHILDREN 3 WHERE GPA > 0; LNAME FNAME ROUND(SQRT(GPA),2) -------------------- -------------------- ------------------ Smith Allen 1.89 Smith Albert 1.84 Smith Allana 1.77 Jones Albert 1.95 Jones Eve 1.64 Other scalar function include: TRUNC(n) TRUNC(n, p) SQRT(n) ABS(n) MOD(n, d) POWER(n, p) SIGN(n) Truncating to a particular decimal place SQL> SELECT LNAME, FNAME, TRUNC(ROUND(SQRT(GPA),2),1) 2 FROM CHILDREN 3 WHERE GPA > 0; LNAME FNAME TRUNC(ROUND(SQRT(GPA),2),1) -------------------- -------------------- --------------------------- Smith Allen 1.8 Smith Albert 1.8 Smith Allana 1.7 Jones Albert 1.9 Jones Eve 1.6 More scalar function examples SQL> SELECT FNAME, LNAME, SIGN(GRADE - 8) EIGHT_YEARS_AGO 2 FROM CHILDREN WHERE GRADE > 0; FNAME LNAME EIGHT_YEARS_AGO -------------------- -------------------- --------------- Allen Smith -1 Albert Smith 0 Allana Smith 1 Albert Jones 0 Eve Jones 0 SQL> SELECT POWER(GRADE,3), FLOOR(GPA), CEIL(GPA), GRADE, GPA 2 FROM CHILDREN; POWER(GRADE,3) FLOOR(GPA) CEIL(GPA) GRADE GPA -------------- ---------- ---------- ---------- ---------- 216 3 4 6 3.56 512 3 4 8 3.4 1000 3 4 10 3.15 512 3 4 8 3.8 512 2 3 8 2.7 SQL> SELECT SIGN(ABS(GRADE - 8)), GRADE-8 2 FROM CHILDREN; SIGN(ABS(GRADE-8)) GRADE-8 ------------------ ---------- 1 -2 0 0 1 2 0 0 0 0 Character Scalar Functions SQL> CREATE SYNONYM C FOR CHILDREN; SQL> SELECT UPPER(LNAME) BIG , LOWER(LNAME) SMALL FROM C; BIG SMALL -------------------- -------------------- SMITH smith SMITH smith SMITH smith JONES jones JONES jones JONES jones JONES jones SMYTHE smythe SMYTHE smythe SQL> RUN 1 SELECT LNAME LAST , LENGTH(LNAME) LENGTH, SUBSTR(LNAME,3) 2* FROM C LAST LENGTH SUBSTR(LNAME,3) -------------------- ---------- ------------------ Smith 5 ith Smith 5 ith Smith 5 ith Jones 5 nes Jones 5 nes Jones 5 nes Jones 5 nes Smythe 6 ythe Smythe 6 ythe SQL> SELECT FNAME FIRST_NAME, TRANSLATE(FNAME,'AEIOUaeiou','.....:::::') FROM C; FIRST_NAME TRANSLATE(FNAME,'AEI -------------------- -------------------- Allen .ll:n Albert .lb:rt Allana .ll:n: Albert .lb:rt Eve .v: Sally S:lly Adam .d:m Ann .nn Lynn Lynn Character Scalar Functions SQL> SELECT FNAME FIRST_NAME, LTRIM(FNAME,'AEIOU') NO_INIT_VOWEL 2 FROM C; FIRST_NAME NO_INIT_VOWEL -------------------- -------------------- Allen llen Albert lbert Allana llana Albert lbert Eve ve Sally Sally Adam dam Ann nn Lynn Lynn SQL> RUN 1 SELECT FNAME FIRST_NAME, INITCAP(LTRIM(FNAME,'AEIOU')) NO_INIT_VOWEL 2* FROM C FIRST_NAME NO_INIT_VOWEL -------------------- -------------------- Allen Llen Albert Lbert Allana Llana Albert Lbert Eve Ve Sally Sally Adam Dam Ann Nn Lynn Lynn Character Scalar Functions Padding can be accomplished with LPAD( ) and RPAD( ) scalar functions SQL> RUN 1 SELECT FNAME FIRST, LPAD(FNAME,30) 2* FROM C WHERE NOT LNAME LIKE 'S%' FIRST LPAD(FNAME,30) -------------------- ------------------------------ Albert Albert Eve Eve Sally Sally Adam Adam SQL> RUN 1 SELECT FNAME FIRST, LPAD(FNAME,30,'*') 2* FROM C WHERE NOT LNAME LIKE 'S%' FIRST LPAD(FNAME,30,'*') -------------------- ------------------------------ Albert *************************Albert Eve ***************************Eve Sally ***************************Sally Adam **************************Adam SQL> SELECT FNAME FIRST, INSTR(FNAME,'a') A_AT_INDEX 2 FROM C; FIRST A_AT_INDEX -------------------- ---------- Allen 0 Albert 0 Allana 4 Albert 0 Eve 0 Sally 2 Adam 3 Ann 0 Lynn 0 Character Scalar Functions Selecting only first names which already have an ‘a’ SQL> RUN 1 SELECT FNAME FIRST, INSTR(FNAME,'a') A_AT_INDEX 2 FROM C 3* WHERE FNAME LIKE '%a%' FIRST A_AT_INDEX -------------------- ---------- Allana 4 Sally 2 Adam 3 Two type of calls to SUBSTR  SQL> RUN 1 SELECT FNAME FIRST, SUBSTR(FNAME,2) LESS_ONE, SUBSTR(FNAME,2,2) 2* FROM C WHERE LNAME LIKE 'Sm%' FIRST LESS_ONE SU -------------------- ------------------- -- Allen llen ll Albert lbert lb Allana llana ll Ann nn nn Lynn ynn yn Converting Attribute Values Conversion is possible from numeric to character, from character to numeric, and to date SQL> RUN 1 SELECT GRADE, GPA, SUBSTR(TO_CHAR(GPA),2) 2* FROM CHILDREN GRADE GPA SUBSTR(TO_CHAR(GPA),2) ---------- ---------- --------------------------------------- 6 3.56 .56 8 3.4 .4 10 3.15 .15 8 3.8 .8 8 2.7 .7 The parameter into TO_NUMBER( ) must be convertible to a numeric SQL> SELECT TO_NUMBER(SUBSTR(TO_CHAR(GPA),2))*1000 2 FROM CHILDREN; TO_NUMBER(SUBSTR(TO_CHAR(GPA),2))*1000 -------------------------------------- 560 400 150 800 700 SQL> SELECT TO_CHAR(BIRTHDAY,'MM/DD/YYYY') 2 FROM PEOPLE; TO_CHAR(BI ---------- 04/11/1955 05/03/1962 06/12/1944 09/09/1988 11/23/1951 12/16/1965 11/03/1965 04/11/1965 Converting Attribute Values SQL> RUN 1 SELECT TO_CHAR(BIRTHDAY,'MM/DD/YYYY') BIRTHDAY 2* FROM PEOPLE BIRTHDAY ---------- 04/11/1955 05/03/1962 06/12/1944 09/09/1988 11/23/1951 12/16/1965 11/03/1965 04/11/1965 Works like a switch with a default value at end SQL> SELECT GRADE, DECODE(GRADE, 7,'JR HIGH',8,'JR HIGH',9,'HIGH SCHOOL','GRADE SCHOOL') 2 FROM CHILDREN; GRADE DECODE(GRADE ---------- ------------ 6 GRADE SCHOOL 8 JR HIGH 10 GRADE SCHOOL 8 JR HIGH 8 JR HIGH Converting Attribute Values Example of the concatenation operator | | SQL> SELECT FIRST || ' ' || LAST, 2 SUBSTR(SSNUMBER,1,3) || '-' || SUBSTR(SSNUMBER,4,2) || '-' || 3 SUBSTR(SSNUMBER,6,4) SOCIAL_SECURITY_NUMBER 4 FROM PEOPLE; FIRST||''||LAST SOCIAL_SECU ----------------------------------------- ----------- Joseph Smith 050-66-7744 Fred Smith 454-33-2121 Alice Smith 111-22-3366 Daniel Smith 111-56-7829 Robert Jones 089-55-4321 Adam Jones 765-66-7832 Fred Smythe 221-66-2341 Ann Smythe 056-34-2228 SQL> RUN 1 SELECT RTRIM(FIRST,' ') || ' ' || RTRIM(LAST,' ') Name, 2 SUBSTR(SSNUMBER,1,3) || '-' || SUBSTR(SSNUMBER,4,2) || '-' || 3 SUBSTR(SSNUMBER,6,4) SOCIAL_SECURITY_NUMBER 4* FROM PEOPLE NAME SOCIAL_SECU ----------------------------------------- ----------- Joseph Smith 050-66-7744 Fred Smith 454-33-2121 Alice Smith 111-22-3366 Daniel Smith 111-56-7829 Robert Jones 089-55-4321 Adam Jones 765-66-7832 Fred Smythe 221-66-2341 Ann Smythe 056-34-2228 Typical Date Format examples SQL> RUN 1 SELECT TO_CHAR(BIRTHDAY,'DD/MM/YYYY') , 2 TO_CHAR(BIRTHDAY,'MM/DD/YYYY') DATE_1, 3 TO_CHAR(BIRTHDAY,'Month DD, YYYY') DATE_2, 4 TO_CHAR(BIRTHDAY,'MONTH, YYYY') DATE_3 5* FROM PEOPLE TO_CHAR(BI DATE_1 DATE_2 DATE_3 ---------- ---------- ------------------ --------------- 11/04/1955 04/11/1955 April 11, 1955 APRIL , 1955 03/05/1962 05/03/1962 May 03, 1962 MAY , 1962 12/06/1944 06/12/1944 June 12, 1944 JUNE , 1944 09/09/1988 09/09/1988 September 09, 1988 SEPTEMBER, 1988 23/11/1951 11/23/1951 November 23, 1951 NOVEMBER , 1951 16/12/1965 12/16/1965 December 16, 1965 DECEMBER , 1965 03/11/1965 11/03/1965 November 03, 1965 NOVEMBER , 1965 11/04/1965 04/11/1965 April 11, 1965 APRIL , 1965 Computing Age SQL> RUN 1 SELECT TRUNC((TRUNC(SYSDATE)-BIRTHDAY)/365) AGE, BIRTHDAY 2* FROM PEOPLE  AGE BIRTHDAY ---------- --------- 43 11-APR-55 36 03-MAY-62 54 12-JUN-44 10 09-SEP-88 47 23-NOV-51 33 16-DEC-65 33 03-NOV-65 11-APR-65 Creating Oracle Reports Variables important in report generation are: SPACE Space separation between columns in a report PAGESIZE Lines per report page PAUSE Pauses screen output between pages LINESIZE Maximum column width before wrapping HEADING Turns report headings on or off NUMWIDTH Sets the default numeric width NUMFORMAT Sets the default numeric format FEEDBACK Lists number of selected rows. Can be specified value or turned on or off Setting the Variables SQL> SET FEEDBACK 2 SQL> SELECT * FROM PEOPLE WHERE UPPER(LAST) = 'SMITH'; LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S 4 rows selected. SQL> SET FEEDBACK OFF SQL> RUN 1* SELECT * FROM PEOPLE WHERE UPPER(LAST) = 'SMITH' LAST FIRST BIRTHDAY SSNUMBER M -------------------- -------------------- --------- --------- - Smith Joseph 11-APR-55 050667744 M Smith Fred 03-MAY-62 454332121 M Smith Alice 12-JUN-44 111223366 M Smith Daniel 09-SEP-88 111567829 S Displaying ALL Oracle System Variables SQL> SHOW ALL appinfo is ON and set to "SQL*Plus" arraysize 15 autocommit OFF autoprint OFF autotrace OFF shiftinout INVISIBLE blockterminator "." (hex 2e) btitle OFF and is the 1st few characters of the next SELECT statement cmdsep OFF colsep " " compatibility version NATIVE concat "." (hex 2e) copycommit 0 COPYTYPECHECK is ON define "&" (hex 26) echo ON editfile "afiedt.buf" embedded OFF escape OFF FEEDBACK ON for 6 or more rows flagger OFF flush ON heading ON headsep "|" (hex 7c) linesize 80 lno 14 loboffset 1 long 80 longchunksize 80 newpage 1 null "" numformat "" numwidth 10 pagesize 14 PAUSE is OFF pno 1 recsep WRAP recsepchar " " (hex 20) release 800050000 repfooter OFF and is NULL repheader OFF and is NULL serveroutput OFF showmode OFF spool OFF sqlcase MIXED sqlcode 923 sqlcontinue "> " sqlnumber ON sqlprefix "#" (hex 23) sqlprompt "SQL> " sqlterminator ";" (hex 3b) suffix "sql" tab ON termout ON time OFF timing OFF trimout ON trimspool OFF ttitle OFF and is the 1st few characters of the next SELECT statement underline "-" (hex 2d) USER is "DICHTER" verify ON wrap : lines will be wrapped Example of System Variable Use SQL> SET NUMWIDTH 4 SQL> SELECT GRADE FROM CHILDREN; GRADE ----- 6 8 10 8 8 SQL> SET NUMWIDTH 12 SQL> RUN 1* SELECT GRADE FROM CHILDREN GRADE ------------ 6 8 10 8 8 SQL> SHOW WRAP wrap : lines will be wrapped SQL> SET WRAP OFF SQL> SHOW WRAP wrap : lines will be truncated SQL> COLUMN LN FORMAT A3 HEADING LN SQL> SELECT LNAME LN FROM CHILDREN; LN --- Smi Smi Smi Jon Jon Jon Jon Smy Smy SQL> SELECT LNAME FROM CHILDREN; LNAME -------------------- Smith Smith Smith Jones Jones Jones Jones Smythe Smythe Creating Oracle Reports A PARTS Table SQL> SELECT * FROM PARTS; PNAME PNUMBER PCOST PCOUNT CREATED -------------------- ---------- ---------- ---------- --------- KYK82 WIDGET 1003 6.99 278 06-JAN-89 KYZ82 WIDGET 1004 4.99 200 06-JUN-89 KYM71 WIDGET 1005 2.99 180 13-JUN-90 AYM16 WIDGET 1006 1.99 2500 01-JUN-87 AVM16 WIDGET 1007 8.99 530 01-JUN-89 AXM16 WIDGET 1008 .99 1584 01-AUG-92 SQL Code to create the NEWPARTS Table CREATE TABLE NEWPARTS (PNAME VARCHAR2(20), PNUMBER INTEGER NOT NULL, TYPE CHAR(5) DEFAULT 'MECH', PCOST NUMBER DEFAULT 0, PCOUNT INTEGER DEFAULT 0, CREATED DATE, PRIMARY KEY(PNUMBER)) A nested SQL query to load the NEWPARTS Table from a PARTS Table SQL> RUN 1 INSERT INTO NEWPARTS (PNAME,PNUMBER,PCOST,PCOUNT,CREATED) 2* SELECT * FROM PARTS Creating Oracle Reports Contents of the NEWPARTS Table SQL> SELECT * FROM NEWPARTS; PNAME PNUMBER TYPE PCOST PCOUNT CREATED -------------------- ---------- ----- ---------- ---------- --------- KYK82 WIDGET 1003 MECH 6.99 278 06-JAN-89 KYZ82 WIDGET 1004 ELECT 4.99 200 06-JUN-89 KYM71 WIDGET 1005 METAL 2.99 180 13-JUN-90 AYM16 WIDGET 1006 METAL 1.99 2500 01-JUN-87 AVM16 WIDGET 1007 MECH 8.99 530 01-JUN-89 AXM16 WIDGET 1008 ELECT .99 1584 01-AUG-92 Basic Query SQL> SELECT TYPE, SUM(PCOST), SUM(PCOUNT) 2 FROM NEWPARTS 3 GROUP BY TYPE; TYPE SUM(PCOST) SUM(PCOUNT) ----- ---------- ----------- ELECT 5.98 1784 MECH 15.98 808 METAL 4.98 2680 Adding Detail Lines, but losing summaries SQL> BREAK ON TYPE SKIP 1 SQL> SELECT TYPE, PNUMBER, PCOST FROM NEWPARTS 2 ORDER BY TYPE;  TYPE PNUMBER PCOST ----- ---------- ---------- ELECT 1004 4.99 1008 .99 MECH 1003 6.99 1007 8.99 METAL 1005 2.99 1.99 Creating Oracle Reports Combining the Details with Summaries SQL> BREAK ON TYPE SKIP 1 SQL> COMPUTE SUM OF PCOST ON TYPE SQL> COMPUTE SUM OF PCOUNT ON TYPE SQL> SELECT TYPE, PCOST, PCOUNT FROM NEWPARTS ORDER BY TYPE; TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- sum 5.98 1784 MECH 6.99 278 8.99 530 ***** ---------- ---------- sum 15.98 808 METAL 2.99 180 1.99 2500 ***** ---------- ---------- sum 4.98 2680 Setting a BREAK and Two COMPUTE operations SQL> COMPUTE SUM LABEL TOTAL OF PCOUNT ON TYPE SQL> COMPUTE AVG LABEL AVERAGE OF PCOST ON TYPE SQL> BREAK ON TYPE SKIP 1 SQL> RUN 1 SELECT TYPE, PCOST, PCOUNT 2 FROM NEWPARTS 3* ORDER BY TYPE TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- AVERA 2.99 TOTAL 1784 MECH 6.99 278 8.99 530 ***** ---------- ---------- AVERA 7.99 TOTAL 808 METAL 2.99 180 1.99 2500 ***** ---------- ---------- AVERA 2.49 TOTAL 2680 6 rows selected. The General BREAK Statement The general syntax of the BREAK statement is: BREAK ON [ column | expression | REPORT | PAGE | ROW ] [ SKIP n|PAGE ] [NODUPLICATES|DUPLICATES] There is only ONE BREAK command active at one time, but it may define multiple BREAKs Example: BREAK ON COL_1 SKIP 3 ON COL_2 SKIP 1 Above, we would skip three lines every time the value of COL_1 changes, and one line every time the value of COL_2 changes We would typically write the query as SELECT ….. …. …. ORDER BY COL_1, COL_2 To clear the BREAKs, use SQL> CLEAR BREAKS To list the BREAKs, use SQL> BREAK Specifying Multiple COMPUTE Operations for a Single Attribute SQL> COMPUTE SUM LABEL TOT AVG VAR LABEL VARI OF PCOST ON TYPE SQL> COMPUTE SUM LABEL TOT OF PCOUNT ON TYPE We can list the effective COMPUTE operations with the command COMPUTE SQL> COMPUTE COMPUTE sum LABEL 'TOT' avg LABEL 'avg' variance LABEL 'VARI' OF PCOST ON TYPE COMPUTE sum LABEL 'TOT' OF PCOUNT ON TYPE SQL> RUN 1 SELECT TYPE, PCOST, PCOUNT 2 FROM NEWPARTS 3* ORDER BY TYPE TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- avg 2.99 TOT 5.98 1784 VARI 8 MECH 6.99 278 8.99 530 ***** ---------- ---------- avg 7.99 TOT 15.98 808 VARI 2 METAL 2.99 180 1.99 2500 ***** ---------- ---------- avg 2.49 TOT 4.98 2680 VARI .5 6 rows selected. The general COMPUTE statement is as follows: COMPUTE [ one or more functions ] OF [column or expression ] ON [ column|row|report|page ] Here, three COMPUTE operations are set (on TWO different BREAKs) SQL> COMPUTE SUM LABEL TOT AVG VAR LABEL VARI OF PCOST ON TYPE SQL> COMPUTE SUM LABEL TOT OF PCOUNT ON TYPE SQL> COMPUTE SUM AVG VAR MAX MIN OF PCOST ON REPORT Now, create a two level break (adding the REPORT break) SQL> BREAK ON TYPE SKIP 1 ON REPORT Now, we set the PAGESIZE big enough, and run the REPORT SQL> SET PAGESIZE 50 SQL> run 1 SELECT TYPE, PCOST, PCOUNT 2 FROM NEWPARTS 3* ORDER BY TYPE TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- avg 2.99 TOT 5.98 1784 VARI 8 MECH 6.99 278 8.99 530 ***** ---------- ---------- avg 7.99 TOT 15.98 808 VARI 2 METAL 2.99 180 1.99 2500 ***** ---------- ---------- avg 2.49 TOT 4.98 2680 VARI .5 ---------- avg 4.49 minim .99 maxim 8.99 sum 26.94 varia 9.5 6 rows selected. Adding Top and Bottom Titles to the REPORT Running the same REPORT with TITLES (TTITLE and BTITLE) Use BTITLE and TTITLE commands PARTS ANNUALREPORT TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- avg 2.99 TOT 5.98 1784 VARI 8 MECH 6.99 278 8.99 530 ***** ---------- ---------- avg 7.99 TOT 15.98 808 VARI 2 METAL 2.99 180 1.99 2500 ***** ---------- ---------- avg 2.49 TOT 4.98 2680 VARI .5 ---------- avg 4.49 minim .99 maxim 8.99 sum 26.94 varia 9.5 END OF REPORT 6 rows selected. Here, we access an attribute from the report to generate a DATE heading for the REPORT The NEW_VALUE and OLD_VALUE are mechanisms to avail the TTITLE and BTITLE settings of appropriate query data. The NOPRINT option is specified so that the column does not get printed repeatedly on the detail lines of the REPORT. SQL> TTITLE CENTER ANNUAL SKIP CENTER REPORT SKIP CENTER TODAY SKIP 2 SQL> COLUMN MYDATE FORMAT A9 NEW_VALUE TODAY NOPRINT SQL> SELECT TYPE, PCOST, PCOUNT, TO_CHAR(SYSDATE,'MM-DD-YY') MYDATE 2 FROM NEWPARTS 3 ORDER BY TYPE; ANNUAL REPORT 03-09-99 TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- avg 2.99 TOT 5.98 1784 VARI 8 MECH 6.99 278 8.99 530 ***** ---------- ---------- avg 7.99 TOT 15.98 808 VARI 2 METAL 2.99 180 1.99 2500 ***** ---------- ---------- avg 2.49 TOT 4.98 2680 VARI .5 ---------- avg 4.49 minim .99 maxim 8.99 sum 26.94 varia 9.5 6 rows selected. END OF REPORT Generating Multiple Page REPORTS We can force a Page Break on a BREAK on the TYPE attribute. The TTITLE is displayed on each of the new pages. The Attribute Heading are repeated on each new page  SQL> BREAK ON TYPE SKIP PAGE ON REPORT SQL> SELECT TYPE, PCOST, PCOUNT, TO_CHAR(SYSDATE,'MM-DD-YY') MYDATE 2 FROM NEWPARTS 3 ORDER BY TYPE; The Resulting REPORT ANNUAL REPORT 03-09-99 TYPE PCOST PCOUNT ----- ---------- ---------- ELECT 4.99 200 .99 1584 ***** ---------- ---------- avg 2.99 TOT 5.98 1784 VARI 8 ANNUAL REPORT 03-09-99 TYPE PCOST PCOUNT ----- ---------- ---------- MECH 6.99 278 8.99 530 ***** ---------- ---------- avg 7.99 TOT 15.98 808 VARI 2 ANNUAL REPORT 03-09-99 TYPE PCOST PCOUNT ----- ---------- ---------- METAL 2.99 180 1.99 2500 ***** ---------- ---------- avg 2.49 TOT 4.98 2680 VARI .5 ANNUAL REPORT 03-09-99 TYPE PCOST PCOUNT ----- ---------- ----------  ---------- avg 4.49 minim .99 maxim 8.99 sum 26.94 varia 9.5 6 rows selected. END OF REPORT A REPORT Can be Sent to a File The SPOOL command can send a report to a file The general Syntax is SPOOL [ filename | OFF | ON ] Any QUERY can be a REPORT. The Following Simple sends an SQL query to a file SQL> TTITLE CENTER 'MY REPORT' SQL> BTITLE LEFT 'END OF REPORT' SQL> SPOOL allparts.rep SQL> SELECT * FROM NEWPARTS; MY REPORT PNAME PNUMBER TYPE PCOST PCOUNT CREATED -------------------- ---------- ----- ---------- ---------- --------- KYK82 WIDGET 1003 MECH 6.99 278 06-JAN-89 KYZ82 WIDGET 1004 ELECT 4.99 200 06-JUN-89 KYM71 WIDGET 1005 METAL 2.99 180 13-JUN-90 AYM16 WIDGET 1006 METAL 1.99 2500 01-JUN-87 AVM16 WIDGET 1007 MECH 8.99 530 01-JUN-89 AXM16 WIDGET 1008 ELECT .99 1584 01-AUG-92 END OF REPORT 6 rows selected. SQL> SPOOL OFF SQL> TTITLE OFF SQL> BTITLE OFF Examining the REPORT Contents from within Oracle The HOST command allows to start a console within the Oracle session  SQL> HOST dbase% cat allparts.rep SQL> SELECT * FROM NEWPARTS; MY REPORT PNAME PNUMBER TYPE PCOST PCOUNT CREATED -------------------- ---------- ----- ---------- ---------- --------- KYK82 WIDGET 1003 MECH 6.99 278 06-JAN-89 KYZ82 WIDGET 1004 ELECT 4.99 200 06-JUN-89 KYM71 WIDGET 1005 METAL 2.99 180 13-JUN-90 AYM16 WIDGET 1006 METAL 1.99 2500 01-JUN-87 AVM16 WIDGET 1007 MECH 8.99 530 01-JUN-89 AXM16 WIDGET 1008 ELECT .99 1584 01-AUG-92 END OF REPORT 6 rows selected. SQL> SPOOL OFF dbase% exit SQL> Creating an REPORT Executive File The Contents of the REPORT2.sql File SET TIMING ON SET ECHO OFF SPOOL bigreport.rep TTITLE CENTER BIG SKIP CENTER REPORT SKIP CENTER TODAY SKIP 2 BTITLE LEFT 'END OF PAGE' BREAK ON TYPE SKIP PAGE ON REPORT COMPUTE SUM MAX OF PCOST ON TYPE COMPUTE MIN MAX OF PCOST ON REPORT COMPUTE sum LABEL 'sum' maximum LABEL 'maximum' OF PCOST ON TYPE COMPUTE minimum LABEL 'minimum' maximum LABEL 'maximum' OF PCOST ON REPORT COLUMN MYDATE FORMAT A10 NEW_VALUE TODAY NOPRINT SELECT TYPE, PCOST, PCOUNT, PNAME, TO_CHAR(SYSDATE,'MM-DD-YYYY') MYDATE FROM NEWPARTS ORDER BY TYPE; SPOOL OFF TTITLE OFF BTITLE OFF CLEAR BREAKS CLEAR COMPUTES SET TIMING OFF Running the REPORT Executive File SQL> START REPORT2 BIG REPORT 03-10-1999 TYPE PCOST PCOUNT PNAME ----- ---------- ---------- -------------------- ELECT 4.99 200 KYZ82 WIDGET .99 1584 AXM16 WIDGET ***** ---------- maxim 4.99 sum 5.98 END OF PAGE BIG REPORT 03-10-1999 TYPE PCOST PCOUNT PNAME ----- ---------- ---------- -------------------- MECH 6.99 278 KYK82 WIDGET 8.99 530 AVM16 WIDGET ***** ---------- maxim 8.99 sum 15.98 END OF PAGE BIG REPORT 03-10-1999 TYPE PCOST PCOUNT PNAME ----- ---------- ---------- -------------------- METAL 2.99 180 KYM71 WIDGET 1.99 2500 AYM16 WIDGET ***** ---------- maxim 2.99 sum 4.98 END OF PAGE BIG REPORT 03-10-1999 TYPE PCOST PCOUNT PNAME ----- ---------- ---------- -------------------- ---------- minim .99 maxim 8.99 END OF PAGE 6 rows selected. Elapsed: 00:00:00.03 Printing the REPORT Use any UNIX (or another O/S) utility to print the REPORT SQL> HOST dbase% lp -ddlg bigreport.rep request id is dlg-142 (1 file) dbase% exit dbase% SQL> Creating a Table The DEPARTMENT Table CREATE TABLE DEPARTMENT (DNAME VARCHAR(20), DNUMBER INTEGER NOT NULL, MGRSSN CHAR(9), MGRSTARTDATE DATE, PRIMARY KEY(DNUMBER), FOREIGN KEY(MGRSSN) REFERENCES EMPLOYEES ON DELETE CASCADE); The EMPLOYEES Table CREATE TABLE EMPLOYEES (FNAME VARCHAR(20), MINIT VARCHAR(1), LNAME VARCHAR(20), SSN CHAR(9) NOT NULL, BDATE DATE, ADDRESS VARCHAR(30), SEX VARCHAR(1), SALARY NUMBER, SUPERSSN CHAR(9) NOT NULL, DNO INTEGER, PRIMARY KEY(SSN)); PAGE  PAGE 1 Create a file called SEL.SQL with the current command Load a file called SEL.SQL into the current command INPUT adds a new line to the current buffer save the new command file, but with CREATe option – will not overwrite if command file exists Force command file overwrite Attribute divided by 4 Formant a temporary column Ordering by the temporary column Using nested group function inside an attribute function NOTE: The ROUND function is a scalar function Could also use: ORDER BY 2 SEX attribute cannot be left out of the GROUP BY clause Reformating a DATE attribute Takes from 2nd character on Takes two characters starting from the 2nd character This gives summary lines On TYPE change, create a PAGE BREAK Create a BREAK at the end of the REPORT This is the summary at the end of the REPORT This is the summary on the TYPE BREAK UNIX listing Computing current time Accessing current date Starts a UNIX xterm window Exits UNIX and return to the suspended Oracle session Computing different calculations on COLUMN and REPORT breaks %GZxŽĎ˜Űa¤śůý.6gwäç,  • ˜ ť  9 I M Q S X h   Š Í Ô î  1 5 & , l n Ž t z Ľ Š Ž ˛ × Ü ß ŕ 2TV˘őpƒGWYd{ˆ ł uŽ”šłűűőűđíđíëíűőűăűőűőűőűíűőűíűőűőűíßíđíßíßíűíűíßíđíßíßíßíđŮđíűííßíűíűíßíŮíűíűőűíßíßíßí 6OJQJ6CJ5CJOJQJ5CJOJQJ 56CJ5CJV%GHIJZ[qrsŽĎU˜Űaýűűűýýűűűűűű׳łł×łł#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙őŰÜ7ŕýýýa¤Ľśˇ¸šóôţ`abw¨Úۡˇľľľ°ľľľľľŤľľľˇˇˇ & F & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙=nŁ× + , 5 ? I S ] g q { |  Ž   ™ ş ť ŰŰŰŰÖÔÔÔŰŰŰŰŰŰŰŰŰŰÔÔÔÔÔÔ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ť Ä Î Ř â ě ö   R S h y Ÿ   Š ł ˝ ŰŰŰŰŰŰŰŰŰŰŮÔŮŮŮŮŮ°ŰŰ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙˝ Ç Č Ô é  , 5 Q b ‡ ˆ § Ç ç   & ' 5 F l m n ŰŮŮŮŮŮŮŮŮŮŮŰŰŰŰŮŮÔŮŮŮŮŮŮ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙n Ž î . n o {   Š ł Á Ň × ŕ î ˙ Iۡˇˇľľľľľľľľłľľľľľľˇ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙IŒĎU˜Ű01TUV˘Ł¤ĽÍđţEŰŰŰŰŰŰŰŰŰŮÔŮŮŇŮŮŮŮŮŮŮŮŮŰ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙EFˆËQ•Ř^_opƒ„…ź×Ř34t´ôŰŰŰŰŰŰŰŰŰŰŰŮÔŮŮŮŮŮŰŰŰŰŰŰ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ô4t´ô456FWXdeyz{ˆ‰ŠžŸ łŰŰŰŰŰŰŰŰÖÔÔÔÎÎÎĚÔÔÔÔÔÔÇ & F „Đ`„Đ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ł´ľ%23DPQr~™Ś§ĆÓŕáů)56KýýýýýýýýýýýýýýýýýýýýýýýýýýýýýKXno•ł´šžÓŮßĺëń÷ř,-9KlmýřýýýýÔÔÔÔÔÔÔÔÔýĎýýýýýýý & F #$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F ,&*56{•Ž4şĆş@ĂÄň!" ""ű"ü"B#C#‹#Ě#$R$•$Ů$v%w%ň%ô%8&Z&&Ÿ&č&' '<'_'c'•'Ť'ó'(-(;(A(V([(”()])§)ź)Á)ô)+++!+T+{+ł,ľ,ś,˝,ő,ř,ý, ----*-0-;->-”-űřűřűřűřűřôűřôřôřôřűřôřôřďřďřďřôřôřôřôřďřďřűřôřďřôřűřűřďřűřűřôřűřďřôáôřôřűŰűŰűřűřÔ CJOJQJ 56CJj5CJUmHnHuOJQJ5CJCJ6CJRm€ŽŠśˇ¸ńňó   789LuvŽŻńýýýýýýýřýýýýýóýýýîýýýýĘ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F & F  & F ń4wşý@ƒĆÇŘŮö÷45wşý@ƒŰŰŰŰŰŰŰŰŰŮÔŮŮŮŮ°°°°°#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ƒĆ LM^_Ÿ ĆÇ L  Ň !Y!œ!ß!ŕ!ń!ŰŰŰŰŰŮÔŮŮŮ°°°°°°°°°°#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ń!"""")"_"`"˘"ĺ"(#k#l#m#n#o#Š#‹#Ě#$R$úřřřřřřÔÔÔÔřřřřřř°Ô°#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & FR$•$Ů$%_%˘%Ł%´%ľ%í%&&&&"&,&6&7&Z&[&Ą&ۡŰŰŰľľľľľľŰŰŰŰŰľ°ľľ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙Ą&˘&˝&č&' '<'X'Y'Z'c'Ź'­'Č'ó'(+(,(-(;(<(ýŮپپŮýýýýýŮŮľŮýý°ý & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙<(V(”(•(×()]) )Ą)˘)ź)ő)ö)8*{*ž*++++"+ýýýŮŮľŮýýýýýŮŮŮŮý°ýý & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙"+R+S+T+{+§+Ń+ű+%,O,y,Ł,¤,ł,´,ľ,ö,÷,ř,+-=-ýýýŮľľľľľľľľľýý°ýýýý & Ff#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙=->-X-v-”-˛-Đ-î-ń-ň-ó-ô-0.B.C.i.‘.š.á. /1/ýŮŮپٳýýýýýýýŮŮŮŮŮŮ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙”-˛-Đ-î-ď-ů-..(./.5.@.C.1/4/G/M/j/‚/Ÿ/ /Ľ/Ě/Ü/ů/0X0‰0Ž0¨0Ú0ô1ő1ö1 22/2G2g22œ2283‰3 5 55$5%5+5=5C5}5“5–5Ů5ĺ5(6:6|6”6Ö6Ú6!9a9â9ă9ú9:::: :@:A:F:J:h:i:j:q:űôçäŕÚŕÚäŕäôäÖäŕäŕäŃäŕäŕäÖäŕŃäÖäÖäŕäŕäŕäôôäÖËÖäŕäŕäŕäŕäŕäŕäŕäŃäçäŕäŃäŕäçäŕäÖäÖ 5>*CJOJQJ5CJ 56CJ6CJCJjCJUmHnHu CJOJQJOJQJP1/F/G/j/k/|/}/Ÿ/ /Ľ/ş/Ŕ/Ć/Ç/Ü/Ý/î/ď/0X0Y0Z0ýýýýŮýýýľŮŮŮýýýŮýýýýý#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙Z0[0‡0ˆ0‰0Ś0§0¨0Ú0 1F11¸1ő1 2 2/202A2B2ýřýýýýýÔ°°°°°Ťýýýýý & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & FB2g2h2y2z2œ22Č2330383‰3°3ť3ź3˝3ä3î3ď3đ34Y4d4ƒ4‹4ýýýýýýŮŮŮŮŮ×ŮŮŮŮŮŮŮŮŮŮŮŮŮ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙‹4Ü4Ý45 5%5&5>5}5~55Ž5–5Ô5ć5#6:6w6”6Ń6Ú6ň6/707?7ŰŰŰŰÖÔÔÔÔŰÔÔÔÔÔÔÔÔÔÔÔÔÔŰ & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙?7@7N7`7a7Ą7á7!8a8Ą8á8!9a9Ą9á9â9ô9ő9::!:ýýýýŮŮŮŮŮŮŮľŮŮŮŮýýłý#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙!:/:@:J:X:i:ƒ:„:…:“:Ą:˛:ł:Ô:Ő:ŕ:î:˙:;;1;P;m;n;„;“;”;•;–;ýýýýýřýýýýýýýýýýýýýýýýýýýýýý & Fq:‚:ƒ:…:†:‹:’:¸:Ó:Ő:Ö:Ű:ß:;;!;1;s;„;“;ć;ó;ö;#<&<,</<F<O<‡<ˆ<u=‡?ˆ?Œ??Ť?Ź?­?Á?Ç?@ @ @&@>@™AÍA"CfCD2D7DHDCFEFJFwF|F‹FHH^H|H‚HH•HĽH|I™IúöóćóâóâóćóâóćóâóâóöúöŕŕŕŐÎöóöóöĘÄĘóâóâóâóżóöŕťŕŕťŕťŕŻŕťŕťŕťŕöj5UmHnHu56OJQJ 6>*CJ>*CJ CJOJQJjUmHnHu56CJjCJUmHnHuCJ5CJ 5>*CJE–;—;­;Ž;Ż;Ţ;ô;ő;ö;L<M<N<O<†<‡<‰<ľ<ś<ˇ<¸<Ě<Ő<á<ř<ýřýýýóýýńńńńěńńěńńńČČČČ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & Fd & Fc & Fř<ů<ú<ű<(=)=*=9=G=X=t=u=ľ=ő=5>u>ľ>ő>5?u?v?‡?ˆ?‰?Š?‹?ýýýýýýýýýýýŮŮŮŮŮŮŮŮŮŮý×××#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙‹?Œ?Ť?Ź?­?Ň?Ó?@@@!@>@?@‚@Ć@ ANAOAPAQA’A“A”AÍAÎAýýýýýýýýýýýýŮŮŮŮýýýÔýýýý & F#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ÎABVBšBŢB"CfCŞCîCďCDDD0D1D2DIDŰŰŰŰۡŰŰŰŰľľ°ľľŽ & F #$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙IDkDœDĂDöDEBEjEšEĐEFBFCFDFEFwF‹FŒF¸FĺFG?GkG™GÇGŰŰŰŰŰŰŰŰŰŰŰŮÓŃŮŮŮŰŰŰŰŰŰŰ ĆŕŔ!#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ÇGçGH(HXHYH}HHŚH§HĆHęH I.IWI{I™IšIĆIŮIďIđI'J^J–JŰŰŰŰŮŮŮŮŮŰŰŰŰŰŰÔŮŮŮŮŮŰŰŰ & F #$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙™IŸIĆIËIŘIŢIďIGKHK’K”K™KŸKÇKČKÉKŽMŻM¸MšMžMäMéMöMüM NN$N¸OŃOUPfPwP}PˆP™PĄP§PśPźPÂPÉPĐP×PQQ=Q@QVQoQpQQŻQ¸QŃQÚQóQôQRsRtRuRŒR•R˜RĄR˘R¨RÓRS S2S5S:SoSuS‚S„S…S˝SŔSýůýůýůýíýýëůýýýíýůýůýůýůýčăčßčßčŮßŮßŮßčßčßčăčĚčßčßčßčßčýýůýýůýčýůýůýíýjCJUmHnHu 56CJ6CJOJQJCJ6j5UmHnHu565P–JÎJKGKK‘K’K“K”KČKÉKôKLLLVLŽLÇLM9MrM­MŽMŻM¸MäMŰŰŰŰŮŮ××Ů×ŮŮŮŮŰŰŰŰŰŰŰŮ×ŮŮ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙äM÷M N%N&N^N–NÎNO@OyOˇOĎOĐOŃO)P*P+P>P?PTPUPfPgPPýýýýŮŮŮŮŮŮŮÔýŇŇŇŇŇŇŇŇĐŇŇ & F!#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙P‚P™PšP›PœPŃPŇPQ Q?Q@QVQoQ‡QˆQ‰QŠQąQÓQôQýýýýýýýýýýýŮľľýýýýýý#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ôQRRR)RLRpRqRrRsRtRŒRRŽRĄR˘RŁRŐRúôňÎŚÎňňň¤Ÿ¤¤šň¤¤ & F% & F!'„Đ$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙`„Đ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙„x^„x & F#ŐRÖRäRňRSS S3S4S5SpS„S†S SťS˝SžSżSŔSńSňSóSôSýŮŮŮý×Ň××ýýýýýÍ×××ČÂ×× ĆŕŔ! & F) & F$ & F'#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ŔSńSôSůS$TfTgT“T•TšTÖTŰT UUCUEUFU™UŠUŢUáUćUVV!V'V4VćVçV1W2W:WjWpW…W‹W WŚWşWýXţX2YcYdYjYY…YšY Y´YşYËY[6[‹[’[”[•[°[ľ[ś[¸[Ç[ř[ţ[\\.\4\H\N\a\g\x\7]9]m]‰]Ž]œ]Ą]ľ]ýýůý÷óíóíóíóßóý÷Ű÷Ű÷Ű÷÷÷Ű÷Ű÷Ű÷Ű÷÷ŰĎ÷Ű÷Ű÷Ű÷Ű÷÷Ű÷ýůý÷Ű÷Ű÷Ű÷Ű÷Í÷Ű÷ýůýůýů6j5UmHnHu56j5CJUmHnHu 56CJ5CJ56CJCJQôS&T'T*5OJQJCJWŹ_Ë_Ě_Í_Î_é_ę_ë_``/`0`B`c`u`‡`›`œ``ň`ó`ü`aúřřřóńřńńńńÍÍÍÍÍÇÇ˝řńń  & F7 ĆŕŔ! ĆŕŔ!#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F6 & Fba0aDa`axa‰aťaźa˝ažaŃaŇaíabbb$b2bObPbýýýýýýýűűöýýýýýŇŞŇű'„Đ$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙`„Đ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F8PbQbRbkblbmbĐbŃbŇbÜbÝbčbébîbďbúbűbcccccEcFc}cýűöűűűűýűűűűűűűűűűýýűűűŇ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F9}c´cëc"dYddËdĚdÍdÎdçdčde(e#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙†q¸qíqr?rhr‘rşrăr s6s`sasŹs´sľsßs t&tCt`tŰŰŰŰŰŰŰŰŰŰŰŐÓÓÓŻŻŻŻŻ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ ĆŕŔ!#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙`t}t—tłtÎtčt u*u+u,umuzu{užuÉuäuvv8vQvmv‡v vÄvĹvŰŰŰŰŰŰÖÔÔÔÔÔŰŰŰŰŰŰŰŰŰŰŰÔ & F>#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ĹvĆvÇvĐvw&w'wJwuwwŹwČwäwýwx3xLxgxhx„x…x†xĚxÍxÎxýýýýýýŮŮŮŮŮŮŮŮŮŮŮ×Ňýýýý× & F?#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙Îx×x˙x%y&yKyyźyzLzzz‘z’z›zÇzízîz{O{{ýýýýŮŮŮŮŮŮ××××××׳łł#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ z´z¸zÇzĚzíz#|%|*|>|C|Y|_|e|Ţ}ů}ú}ű}0~2~@~T~Y~o~u~|~~˜~CFefgio}‘—Ťą˝ŕá€*FG °Úßí‚‚‚‚0ƒ;ƒWƒ`ƒÄ„ę„ţ„˙„m…‰……“…š…˘…Š…É…Ď…Ú…R†S†űőűňűňđěęěđěđćđňđěęěđěđěđćđŰň×Ń×Ń×ňĚňćňĚňűňűňćňćňűňćňűňżňćđěđěęěđěđjCJUmHnHuOJQJ 56CJ6CJjUmHnHu5CJ6565CJ 56CJ6CJK{ľ{í{#|$|%|Z|g|h|‰|Ş|Ě|î|}2}T}v}˜}ş}Ý}ů}ŰŰŰŮŮ××׳łłłłłłłłłłŽ & F?#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ů}ú}ű}0~1~2~;~p~|~˜~™~ş~Ű~ý~BCDEFbcdeýűöűűýýýýýŇŇŇŇŇýűűűÍűűű & FA#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & F@efgjklmnox˝ŕá€=€l€›€Ę€ů€()ýűýýýýýýýýýý׳łłłłłý#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙)FG Ą˘ŤÚíî&‚m‚‹‚Ş‚Č‚ç‚ƒƒƒIƒJƒKƒ~ƒ’ƒúřöřřřřřřŇŇŇŇŇŇŇřřÍřřřř & FC#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & FB’ƒ“ƒşƒáƒ „9„e„‘„˝„ž„ż„ë„ý„ţ„ …… …+…6…A…L…W…b…m…ýýóýýýýýýýýýýĎĎĎĎĎĎĎĎĎĎ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ „ „Đ^„ `„Đm…‰…Š…‹…”…Ę…Ű…Ü…ĺ…đ…ű…†††'†2†=†Q†R†S†T†U†…†††úřřřřřřÔÔÔÔÔÔÔÔÔÔřŇřŇÍŇ & FD#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & FBS†T†U†b†„†…†‡†Œ†š† †Ţ†ĺ†ň†Ł‡Á‡Ă‡Ň‡č‡î‡đ‡ő‡ˆˆUˆZˆ†ˆ‹ˆ–ˆşŠťŠĘŠŃŠÖŠěŠńŠ‹‹E‹J‹v‹{‹†‹śÔă ŽŽ5Ž<ŽgŽlŽ“Ž˜Ž¤Ž ‘ ‘‘‘‘U‘[‘g‘h‘:’R’ƒ’ˆ’ˇ’ż’×’Ü’“ “0“8“X“Y“b““‚“Œ“Ť“ýúöúýňđňýňýěýúčúýňýňýňýňýýňđňđňýňýňýňýěúöúöúöúöúöúěúöúöúöŰúěúěúěúěúěúýúŘÔúŃýCJ5CJCJjCJUmHnHu>*CJ5CJ6566CJCJ5Q††‡†ŕ†ô†ő†‡'‡@‡T‡m‡‡•‡Ł‡¤‡Á‡Â‡Ă‡î‡ď‡đ‡ˆUˆ†ˆ˜ˆýűűű×××××××űýŇűűÍýýűűűű & FE & FP#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙˜ˆ™ˆĐˆ‰<‰s‰Ş‰ŕ‰ŠKŠ‚ŠšŠşŠťŠźŠĹŠ‹E‹v‹‡‹ˆ‹Ŕ‹÷‹.ŒeŒœŒýŮŮŮŮŮŮŮŮŮŮý×ýýýýýýýŮŮŮŮŮ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙œŒÓŒ AxśÔŐŢ Ž7ŽgŽ“Ž¤ŽĽŽŘŽRĚ ŰŰŰŰŰÖÔÔÔÔÔÔÔÔ°°°°°°#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & FG#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ FƒŔýţ˙ ‘‘‘V‘g‘i‘~‘”‘Ş‘Ŕ‘Ö‘ě‘’’.’8’9’ŰŰŰŰŮŮÔŮŮŮŮŮŮŮŮŮŮŮŮŮŮĎŮ & FI & FH#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙9’R’S’T’‚’ƒ’ś’ˇ’Ö’×’““/“0“X“Y““‚“Ź“­“”””””-”d”e”úřřřřřřřřřřřřöřöřöřöřřńřřřř & FL & FJŤ“Ź“­“ś“Ć“Ó“ě“î“˙“””””,”2”d”–%–+–/–4–d–ý—ţ—˙—&˜'˜,˜5˜ƒœĄœ˘œ¤œŠœˇœ˝œŘœÚœŕœ  $)CŹÜë ž žTžúžűžŸŸŸŸŸ#Ÿ)Ÿ<ŸYĄ[ĄĄƒĄ´˘ˇ˘Í˘Ń˘Ö˘Ţ˘ř˘ú˘ŁAŁHŁ[ŁdŁ|ŁŽŁűřöňöňöřîřčřäřčřäřäřîřîřîčřîřîřčřäřßřčřäřäřßřßřÜöîöîŘÖŘöňöĐřřĚřîřöňöňöîö>*CJ >*OJQJ>*5>*CJOJQJ6CJ 56CJ5CJ565CJ5CJPe”Š”í”1•u•š•ý•ţ•––&–/–e–f–Ş–î–2—v—ş—ţ—&˜'˜5˜Y˜f˜ŰŰŰŰŰŰŮŮŮŮŮŮŮŮŮŮŮŮŮÔŮŮŮŮ & FQ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙f˜u˜ƒ˜‘˜Ś˜Ă˜ ™™™<™P™]™q™…™™Ž™¤™ą™ź™Ű™ç™đ™ű™šš#š/š7šHšRšýýýýýýýýýýýýýýýýýýýýýýýýýýýýýRšZšgšsššŒš’šžšśšČšâšüš ››$›2›>›O›\›s›…› ›­›´›ż›Č›Ó›Ţ›ě›í›ýýýýýýýýýýýýýýýýýýýýýýýýýýýýýí›3œJœ\œfœƒœ˘œŁœ¤œ¸œŮœÚœŕœćœěœňœřœţœ$DEN[hu‚ýýýýýřýýýýýöýýýýýýýýýýýýýýýý & FM‚œŹÉÜë ž ž ž0žTžUžXž\ž`ždžhžlžpžýýýűýýűýýý××ׯ××××××( ĆŕŔ!$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙pžtžxž|ž„žĽžŚžŹžÁžÇžÍžÓžŮžßžĺžëžňžúžŸŸŸ#Ÿ$Ÿ>Ÿ?ŸŰŰŰŰŰŰŰŰŰŰŰŰŰŰŰŰŰÖÔÔŇŇŇŇ & FJ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙?Ÿ€ŸĹŸ  L  Ň ĄXĄYĄZĄ[ĄĄ‚ĄƒĄ™ĄÁĄęĄ˘L˘ŰŰŰŰŰŰŰŰŮ××ŐĎĎŤŤŤŤŤ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ ĆŕŔ!#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙L˘x˘•˘´˘ľ˘ś˘ˇ˘ř˘ů˘ú˘ŁBŁ_Ł`ŁcŁ|Ł}Ł~ŁŁžŁŰŰł­ŤŤ­­­ŠŠŠŠŠ¤ŠŠŠŤ & FJ ĆŕŔ!( ĆŕŔ!$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ŽŁ–ŁŁžŁŁŁšŁŚ Ś&ŚKŚPŚ]ŚcŚqŚsŚtŚ0§1§F§Z§[§f§g§l§u§y§§†§Ż§ľ§Â§Ä§Ĺ§¨¨Š¨Á¨č¨é¨î¨ŠŠ$Š*ŠGŠHŠMŠgŠhŠvŠƒŠ-Ť.ŤaŤŠŤŤťŤŔŤŐŤŰŤŢŤäŤ˙ŤŹŹŹ%Źř­ŽŽŽýýůý÷ýůýůýůýëýĺŢĺýýůÜůýůýůýëýŘÔŃËŃËŃËŃĆŔĆźŃýźźźźŃźŃźŃź´ý5CJOJQJ6CJ 6OJQJOJQJ 56CJCJ>*CJ5CJ6 56>*CJ 5>*CJj5UmHnHu>*565EžŁťŁźŁ¤O¤š¤ĺ¤/ĽyĽĂĽŚŚ Ś!ŚKŚ^ŚrŚsŚ“Ś´ŚÚŚ§/§0§1§[§ýýŮŮŮŮŮŮŮŮýýýýýýýŮŮŮŮŮý××#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙[§f§g§§°§Ä§Ć§ä§¨#¨D¨E¨d¨ƒ¨„¨Ł¨¨¨Á¨Â¨Ă¨č¨é¨Š%ŠHŠhŠvŠýűýýýýýýýýýýýýýöńűűďűűűűíë & FJ & FUvŠ…Š†Š ŠżŠßŠ˙ŠŞ<Ş=Ş[ŞyŞ˜ŞśŞˇŞ×ŞđŞŤ-ŤYŤZŤ[Ť\Ť‹ŤúřÔÔÔÔÔÔÔÔÔÔÔÔÔÔÔÔĎÍÍÍÍ & FW#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & FV‹ŤťŤŐŤÖŤßŤ˙ŤŹ%Ź&ŹBŹ^ŹzŹ–Ź˛ŹĂŹßŹŕŹüŹ­4­E­a­b­~­š­ś­Ç­ă­ä­ő­ýýýýýýýýýýýýýýýýýýýýýýýýýýýýýő­ö­÷­ŽŽŽDŽEŽFŽŠŽŞŽŤŽŻŻŻŻ ŻŻŻ5Ż6Ż7ŻłŻ´ŻľŻÜŻÝŻŢŻéŻýýřýýýýýýýýýýýýýýýýýýýýýýýýý & FXŽFŽKŽ˝ŽÂŽńŽúŽ˙ŽŻŻ5ŻŢŻ °"°)°9°Q°X°]°a°b° °Ą°˘°§°Ž°ŕ°ć° ąąąVą6´c´ę´ľßľśś(ś š7š:štš“š•šđšJźXźnźŠź­źĹźĆźĘźÓźŘźáźţź˝:˝A˝Ť˝Ź˝´˝č˝í˝ő˝ú˝žžžžůńůńůéßéůńůń×ůé×ůéůńŐŃÍĘÇŃÇĂńÁŃŐńÇĂżżů×ůşůńůńůńůńůşŐśŐŐśŐś56OJQJ5>*>*CJCJCJ6CJ6CJ6>*CJOJQJ56CJOJQJ6CJOJQJ5CJOJQJ CJOJQJHéŻěŻďŻ°° °"°#°7°8°9°Q°R°^°_°`°a° °Ą°˘°á°ąąąVąWąXąeą´ąŢąýýýýýýýýýýýýýýýýýýýýýýýýýýýýý޹߹蹲˛.˛/˛K˛g˛ƒ˛Ÿ˛ť˛Ě˛č˛ů˛ú˛ł2łNł_ł{łŒłłŠłĹłáłýýýýýýŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙áłňł´´ ´!´2´3´4´5´c´d´Ŕ´Á´Â´ľľDľqľĽľŚľŢľßľśśŰŰŰŰŰŰŮŮŮÔŮŮŮŮŮŮŮŮŮŮŮŮŮŮ & FY#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙śś=ś>śSś\ś|śś˘śŁśżśŰś÷śˇ/ˇ@ˇ\ˇmˇnˇŠˇŚˇÂˇÓˇďˇ¸¸ýýýýýýýýýŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙¸¸9¸U¸f¸‚¸“¸”¸Ľ¸ś¸Ç¸Ř¸é¸ú¸ű¸ š7š8š9š:šršsštš“š”šŰŰŰŰŰŰŰŰŰŰŰŰŰŰŰÖÔÔÔÔÔÔÔÔ & FZ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙”š•šÁšđšńš ş)şEşaş}şŽşŞşťşźşŘşôşť!ť=ťNťOťkť‡ťŁť´ťĐťáťâťóťźýýýýýýýýýýýýýýýýýýýýýýýýýýýýýźź&ź7źHźIźJźXźYźjźkźlźmźĹźĆź5˝6˝Ź˝­˝Ž˝Ż˝ő˝*žnžž•ž–žÂžýýýýýýýýýýýýřýóýîýýýýýýýýýý & F] & F\ & F[žž!ž)ž/žmžsž€ž†ž“ž–žż‡Á–ÁˇÁşÁÉÁÓÁcÂeÂgÂ|˜¡ÂßÂĺÂóÂřÂĂĂĂĂŁĂÜĂÝĂoÄôÄżĹDĆǔÇÍÇÎÇGČUČWČXČyȧȨȊȿČŔČČČĐČŢČ/ÉVĚ\Ě]̑ĚÖĚ×ĚŮĚŢĚâĚÍÍxĎýůýýýý÷÷ď÷čďčÝ÷ůýýýď÷Ý÷÷÷Ý÷÷÷ŘŇĎËĎĆ÷ÂÝşłşş CJOJQJ5CJOJQJ>*CJOJQJ6CJCJ >*OJQJOJQJjUmHnHu CJOJQJ5CJOJQJ5566Fžîžżż8żTżpżŒż¨żšżŐżćżçżŔŔ;ŔLŔhŔyŔzŔ–Ŕ˛ŔÎŔßŔűŔ Á ÁÁ/Á@Áýýýýýýýýýýýýýýýýýýýýýýýýýýýýý@ÁQÁbÁsÁtÁuÁ†Á‡Á•ÁˇÁ¸ÁšÁşÁ÷ÁřÁůÁ+Â,Â-ÂaÂbÂcÂdÂeÂhÂiÂjÂkÂlÂýýýýýýýýřýýýóýýóýýóýýýýýýýýý & F_ & F`lÂmÂnÂoÂp™š›œÂŕÂóÂĂĂĂJĂvãäĂŔĂÜĂůĂÄ1ÄBÄ^ÄoěÄÇÄôÄýýýýýýýýýýýřýýýýýýýýýýýýýýýý & F^ôÄőÄĹ-ĹIĹeŁŒŮſĹëĹĆDĆEĆaĆ}ƙƵĆŃĆâĆţĆÇ;ÇgǔǕDZÇÍÇßÇđÇýýýýýýýýýýýýýýýýýýýýýýýýýýýýýđÇČČ#Č4Č5ČFČGČUČVČWČwČxČyȧȨȊȿČŔČŢČßČŕČáČ.É/ÉNÉoɇÉýýýýýýýýýýřöööôňňôôôôôôôôěô ĆŕŔ! & Fg‡É¤ÉĽÉÓÉĘ]ĘŁĘéĘ/ËuËťËĚĚĚĚĚĚ$Ě%Ě4ĚDĚTĚUĚVĚWĚXĚýýýŮŮŮŮŮŮŮŮýýýýýýýýýýýýýý#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙XĚYĚZĚ[Ě\̎̏̐̑ĚÖĚŘĚŮĚăĚűĚÍÍÍÍI͍ÍÓÍÎ_ÎĽÎýýýýřöýýđýöööööýýĚĚĚĚĚĚ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ ĆŕŔ! & FhĽÎëÎ1ĎwĎxĎyĎzĎ{Ď|Ď}Ď~ĎύώϠϡϰϼĎËĎîĎďĎđĎĐĐĐŰŰŰŮ×××××ŮŮŮŮŮŮŮŮŮŇŮ×Đ×× & Fi#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙xĎ}ώϏϰϷϻĎĚĎĐ2ĐFЄЅĐ×ĐÜĐřĐýĐ9ŇCŇDŇ[Ň\҉ұŇGŘ[Ř\ؚؗŘýŘŮŮ&Ů4Ů>ŮňŮÚ#Ú$ÚaÚuڃڌÚôŰőŰöŰüŰýŰţŰÜÜÜÜ Ü Ü Ü÷ĺ÷ăăŰÔŰÂŰÔŰÔ۽ۺÔ÷ľ˛Ź˛˛¨˛Ś˘Ś˛¨˛¨˛ž—”—”—”—Œ—”0JmHnHu0J j0JU6CJ5665CJ 5OJQJCJOJQJCJmH sH #j5CJOJQJUmHnHu CJOJQJ5CJOJQJ5#j5CJOJQJUmHnHu5CJOJQJ7Đ%Đ2ĐFЄПРĐĂĐÄĐĺĐŃIєѕŃĆŃÇŃëŃŇ'Ň8Ň9ŇCŇDŇOŇPŇ[Ň\ŇiŇjŇyŇýýýýýýýýýýýýýýýýýýýýűůýýýůůůůyŇz҉ҊҋҌҰұŇÄŇďŇÓIÓJÓlӝÓĆÓďÓÔÔ"Ô.ÔYԅԳԴÔÖÔŐ0ŐYŐýýűýýöűűűűűűűűűűűűűűűűűűűűűű & FiYŐjŐ{Ռ՘ŐĂŐďŐÖÖ@Öq֚ÖĂÖÔÖĺÖöÖ×-×Yׇ׈ת×Ű×ě×ý×ŘŘŘŘ-Řýýýýýýýýýýýýýýýýýýýýýýýýýýýýý-Ř.ŘFŘ[Ř\Ř]ؘؙؚؗؤŘÂŘáŘíŘôŘŮŮŮŮ&Ů'Ů?ŮfّٴŮýýřööôöööýýýýýýöööýöĐĐĐĐ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ & Fi´ŮÓŮňŮ$Ú]Ú^Ú_Ú`ÚaÚuÚvڍګÚÉÚçÚŰ1ŰOŰtۍ۷ŰŮŰŰۡ۾ľľľľľŰŰŰŰŰŰŰŰŰŰŰ#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ŮŰôŰőŰţŰ˙ŰÜ Ü Ü ÜÜDÜEÜyÜz܌ܧÜÝÝ#Ý$Ý;Ý<ÝWÝXÝŰŮĐĘŮĐĘŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮŮ„h]„h„ř˙„&`#$#$d%d&d'dNĆ˙OĆ˙PĆ˙QĆ˙ ÜÜÜDÜEÜIÜyÜz܌ܧܰܳÜÝÝ#Ý$Ý;Ý<ÝFÝOÝWÝXÝyÝz݇݌ÝŃÝ×ÝáÝâÝňÝţÝ6Ţ7ŢTŢUŢaŢcŢqŢrޚޜާިŢÁŢÂŢĹŢÉŢćŢçŢßß>ß?ß[ß_ßfßu߇ߋߌߍߟߣߤߥ߲߮߳߸ßŔßÁßÇßËßŢßçßčßîß÷ßřß5ŕ7ŕ8ŕűřűřřřôřřřřűřřřôřôřřřřřđřřđřřřěřřřřěřřűřřűřřěřôřřěřôřěřřč6CJ5sHH*sH6sHsH>*sHRXÝyÝzÝłÝáÝâÝňÝýÝţÝ6Ţ7ŢTŢUŢqŢrާިŢÁŢÂŢćŢçŢßß>ß?ßfßgßtßußýýýýýýűýýýýýýýýýýýýýýýőýőýűý ĆŕŔ!uߌߍߤߥßŔßÁß÷ßřß5ŕ6ŕ7ŕ8ŕýýýýýýýýýýýý °Đ/ °ŕ=!°"°# $ %°# 0°Đ/ °ŕ=!°"°# $ %° P 0°Đ/ °ŕ=!°"°# $ %°# 0°Đ/ °ŕ=!°"°# $ %° P 0°Đ/ °ŕ=!°"°# $ %° i0@ń˙0 Normal_HmH sH tH 8@8 Heading 1$@& CJOJQJ4@4 Heading 2$@&5CJ4@4 Heading 3$@&6CJ:@: Heading 4$@&5mHsHu4@4 Heading 5$@&>*CJ<@< Heading 6$ & FV@&6CJP@P Heading 7 $$d%d&d'd@& CJOJQJ0@0 Heading 8$@&>*<A@ň˙Ą< Default Paragraph Font, @ň, Footer  ĆŕŔ!&)@˘& Page Number*B@* Body TextCJNP@"N Body Text 2$d%d&d'd CJOJQJ0Z@20 Plain TextOJQJ7l™ř.JlÔđ)Gdš´Ů1Yg—łę(8Ü˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ ˙˙˙˙ ˙˙˙˙ ˙˙˙˙ ˙˙˙˙ ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙7l™ř.JlÔđ)Gdš´Ů1Yg—łę(+     ˙˙Ž•ě— šúš8ÜŇ˙˙˙˙Ň˙˙˙˙CŇ˙˙˙˙dŇ˙˙˙˙‰Ň˙˙˙˙%GHIJZ[qrsŽĎU˜Űa¤Ľśˇ¸šóôţ`abw¨Ú=nŁ× +,5?IS]gq{|Ž™şťÄÎŘâěö  RShyŸ Šł˝ÇČÔé,5Qb‡ˆ§Çç &'5FlmnŽî. n o {   Š ł Á Ň × ŕ î ˙     I Œ Ď  U ˜ Ű   0 1 T U V ˘ Ł ¤ Ľ Í đ ţ    E F ˆ Ë Q•Ř^_opƒ„…ź×Ř34t´ô4t´ô456FWXdeyz{ˆ‰ŠžŸ ł´ľ%23DPQr~™Ś§ĆÓŕáů)56KXno•ł´šžÓŮßĺëń÷ř,-9Klm€ŽŠśˇ¸ńňó   789LuvŽŻń4wşý@ƒĆÇŘŮö÷45wşý@ƒĆ LM^_Ÿ ĆÇ LŇYœßŕń)_`˘ĺ(klmnoŠ‹Ě R • Ů !_!˘!Ł!´!ľ!í!"""""","6"7"Z"["Ą"˘"˝"č"# #<#X#Y#Z#c#Ź#­#Č#ó#$+$,$-$;$<$V$”$•$×$%]% %Ą%˘%ź%ő%ö%8&{&ž&''''"'R'S'T'{'§'Ń'ű'%(O(y(Ł(¤(ł(´(ľ(ö(÷(ř(+)=)>)X)v)”)˛)Đ)î)ń)ň)ó)ô)0*B*C*i*‘*š*á* +1+F+G+j+k+|+}+Ÿ+ +Ľ+ş+Ŕ+Ć+Ç+Ü+Ý+î+ď+,X,Y,Z,[,‡,ˆ,‰,Ś,§,¨,Ú, -F--¸-ő- . ./.0.A.B.g.h.y.z.œ..Č.//0/8/‰/°/ť/ź/˝/ä/î/ď/đ/0Y0d0ƒ0‹0Ü0Ý01 1%1&1>1}1~11Ž1–1Ô1ć1#2:2w2”2Ń2Ú2ň2/303?3@3N3`3a3Ą3á3!4a4Ą4á4!5a5Ą5á5â5ô5ő566!6/6@6J6X6i6ƒ6„6…6“6Ą6˛6ł6Ô6Ő6ŕ6î6˙67717P7m7n7„7“7”7•7–7—7­7Ž7Ż7Ţ7ô7ő7ö7L8M8N8O8†8‡8‰8ľ8ś8ˇ8¸8Ě8Ő8á8ř8ů8ú8ű8(9)9*999G9X9t9u9ľ9ő95:u:ľ:ő:5;u;v;‡;ˆ;‰;Š;‹;Œ;Ť;Ź;­;Ň;Ó;<<<!<><?<‚<Ć< =N=O=P=Q=’=“=”=Í=Î=>V>š>Ţ>"?f?Ş?î?ď?@@@0@1@2@I@k@œ@Ă@ö@ABAjAšAĐABBBCBDBEBwB‹BŒB¸BĺBC?CkC™CÇCçCD(DXDYD}DDŚD§DĆDęD E.EWE{E™EšEĆEŮEďEđE'F^F–FÎFGGGG‘G’G“G”GČGÉGôGHHHVHŽHÇHI9IrI­IŽIŻI¸IäI÷I J%J&J^J–JÎJK@KyKˇKĎKĐKŃK)L*L+L>L?LTLULfLgLL‚L™LšL›LœLŃLŇLM M?M@MVMoM‡MˆM‰MŠMąMÓMôMNNN)NLNpNqNrNsNtNŒNNŽNĄN˘NŁNŐNÖNäNňNOO O3O4O5OpO„O†O OťO˝OžOżOŔOńOňOóOôO&P'P—O—\—s—…— —­—´—ż—Č—Ó—Ţ—ě—í—3˜J˜\˜f˜ƒ˜˘˜Ł˜¤˜¸˜Ů˜Ú˜ŕ˜ć˜ě˜ň˜ř˜ţ˜™™™$™D™E™N™[™h™u™‚™™œ™™Ź™É™Ü™ë™ š š š0šTšUšXš\š`šdšhšlšpštšxš|š„šĽšŚšŹšÁšÇšÍšÓšŮšßšĺšëšňšúš›››#›$›>›?›€›Ĺ› œLœœŇœXYZ[‚ƒ™ÁęžLžxž•ž´žľžśžˇžřžůžúžŸBŸ_Ÿ`ŸcŸ|Ÿ}Ÿ~ŸŸžŸťŸźŸ O š ĺ /ĄyĄĂĄ˘˘ ˘!˘K˘^˘r˘s˘“˘´˘Ú˘Ł/Ł0Ł1Ł[ŁfŁgŁŁ°ŁÄŁĆŁäŁ¤#¤D¤E¤d¤ƒ¤„¤Ł¤¨¤Á¤Â¤Ă¤č¤é¤Ľ%ĽHĽhĽvĽ…Ľ†Ľ ĽżĽßĽ˙ĽŚ<Ś=Ś[ŚyŚ˜ŚśŚˇŚ×ŚđŚ§-§Y§Z§[§\§‹§ť§Ő§Ö§ß§˙§¨%¨&¨B¨^¨z¨–¨˛¨Ă¨ß¨ŕ¨ü¨Š4ŠEŠaŠbŠ~ŠšŠśŠÇŠăŠäŠőŠöŠ÷ŠŞŞŞDŞEŞFŞŠŞŞŞŤŞŤŤŤŤ ŤŤŤ5Ť6Ť7ŤłŤ´ŤľŤÜŤÝŤŢŤéŤěŤďŤŹŹ Ź"Ź#Ź7Ź8Ź9ŹQŹRŹ^Ź_Ź`ŹaŹ ŹĄŹ˘ŹáŹ­­­V­W­X­e­´­Ţ­ß­č­ŽŽ.Ž/ŽKŽgŽƒŽŸŽťŽĚŽčŽůŽúŽŻ2ŻNŻ_Ż{ŻŒŻŻŠŻĹŻáŻňŻ°° °!°2°3°4°5°c°d°Ŕ°Á°Â°ąąDąqąĽąŚąŢąßą˛˛˛=˛>˛S˛\˛|˛˛˘˛Ł˛ż˛Ű˛÷˛ł/ł@ł\łmłnłŠłŚłÂłÓłďł´´´9´U´f´‚´“´”´Ľ´ś´Ç´Ř´é´ú´ű´ ľ7ľ8ľ9ľ:ľrľsľtľ“ľ”ľ•ľÁľđľńľ ś)śEśaś}śŽśŞśťśźśŘśôśˇ!ˇ=ˇNˇOˇkˇ‡ˇŁˇ´ˇĐˇáˇâˇóˇ¸¸&¸7¸H¸I¸J¸X¸Y¸j¸k¸l¸m¸Ĺ¸Ć¸5š6šŹš­šŽšŻšőš*şnşş•ş–şÂşîşťť8ťTťpťŒť¨ťšťŐťćťçťźź;źLźhźyźzź–ź˛źÎźßźűź ˝ ˝˝/˝@˝Q˝b˝s˝t˝u˝†˝‡˝•˝ˇ˝¸˝š˝ş˝÷˝ř˝ů˝+ž,ž-žažbžcždžežhžižjžkžlžmžnžožpž™žšž›žœžŕžóžżżżJżvżŁż¤żŔżÜżůżŔ1ŔBŔ^ŔoŔ›ŔÇŔôŔőŔÁ-ÁIÁeÁÁ’ÁŽÁżÁëÁÂDÂEÂaÂ}™µÂŃÂâÂţÂĂ;ĂgÔÕñĂÍĂßĂđĂÄÄ#Ä4Ä5ÄFÄGÄUÄVÄWÄwÄxÄyħĨĊĿÄŔÄŢÄßÄŕÄáÄ.Ĺ/ĹNĹoŇŤťĹÓĹĆ]ĆŁĆéĆ/ÇuÇťÇČČČČČČ$Č%Č4ČDČTČUČVČWČXČYČZČ[Č\ȎȏȐȑČÖČŘČŮČăČűČÉÉÉÉIɍÉÓÉĘ_ĘĽĘëĘ1ËwËxËyËzË{Ë|Ë}Ë~Ëˍˎˠˡ˰˼ËËËîËďËđËĚĚĚ%Ě2ĚF̟̠̄ĚĂĚÄĚĺĚÍI͔͕ÍĆÍÇÍëÍÎ'Î8Î9ÎCÎDÎOÎPÎ[Î\ÎiÎjÎyÎzΉΊ΋ΌΰαÎÄÎďÎĎIĎJĎlϝĎĆĎďĎĐĐ"Đ.ĐYЅгдĐÖĐŃ0ŃYŃjŃ{ьјŃĂŃďŃŇŇ@ŇqҚŇĂŇÔŇĺŇöŇÓ-ÓYӇӈӪÓŰÓěÓýÓÔÔÔÔ-Ô.ÔFÔ[Ô\Ô]ԗԘԙԚԤÔÂÔáÔíÔôÔŐŐŐŐ&Ő'Ő?ŐfՑմŐÓŐňŐ$Ö]Ö^Ö_Ö`ÖaÖuÖv֍֫ÖÉÖçÖ×1×O×t׍׷×Ů×ô×ő×Ř Ř ŘŘDŘEŘyŘz،اŘŮŮ#Ů$Ů;Ů<ŮWŮXŮyŮzŮłŮáŮâŮňŮýŮţŮ6Ú7ÚTÚUÚqÚrÚ§Ú¨ÚÁÚÂÚćÚçÚŰŰ>Ű?ŰfŰgŰtŰuیۍۤۥŰŔŰÁŰ÷ŰřŰ5Ü9Ü€€˜0€€˜€˜€€€€€˜€U˜€U˜€U˜€U˜€U˜€U€€˜€š˜€š˜€š€€˜€Ł˜€Ł€Ł˜€l˜€l˜€l˜€l˜€l˜ €l˜€l˜€l˜€l˜€l˜€l˜ 0€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜ €l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜€l˜ €l˜€l˜€l˜€l˜€l˜€l€€˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜ €Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť˜€Ť€€˜€y˜€y˜€y˜€y˜€y˜€y˜€y˜€y˜€y˜€y˜€y€€˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜€â ˜ €â ˜€â ˜€â €â ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜ €a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a ˜ €a ˜€a ˜€a ˜€a ˜€a ˜€a ˜€a €€˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜ €†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†˜€†€€˜€–€€˜€ €€˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜€  ˜ €  ˜€  ˜€  ˜€  ˜€  ˜€  €€˜€ó"€€˜€+#˜€+#˜€+#˜€+#˜€+#˜€+#˜€+#˜€+#€€˜€ţ#˜€ţ#˜€ţ#˜ €ţ#˜€ţ#˜€ţ#˜€ţ#˜€ţ#˜€ţ#˜€ţ#€€˜€%%˜€%%˜€%%˜€%%˜€%%˜€%%˜€%%˜€%%˜€%%˜€%%˜€%%˜ €%%˜€%%˜€%%˜€%%˜€%%˜€%%€€˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜f €_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'˜€_'€€˜€Ÿ)h€Ÿ)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)˜€Ű)€€˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜ €Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+˜€Ť+€€˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜ €ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜ €ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,˜€ł,€€˜€,5˜€,5˜€,5˜€,5˜€,5˜€,5€€˜€6˜€6˜€6˜€6˜€6˜€6˜ €6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜ €6˜€6˜€6˜€6˜c €6˜€6˜€6˜€6˜€6˜€6˜€6˜d €6˜€6˜€6˜d €6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜ €6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6˜€6€€˜€-?˜€-?˜€-?˜€-?˜€-?˜€-?˜ €-?˜€-?˜€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?˜€MB˜€MB€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?˜ €bE€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?˜€œG˜€œG€-?˜€ŸG€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?˜€¸I€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?€-?! €-?€-?˜€ÚK˜€ÚK˜€ÚK˜€ÚK˜€ÚK˜€ÚK˜€ÚK˜€ÚK€€˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L˜€`L€€˜€KM˜€KM˜€KM˜€KM˜€KM˜€KM˜€KM˜€KM˜# €KM˜€KM˜€KM˜€KM˜€KM˜€KM˜€KM˜€KM˜€KM€KM! €KM€KM€KM% €KM˜€™N€KM€KM€KM€KM€KM€KM€KM˜€O˜' €O˜€O˜€O€KM€KM€KM€KM€KM$ €KM˜€ĆO˜€ĆO˜€ĆO˜) €ĆO˜€ĆO˜€ĆO˜€ĆO˜€ĆO˜€ĆO˜€ĆO˜€ĆO˜€ĆO˜€ĆO* €KM€KM€KM€KM€KM€KM€KM€KM€KM€KM+ €KM, €KM€KM˜€˛Q˜- €˛Q€KM˜€ęQ€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM˜€đR. €KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM˜€U/ €KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM0 €KM€KM€KM˜€BW˜2 €BW˜€BW˜€BW€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM€KM˜€Y˜€Y˜1 €Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y˜€Y€€€™Z4 €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Zb €™Z˜€ˇ[˜€ˇ[˜€ˇ[6 €™Z€™Z˜€ô[€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€’\˜€’\˜7 €’\˜€’\€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€Ć]˜€Ć]8 €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€=^˜€=^€™Z9 €™Z€™Z€™Z€™Z€™Z˜€Ű^€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€ _˜€ _€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€Ö`˜€Ö`: €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z; €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€sc< €™Z˜€uc€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z= €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€2h€™Z€™Z€™Z€™Z˜€‡h€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€Aj˜€Aj˜€Aj€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z> €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m˜€m€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z> €™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€Wt˜? €Wt€™Z€™Z€™Z€™Z˜€×t€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv˜€Wv€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜? €Ĺy€™Z˜€z˜@ €z˜€z˜€z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z€™Z˜€M{˜€M{˜€M{˜A €M{˜€M{˜€M{˜€M{˜€M{€™Z˜€q{˜€q{˜€q{˜€q{˜€q{˜€q{˜€q{˜€q{˜€q{˜€q{€€˜€ě{˜€ě{˜€ě{˜€ě{˜€ě{˜€ě{˜€ě{˜B €ě{˜€ě{€€˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜C €R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜€R}˜B €R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}˜€\‚€R}˜€^‚˜D €^‚˜€^‚˜€^‚€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}˜€ ƒ˜P € ƒ€R}€R}˜E €Íƒ˜€Íƒ˜€Íƒ€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}˜€Ä†€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}€R}˜G €ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜H €ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜I €ƒ‰˜€ƒ‰˜J €ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰˜€ƒ‰€R}˜€;€R}˜€d€R}˜€€R}˜€¸˜€¸˜L €¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜Q €¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜`€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜@€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜€¸˜M €¸˜€¸˜€¸˜€¸˜€¸˜€¸€€˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜˜€ĺ˜€€˜€¨™˜€¨™€€˜€ç™˜€ç™˜`€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜€ç™˜@€ç™˜J €ç™˜€ç™˜€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™€ç™˜€c˜€c€€˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f˜€f€f€f€f€f€f˜J €kŸ€f€f€f˜€‰Ÿ€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f€f˜€:Ł˜€:Ł€f˜€fŁ€f€f€f€f€f€f€f€f€f€f€f€f€fU €f˜J €Ž¤˜€Ž¤˜€Ž¤H€Ž¤˜€Î¤˜€Î¤˜€Î¤˜€Î¤€€XV €SĽ˜V €sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽ˜€sĽW €SĽ˜€7§˜€6§˜€5§˜€4§˜€3§˜€2§˜€1§˜€0§˜€/§˜€.§˜€-§˜€,§˜€+§˜€*§˜€)§˜€(§˜€'§˜€&§˜€%§˜€$§˜€#§˜€"§˜€!§˜€ §˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜X €§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€ §˜€ §˜€ §˜€ §˜€ §˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€§˜€˙Ś˜€ţŚ˜€ýŚ˜€üŚ˜€űŚ˜€úŚ˜€ůŚ˜€řŚ˜€÷Ś˜€öŚ˜€őŚ˜€ôŚ˜€óŚ˜€ňŚ˜€ńŚ˜€đŚ˜€ďŚ˜€îŚ˜€íŚ˜€ěŚ˜€ëŚ˜€ęŚ˜€éŚ˜Y €éŚ˜€čŚ˜€çŚ˜€ćŚ˜€ĺŚ˜€äŚ˜€ăŚ˜€âŚ˜€áŚ˜€ŕŚ˜€ßŚ˜€ŢŚ˜€ÝŚ˜€ÜŚ˜€ŰŚ˜€ÚŚ˜€ŮŚ˜€ŘŚ˜€×Ś˜€ÖŚ˜€ŐŚ˜€ÔŚ˜€ÓŚ˜€ŇŚ˜€ŃŚ˜€ĐŚ˜€ĎŚ˜€ÎŚ˜€ÍŚ˜€ĚŚ˜€ËŚ˜€ĘŚ˜€ÉŚ˜€ČŚ˜€ÇŚ˜€ĆŚ˜€ĹŚ˜€ÄŚ˜€ĂŚ˜€ÂŚ˜€ÁŚ˜€ŔŚ˜€żŚ˜€žŚ˜€˝Ś˜€źŚ˜€ťŚ˜€şŚ˜€šŚ˜€¸Ś˜€ˇŚ˜€śŚ˜€ľŚ˜€´Ś˜€łŚ˜Z €˛Ś˜€ąŚ˜€ąŚ˜€ąŚ˜€ąŚ˜€ąŚ˜€ąŚ˜€ąŚ˜€°Ś˜€°Ś˜€ŻŚ˜€ŽŚ˜€­Ś˜€ŹŚ˜€ŤŚ˜€ŞŚ˜€ŠŚ˜€¨Ś˜€§Ś˜€ŚŚ˜€ĽŚ˜€¤Ś˜€ŁŚ˜€˘Ś˜€ĄŚ˜€ Ś˜€ŸŚ˜€žŚ˜€Ś˜€œŚ˜€›Ś˜€šŚ˜€™Ś˜€˜Ś˜€—Ś˜€–Ś˜€•Ś˜€”Ś˜€“Ś˜€’Ś˜€‘Ś˜€Ś˜€Ś˜€ŽŚ˜€Ś˜€ŒŚ˜€‹Ś˜€ŠŚ˜€‰Ś˜€ˆŚ˜[ €ˆŚ˜€ˆŚ˜\ €‡Ś˜€†Ś˜] €…Ś˜€„Ś˜€ƒŚ˜€‚Ś˜€Ś˜€€Ś˜€Ś˜€~Ś˜€}Ś˜€|Ś˜€{Ś˜€zŚ˜€yŚ˜€xŚ˜€wŚ˜€vŚ˜€uŚ˜€tŚ˜€sŚ˜€rŚ˜€qŚ˜€pŚ˜€oŚ˜€nŚ˜€mŚ˜€lŚ˜€kŚ˜€jŚ˜€iŚ˜€hŚ˜€gŚ˜€fŚ˜€eŚ˜€dŚ˜€cŚ˜€bŚ˜€aŚ˜€`Ś˜€_Ś˜€^Ś˜€]Ś˜€\Ś˜€[Ś˜€ZŚ˜€YŚ˜€XŚ˜€WŚ˜€VŚ˜` €VŚ˜€VŚ˜€VŚ˜€VŚ˜_ €UŚ˜€UŚ˜€UŚ˜_ €UŚ˜€UŚ˜€UŚ˜_ €UŚ˜€UŚ˜€UŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€TŚ˜€SŚ˜€RŚ˜€RŚ˜€RŚ˜€RŚ˜€QŚ˜€PŚ˜^ €PŚ˜€PŚ˜€OŚ˜€NŚ˜€MŚ˜€LŚ˜€KŚ˜€JŚ˜€IŚ˜€HŚ˜€GŚ˜€FŚ˜€EŚ˜€DŚ˜€CŚ˜€BŚ˜€AŚ˜€@Ś˜€?Ś˜€>Ś˜€=Ś˜€<Ś˜€;Ś˜€:Ś˜€9Ś˜€8Ś˜€7Ś˜€6Ś˜€5Ś˜€4Ś˜€3Ś˜€2Ś˜€1Ś˜€0Ś˜€/Ś˜€.Ś˜€-Ś˜€,Ś˜€+Ś˜€*Ś˜€)Ś˜€(Ś˜€'Ś˜€&Ś˜€%Ś˜€$Ś˜€#Ś˜€"Ś˜€!Ś˜€ Ś˜€Ś˜€Ś˜€Ś˜€Ś˜€Ś˜€Śg €5¤€5¤€5¤€5¤˜€„Ä€€€€˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Ä˜€´Äh €´Ä€´Ä˜€™Č˜€™Č˜€™Č˜€™Č€´Ä€´Ä€´Ä€´Ä€´Ä˜€#ɘ€#É€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä˜€‚˘€‚˘€‚˘€‚˘€‚Ë€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Ä€´Äi €´Ä€´Ä˜€ůËx€ů˘€ű˘€űË€´Ä€´Ä€´Ä€´Ä€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€8€CΘ€D΀€€€€€˜€[Θ€[Θ€[Θ€[Θ€[Θ€[΀€˜€”Θ€”Îi €€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€€i €€˜€€˜€€H€€˜€€˜€€˜€€€€€€€€€€€€€€˜€€˜€€˜€€€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€(€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜€€˜0€€š@€€˜@0€€˜@€€ ˜0€€š€€˜0€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€˜€€š€€˜€€8€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€˜€€š€€8€€š€€˜0€€š€€˜0€€š€€˜€€š€€˜€€š€€˜€€š€€ ”-q:™IŔSľ]Ýg zS†Ť“ŽŁŽžxĎ Ü8ŕs€Š‘˜ž¤Ť˛šżČÎÖßćať ˝ n IEôłKmńƒń!R$Ą&<("+=-1/Z0B2‹4?7!:–;ř<‹?ÎAIDÇG–JäMPôQŐRôSŕUťX¸[ś]Ź_aPb}c˙fóg*lEo†q`tĹvÎx{ů}e)’ƒm…††˜ˆœŒ 9’e”f˜Rší›‚pž?ŸL˘žŁ[§vŠ‹Ťő­éŻŢąáłś¸”šźÂž@ÁlÂôÄđLJÉXĚĽÎĐyŇYŐ-Ř´ŮŮŰXÝuß8ŕtvwxyz{|}~‚ƒ„…†‡ˆ‰‹ŒŽ’“”•–—™š›œŸ Ą˘ŁĽŚ§¨ŠŞŹ­ŽŻ°ął´ľśˇ¸şťź˝žŔÁÂĂÄĹĆÇÉĘËĚÍĎĐŃŇÓÔŐ×ŘŮÚŰÜÝŢŕáâăäĺçč7ŕu !•!˙•€đ@đ  đ0e‚˜˛ƒ0e„˜˛…‡ˆ‰ż ô   €˙˙˙‚ƒ˙˙˙„… †A‡Áˆ‰Š‹ŒŽ‘’“”•–—Á˜™š›œ@żŔÁÂ˙˙˙Ă ÄĹAĆÁÇČÉĘË5%ĚÍÎĎÁ×˙€€€ËËË 8c8c     ?€‚ƒœ1„…đů†‡÷ˆ żŔÁÂdĂÄĹĆÇČÉĘ0uËĐĚ0íě˙Í@T‰Î€Ď€˙˙Đy˙Ń2Ň NÓPĂÔŐ'Öp”×°<˙˙ŘŮ'Úp”˙A¨)BCD|žE„|ž…†|ž‡@ń˙˙˙€€€÷đjđđpđ( đđn°n đđž đ ă đT€Ghš˙˙H ď˙˙IŰË˙˙J€KŽü˙˙L€MŻ˜˙˙N€é˙˙¨)XÖţ˙?ż "ńż€đđ đđž đ ă đT€G–˙˙H Ť˙˙IťÉ˙˙J€KŽü˙˙L€M ˙˙NŔš˙˙¨)XÖţ˙?ż "ńż€đđ đđ° đ  đf€żG °˙˙HIÖ˙˙JŒK—ű˙˙LŒM °˙˙Nż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żG ˘˙˙HvI‰Ď˙˙J­KZü˙˙L­M ˘˙˙Nvż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żG‹˙˙H‹IČĂ˙˙JŒK—ű˙˙LŒM5ˇ˙˙N˙˙ż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żGLÔ˙˙HŰđ˙˙Iâç˙˙JöK%ű˙˙LöMLÔ˙˙NŰđ˙˙ż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żG+˙˙H~XIçž˙˙J˛Kłű˙˙L˛M+˙˙N~Xż˙¨)XÖţ˙?ż"ńż€đ đ đđž đ  ă đT€żGwk˙˙HŽDIƲ˙˙Mwk˙˙NŽDż˙¨)XÖţ˙?ż"ńż€đ đ đđ° đ   đf€ żG'ľ˙˙HŘ'I Ů˙˙JK_ü˙˙LMç¨˙˙Nż˙¨)XÖţ˙?ż"ńż€đ đ đ đ¤ đ  ó đZ€ żGٚ˙˙H=CIĚË˙˙K ü˙˙Mٚ˙˙N=Cż˙¨)XÖţ˙?ż"ńż€đđ đ đ° đ   đf€ żGşĄ˙˙Hđ#ISĎ˙˙JŔK;ü˙˙LŔMşĄ˙˙Nđ#ż˙¨)XÖţ˙?ż"ńż€đđ đ đ° đ   đf€ żGŽ˙˙HFIäÔ˙˙J‹Kű˙˙L‹MŻ–˙˙N‚mż˙¨)XÖţ˙?ż"ńż€đđ đ đ° đ  đf€ żGŞHןI™JKąYLMŢNŮžż˙¨)XÖţ˙?ż "ńż€đđ đ đ° đ  đf€żGď}H7§IkJiKjYLiMśNžż˙¨)XÖţ˙?ż "ńż€đđ đđ° đ  đf€żG×˙˙H(×Iďé˙˙JPKü˙˙LPMŐ˙˙N8ż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żGî˜HßlIďyJă Kh[Lă Mî˜Nßlż˙¨)XÖţ˙?ż "ńż€đđ đđŞ đ  đ`€żGLŇ˙˙HIŔĺ˙˙Jé Lé MLŇ˙˙Nż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żGu…˙˙H>YI[Ł˙˙JyKűű˙˙LyMůˆ˙˙NCLż˙¨)XÖţ˙?ż"ńż€đđ đđ° đ  đf€żGˆ–˙˙HŮgI%°˙˙JyKűű˙˙LyMę{˙˙NK׿˙¨)XÖţ˙?ż"ńż€đđ đđb đ c đ$żż˙?ż "ńż€đ đđn đ ƒ đ0żż˙?ż˙ż "ńż€đ đđž đ ă đT€żGĚa˙˙HœzIř­˙˙MĚa˙˙Nœzż˙¨)XÖţ˙?ż"ńż€đđ đđŞ đ  đ`€żGH^˙˙Hd1I6Ź˙˙J…L…M¸*˙˙Nd1ż˙¨)XÖţ˙?ż"ńż€đđ đđŞ đ  đ`€żGĐŐ˙˙HQRI‚ç˙˙J…L…MŔ1˙˙N‡öţ˙ż˙¨)XÖţ˙?ż"ńż€đđ đđn đ ƒ đ0żż˙?ż˙ż "ńż€đđđn đ ƒ đ0żż˙?ż˙ż "ńż€đđđ° đ  đf€żG~K˙˙H-IŚŁ˙˙J@Kxú˙˙L@MQ˙˙N`ż˙¨)XÖţ˙?ż"ńż€đđ đđž đ ă đT€żG„˙˙H`TI^Ŕ˙˙JĂKČű˙˙LĂM„˙˙N`Tż˙?"ńż€đđ đđ¤ đ ó đZ€żGÂ˙˙Hą8IŔß˙˙KŠü˙˙MÂ˙˙Ną8ż˙¨)XÖţ˙?ż"ńż€đđ đđB đS đżË˙ ?đŸđđđđđđđ đ đ đ đ đ đ đđđđđ đ"đ#đ%đ'đ(đ*đ,đ.ľ(î)â5@6…6Ő67‡8DGG¸IoM„OEQcUěZg{h{ţ€gs˘ÄŁežfžÜżÍĂÖȎ˄Ě8Ü„˙$"3tüżœ"ót'GŁ ęt5” Řtú” tOt"ZtŮÖĐ [tšű: ťtS2x{t5,h“t SŇó’t cI Mtˆ˙˙˙ŔZźtÓ˙˙˙ďÓct Đ "t c–ŕŔtý×UtďŁ` t ćtú˙˙í!5ý˙˙tÓ˙˙˙Č0 ź tľü˙˙í! ˙˙˙tľ˙˙˙ňfA tW ÷tâ˙˙˙s‚ćtšü˙˙˙‘#třĐ t á0Ďtü\]tsŕĂtRY˝Ä%ÜăV ] šŔZnˆ•°ÂęőŠ“U^`g—Ľ.2.'4'6';'='E'ł'Ĺ'Ý'ď'((1(C([(m(…(—(6,;,L1R1¤1Ş1ô1ú1H2N2˘2¨233a5g5Ą5§5Ď6Ń67777>7´7ż7Ä8Ë8ň8ô8n9p9ő:ű:5;;;Ş?°?WBaB?CECkDuD.E4EÎFÔFII@KFKOOťTÁTLVRVŽZ”Z”\š\8`>`MbSb(e.efglgœlĄl¸l˝lÔlŮlđlől mm)m/mnn;n>ndngnnnśnšnßnâno o oo1o5o6o—I—O—X—\—e—s—|—…—’—¨—Ť—´—ť—Ó—Ú—Ţ—ç—í—ó—\š_š`šcšdšgšxš{š|ššëšńšňšřš†ŞŒŞúŞŤŹŹEŹKŹ}­€­ˆ­‹­ťŽžŽNŻQŻáŻäŻ§°˝°ű°ą/ł2łÂłĹłU´X´Ľ´¨´é´î´}ś€śˇˇŁˇŚˇóˇöˇ7¸<¸¨ťŤť;ź>źÎźŃź˝!˝b˝g˝1Ŕ4ŔÁ„ÁŃÂÔÂßĂâĂ#Ä(ÄzņĹîČúČ8ĚEĚŤÔ­ÔŻÔłÔ´ÔÁÔő× ŘŘ9Ü(GĂÎ 49› ĎÔIQjq{ƒ7@SZqw7>HP˜ŞŠ  ľ ž Ă Ę â ë đ ÷ 2 D  | ‡ ^pej‹’r{ą˛’šĺđkv…‰ýô×ő×ý×Ř Ř9Ü333333333333333333333333333333333˙˙ Susan Dichter \\SKIPPY\C\JULEK\UB\450\SQL2.doc Susan Dichter \\SKIPPY\C\JULEK\UB\450\SQL2.doc Susan Dichter \\SKIPPY\C\JULEK\UB\450\SQL2.doc Susan Dichter \\SKIPPY\C\JULEK\UB\450\SQL2.doc Susan Dichter \\SKIPPY\C\JULEK\UB\450\SQL2.doc Susan Dichter \\SKIPPY\C\JULEK\UB\450\SQL2.doc Susan Dichter-C:\WINDOWS\TEMP\AutoRecovery save of SQL2.asd Susan Dichter-C:\WINDOWS\TEMP\AutoRecovery save of SQL2.asd Susan Dichter-C:\WINDOWS\TEMP\AutoRecovery save of SQL2.asdjd C:\Julek\Bridgeport\450\SQL2.dociĆ>"Ԉ7˙˙˙˙˙˙˙˙N œ„p5˙ R4 ˆœÂ˙˙˙˙˙˙˙˙˙t&Eœ„p5˙FIœ„p5˙d+œ„p5˙ë-‘œ„p5˙Jiœ„p5˙+gCœ„p5˙Ľhsœ„p5˙h뜄p5˙k Şœ„p5˙ÚD@œ„p5˙Akfœ„p5˙•pÔœ„p5˙íR;ůž˙˙˙˙˙˙˙˙˙ÔM œ„p5˙<!œ„p5˙+ ˆ!œ„p5˙ő}d"œ„p5˙k’"ŽâÄ˙˙˙˙˙˙˙˙˙Á}­"œ„p5˙˜jb%œ„p5˙ˆeĐ%œ„p5˙“V1&œ„p5˙Ił&œ„p5˙ţÜ&œ„p5˙%P)œ„p5˙ăHş+œ„p5˙×tU,œ„p5˙2p•-œ„p5˙ÂGĄ-œ„p5˙Ă Ő-œ„p5˙Ü/0œ„p5˙˘jˆ1œ„p5˙á2œ„p5˙¤@Ů3œ„p5˙Ę4œ„p5˙ˇGŮ7œ„p5˙:`ç7œ„p5˙WY8œ„p5˙Ňa*8œ„p5˙çˇ8œ„p5˙,*Y:œ„p5˙c;œ„p5˙źó<œ„p5˙l÷<œ„p5˙{›Bœ„p5˙íMCœ„p5˙đ ŠFœ„p5˙bIœ„p5˙{°Jœ„p5˙J7'Lœ„p5˙ÉTJMœ„p5˙N'"Nœ„p5˙ƒKNNœ„p5˙@PNœ„p5˙Ú;€Nœ„p5˙˝?řNœ„p5˙ŮjÖPœ„p5˙qaŕPœ„p5˙0íQœ„p5˙‹7Tœ„p5˙mE7Vœ„p5˙ßhVœ„p5˙ CWœ„p5˙„KXœ„p5˙ŚčXœ„p5˙, \œ„p5˙ĆN]œ„p5˙\Î^œ„p5˙Ľ `œ„p5˙4[›`œ„p5˙ipPbœ„p5˙] ebœ„p5˙,cœ„p5˙¸;dœ„p5˙žH´fœ„p5˙ţ5gœ„p5˙ęhœ„p5˙Œíh¤70‹˙˙˙˙˙˙˙˙˙­5Hiœ„p5˙Üëiœ„p5˙ăW%jœ„p5˙z°lŢD` ˙˙˙˙˙˙˙˙˙~Umœ„p5˙é{ąmœ„p5˙Zúmœ„p5˙•&nœ„p5˙Úwďoœ„p5˙Y„pœ„p5˙Őtrœ„p5˙ŢN rœ„p5˙ńgsœ„p5˙:Qœtœ„p5˙uBšvœ„p5˙6đwœ„p5˙g2b{œ„p5˙•+•|œ„p5˙@}œ„p5˙őœ„p5˙Ů%܊„l˙˙˙˙˙˙˙˙˙ŘE4œ„p5˙M,˘œ„p5˙=2Úœ„p5˙„ŕ„˜ţĆŕ^„ŕ`„˜ţo( „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „@ „÷Ć@ ^„@ `„÷o( „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ„h„˜ţĆh^„h`„˜ţ5o( „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđî„„÷Ć^„`„÷o( „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ„ŕ„˜ţĆŕ^„ŕ`„˜ţo( „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ„4„Ě÷Ć4^„4`„Ě÷o(„@ „Ě÷Ć@ ^„@ `„Ě÷o(.„L„Ě÷ĆL^„L`„Ě÷o(..„X„Ě÷ĆX^„X`„Ě÷o(... „d„Ě÷Ćd^„d`„Ě÷o( .... „p„Ě÷Ćp^„p`„Ě÷o( ..... „|„Ě÷Ć|^„|`„Ě÷o( ...... „ˆ„Ě÷Ćˆ^„ˆ`„Ě÷o(....... „” „Ě÷Ć” ^„” `„Ě÷o(........ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ!„ „@üĆ ^„ `„@üo( „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđ „h„˜ţĆh^„h`„˜ţOJQJo(ˇđibI CWĽhsƒKNNĘ4Ü/0źó<“V1&ÔM Y„p•pÔ{›BŚčX6đwđ ŠFt&E„KXqaŕP=2Úő¸;dÚ;€NipPbÂGĄ-¤@Ů3Ji×tU,k ŞÜëi˝?řN­5HiWY8ÚD@ŐtrŒíh R4 ő}d"ŢN rţ5g\Î^:`ç7, \z°lăHş+:Qœté{ąmuBšvJ7'L,cŮjÖPßhVM,˘‹7T•+•|c;Akf•&n~Umë-‘@PNęhçˇ8%P)ˇGŮ7@}] ebăW%jžH´fN'"N+gCÁ}­"Ňa*8Ů%ÉTJMĆN]0íQ<!d+íMCg2b{mE7VĂ Ő-+ ˆ!N k’"Ć>l÷<,*Y:˜jb%Ił&ZúmńgsĽ `{°JţÜ&hëÚwďoá2ˆeĐ%4[›`íR;2p•-ŘE4˘jˆ1FI˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙i˙˙iő× Ř9Ü˙@€FF$%5F18Ü`@˙˙Unknown˙˙˙˙˙˙˙˙˙˙˙˙G‡z €˙Times New Roman5€Symbol3& ‡z €˙ArialSV  rTechnicalCourier New?5 ‡z €˙Courier New"qˆđĐhů3f„cŁ{R3fř“=˛[{!đĽŔ´´€0dŽÚ%2ƒđß˙˙CS 450 Susan Dichterjdţ˙ŕ…ŸňůOhŤ‘+'łŮ0p˜¨´ĚŘě ř  , 8 DPX`häCS 450S 4Susan Dichterousa Normal.dotejdm248Microsoft Word 9.0@2gL8@ŠÉŹkž@Žç˙Żež@ČÁÝ FĆ=˛ţ˙ŐÍ՜.“—+,ůŽ0ô hp€ˆ˜  ¨°¸ Ŕ ÓäLHCCCS{[ŽÚ  CS 450 Title  !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†‡ˆ‰Š‹ŒŽ‘’“”•–—˜™š›œžŸ Ą˘Ł¤ĽŚ§¨ŠŞŤŹ­ŽŻ°ą˛ł´ľśˇ¸šşťź˝žżŔÁÂĂÄĹĆÇČÉĘËĚÍÎĎĐŃŇÓÔŐÖ×ŘŮÚŰÜÝŢßŕáâăäĺćçčéţ˙˙˙ëěíîďđńňóôőö÷řůúűüýţ˙      !"#$%&'()*+,-./0123456789:;<=>?@ABCDEFGHIJKLMNOPQRSTUVWXYZ[\]^_`abcdefghijklmnopqrstuvwxyz{|}~€‚ƒ„…†ţ˙˙˙ˆ‰Š‹ŒŽţ˙˙˙‘’“”•–ţ˙˙˙ý˙˙˙ý˙˙˙ý˙˙˙ý˙˙˙œţ˙˙˙ţ˙˙˙ţ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙Root Entry˙˙˙˙˙˙˙˙ ŔFИŢň FĆž€1Table˙˙˙˙˙˙˙˙˙˙˙˙ęF9WordDocument˙˙˙˙˙˙˙˙ŞŇSummaryInformation(˙˙˙˙‡DocumentSummaryInformation8˙˙˙˙˙˙˙˙˙˙˙˙CompObj˙˙˙˙jObjectPool˙˙˙˙˙˙˙˙˙˙˙˙ИŢň FĆИŢň FĆ˙˙˙˙˙˙˙˙˙˙˙˙ţ˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙˙ţ˙ ˙˙˙˙ ŔFMicrosoft Word Document MSWordDocWord.Document.8ô9˛q