Oracl#3B_Spool_Chen_Jason (OUTPUTS ONLY)

Oracl#3B_Spool_Chen_Jason (OUTPUTS ONLY) - Sheila A 195...

Info iconThis preview shows pages 1–3. Sign up to view the full content.

View Full Document Right Arrow Icon
SQL> SQL> -- script to create part of NORTHWOODS database structure SQL> -- BMIS441 SQL> --File name: Ch3BCase.sql SQL> --created 9/11/2006 Jason Chen, Row:1 SQL> SQL> SET linesize 100 SQL> set pagesize 25 SQL> SQL> SQL> --#2 SQL> S ID Last Nam First Na MI Address City St Zip Birthdate ---- -------- -------- -- ------------------ ------------ -- ----- ---------- 5 Lewis Sheila A 195 College Blvd. Newton GA 37812 30-AUG-78 6 James Thomas E 348 Rice Lane Radcliff WY 87195 01-JUN-73 SQL> SQL> --#4 S COUNT(*) ---------- 4 SQL> SQL> --#6 S COUNT(*) ---------- 2 SQL> SQL> --#8 S ID Last Nam First Na MI Address City St Zip Day Phone ---- -------- -------- -- ------------------ ------------ -- ----- ---------- 1 Graham Neal R 9815 Circle Dr. Tallahassee FL 32308 9045551897 5 Lewis
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Background image of page 2
Background image of page 3
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: Sheila A 195 College Blvd. Newton GA 37812 3525554972 SQL> SQL> --#10 S SHIP_ID SHIP_DATE ---------- --------- 3 25-JUN-06 4 25-JUN-06 5 15-AUG-06 SQL> SQL> --#12 S COUNT(DISTINCTCOLOR) -------------------- 2 SQL> SQL> --#14 S C_FIRST C_LAST AGE------------------------------ ------------------------------ ----------Neal Graham 38 Myra Sanchez 48 Lisa Smith 46 Paul Phelp 25 Sheila Lewis 28 Thomas James 33 T SQL> SQL> --#16 S OS_ID COUNT(*) ---------- ---------- 2 2 3 2 6 2 SQL> SQL> --#18 S ITEM_ID COUNT(DISTINCTCOLOR) ---------- -------------------- 1 1 2 2 3 2 4 2 5 2 6 1 7 1 7 rows selected. 7 SQL> SQL> --#20 S ITEM_ID TO_CHAR( ---------- -------- 1 $199.95 1 $209.95 2 $259.99 3 $29.95 4 $59.95 5 $15.99 6 $15.95 7 $19.99 8 rows selected. 8 SQL>...
View Full Document

Page1 / 3

Oracl#3B_Spool_Chen_Jason (OUTPUTS ONLY) - Sheila A 195...

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online