Oracle3A_Spool_Chen_Jason

Oracle3A_Spool_Chen_Jason - - script to create part of...

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

View Full Document Right Arrow Icon
-- script to create part of NORTHWOODS database structure SQL> -- BMIS441 SQL> --File name: 3Case1.sql SQL> --created 9/11/2008 Jason Chen, Row:1 SQL> SQL> @c:\oradata\chapter3A\emptyclearwater.sql S Table created. T Table created. T Table created. T Table created. T Table created. T SQL> @c:\oradata\chapter3A\emptynorthwoods.sql S Table dropped. T Table dropped. T Table dropped. T Table created. T Table created. T Table created. T Table created. T Table created. SQL> SQL> --- #1(a) SQL> --- inserting records into CUSTOMER SQL> INSERT INTO CUSTOMER VALUES 2 (1, 'Graham', 'Neal', 'R', to_date('12/10/1967', 'mm/dd/yyyy'), '9815 Circle Dr.', 'Tallahassee', 'FL', '32308', '9045551897', '904558599', 'grahamn', 'barbiecar'); ' 1 row created. 1 SQL>
Background image of page 1

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

View Full DocumentRight Arrow Icon
SQL> INSERT INTO CUSTOMER VALUES 2 (2, 'Sanchez', 'Myra', 'T', to_date('08/14/1958', 'mm/dd/yyyy'), '172 Alto Park', 'Seattle', 'WA','42180', '4185551791', '4185556643', 'sanchezmt', 'qwert5'); P 1 row created. 1 SQL> SQL> INSERT INTO CUSTOMER VALUES 2 (3, 'Smith', 'Lisa', 'M', to_date('04/12/1960', 'mm/dd/yyyy'), '850 East Main', 'Santa Ana', 'CA', '51875', '3075557841', '3075559852', 'smithlm', 'joshua5'); ' 1 row created. 1 SQL> SQL> INSERT INTO CUSTOMER VALUES 2 (4, 'Phelp', 'Paul', NULL, to_date('01/18/1981', 'mm/dd/yyyy'), '994 Kirkman Rd.', 'Northpoint', 'NY', '11795', '4825554788', '4825558219', 'phelpp', 'hold98er'); ' 1 row created. 1 SQL> SQL> INSERT INTO CUSTOMER VALUES 2 (5, 'Lewis', 'Sheila', 'A', to_date('08/30/1978', 'mm/dd/yyyy'), '195 College Blvd.', 'Newton', 'GA', '37812', '3525554972', '3525551811', 'lewissa', '125pass'); B 1 row created. 1 SQL> SQL> INSERT INTO CUSTOMER VALUES 2 (6, 'James', 'Thomas', 'E', to_date('06/01/1973', 'mm/dd/yyyy'), '348 Rice Lane', 'Radcliff', 'WY', '87195', '7615553485', '7615553319', 'jamest', 'nok$tell'); ' 1 row created. 1 SQL> SQL> SQL> --- #1(b) SQL> DROP SEQUENCE orders_id_seq; S Sequence dropped. S SQL> CREATE SEQUENCE orders_id_seq START WITH 1;
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 / 6

Oracle3A_Spool_Chen_Jason - - script to create part of...

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