Oracle3B_Spool_Chen_Jason

Oracle3B_Spool_Chen_Jason - SQL> SQL> script to create...

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: 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> SQL> COLUMN c_id HEADING 'ID' FORMAT 999 SQL> COLUMN c_last HEADING 'Last Name' FORMAT A8 SQL> COLUMN c_first HEADING 'First Name' FORMAT A8 SQL> COLUMN c_mi HEADING 'MI' FORMAT A2 SQL> COLUMN c_dob HEADING 'Birthdate' FORMAT A10 SQL> COLUMN c_address HEADING 'Address' FORMAT A18 WRAP SQL> COLUMN c_city HEADING 'City' FORMAT A12 SQL> COLUMN c_state HEADING 'St' SQL> COLUMN c_zip HEADING 'Zip' FORMAT A5 SQL> COLUMN c_dphone HEADING 'Day Phone' FORMAT A10 SQL> COLUMN c_ephone HEADING 'Eve. Phone' FORMAT A10 SQL> COLUMN c_userid HEADING 'User id' FORMAT A10 SQL> COLUMN c_password HEADING 'Password' FORMAT A10 SQL> SQL> SELECT c_id,c_last, c_first, c_mi, c_address, c_city, c_state, c_zip, c_dob 2 FROM customer WHERE c_dob LIKE '%7_'; ID Last Nam First Na MI Address...
View Full 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

Oracle3B_Spool_Chen_Jason - SQL> SQL> script to create...

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