Re: How to insert values?

From: Me <me_at_privacy.net>
Date: Mon, 19 May 2003 22:28:55 +0530
Message-ID: <b83icv8pbqjuge5pmdi8m82r87fmnkgfeo@4ax.com>

On Mon, 19 May 2003 12:46:08 +0000, andrewst wrote: :<snip>

SQL*Plus: Release 8.1.5.0.0 - Production on Mon May 19 22:11:08 2003

Connected to:
Oracle8i Personal Edition Release 8.1.5.0.0 - Production With the Java option
PL/SQL Release 8.1.5.0.0 - Production

SQL> @C:\WINDOWS\DESKTOP\TEMP.SQL
Input truncated to 1 characters
CREATE SCHEMA AUTHORIZATION myschema
*
ERROR at line 1:
ORA-02421: missing or invalid schema authorization identifier

Contents of temp.sql
CREATE SCHEMA AUTHORIZATION myschema
CREATE TABLE EMPLOYEE
(

FNAME VARCHAR(15) NOT NULL,
MINIT CHAR,
LNAME VARCHAR(15) NOT NULL,
SSN CHAR(9) NOT NULL,
BDATE DATE,
ADDRESS VARCHAR(30),
SEX CHAR,
SALARY DECIMAL(10,2),

SUPERSSN CHAR(9),
DNO INT NOT NULL,
PRIMARY KEY(SSN),

FOREIGN KEY(SUPERSSN) REFERENCES EMPLOYEE(SSN), FOREIGN KEY(DNO) REFERENCES DEPARTMENT(DNUMBER) DEFERRABLE INITIALLY DEFERRED
)
CREATE TABLE DEPARTMENT
(

DNAME VARCHAR(15) NOT NULL,
DNUMBER INT NOT NULL,
MGRSSN CHAR(9) NOT NULL,
MGRSTARTDATE DATE,
PRIMARY KEY(DNUMBER),
UNIQUE(DNAME),
FOREIGN KEY(MGRSSN) REFERENCES EMPLOYEE(SSN))

I hope I have not reported something very stupid here, but it is my first time.

Just give your opinion:
Why do you think the author chose such a complicated example? 8-(

Thanks a lot.

-- 
That could not have been my last post!

Received on Mon May 19 2003 - 11:58:55 CDT