This preview has intentionally blurred sections. Sign up to view the full version.View Full 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.
- Spring '10