Oracle3C_Spool_Chen_Jason_OUTPUTS

Oracle3C_Spool_Chen_Jason_OUTPUTS - SQL>...

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

View Full Document Right Arrow Icon

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

View Full DocumentRight Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: SQL> SQL> -- script to create part of NORTHWOODS database structure SQL> -- BMIS441 SQL> --File name: Ch3CCase.sql SQL> --created 9/11/2006 Jason Chen, Row:1 SQL> SQL> SET linesize 100 SQL> set pagesize 25 SQL> column c_first format A9 SQL> column c_last format A10 SQL> SQL> --************************************************ 1 SQL> SQL> ---#1 S O_ID ITEM_DESC ---------- ------------------------------ 1 3-Season Tent 1 Women's Fleece Pullover SQL> SQL> SQL> --************************************************ 2 SQL> SQL> ---#2 S C_FIRST C_LAST Order Total --------- ---------- ----------- Neal Graham $379.89 SQL> SQL> ---#3 SQL> PROMPT no rows returned because nobody ordered this item no rows returned because nobody ordered this item SQL> SQL> SELECT c_first, c_last, ol_quantity 2 FROM item 3 NATURAL JOIN inventory 4 NATURAL JOIN order_line 5 NATURAL JOIN orders 6 NATURAL JOIN customer 7 WHERE item_desc = 'Boy''s Surf Shorts'; no rows selected n SQL> SQL> --************************************************ 4 SQL> SQL> ---#4 S SHIP_ID ITEM_DESC ---------- ------------------------------...
View Full Document

Page1 / 3

Oracle3C_Spool_Chen_Jason_OUTPUTS - SQL>...

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

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