Oracle3C_Spool_Chen_Jason_OUTPUTS

Oracle3C_Spool_Chen_Jason_OUTPUTS - SQL> SQL> SQL>...

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

View Full Document Right Arrow Icon
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> SQL> --************************************************ 1 SQL> SQL> ---#1(A) S O_ID ITEM_DESC ---------- ------------------------------ 1 3-Season Tent 1 Women's Fleece Pullover SQL> SQL> ---#1(B) S O_ID ITEM_DESC ---------- ------------------------------ 1 3-Season Tent 1 Women's Fleece Pullover SQL> SQL> --************************************************ 2 SQL> SQL> ---#2 (A) S C_FIRST C_LAST Order Total ------------------------------ ------------------------------ ----------- Neal Graham 379.89 SQL> SQL> ---#2(B) NO SQL> * ERROR at line 3: ORA-00918: column ambiguously defined O SQL> SQL> --************************************************ 3 SQL> SQL> ---#3 SQL> PROMPT no rows returned because nobody ordered this item
Background image of page 1

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

View Full DocumentRight Arrow Icon
no rows returned because nobody ordered this item SQL> S no rows selected
Background image of page 2
Image of page 3
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 03/26/2010 for the course ITS 26 taught by Professor Jack during the Spring '10 term at Staten Island.

Page1 / 4

Oracle3C_Spool_Chen_Jason_OUTPUTS - SQL> SQL> SQL>...

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