MY SQL Syntax ili Koji error?Evo jedan jako jednostavan SQL kod...
A evo i errora koji me zbunjuje:
SQL*Plus: Release 10.2.0.1.0 - Production on Tue Feb 10 01:25:54 2009
SQL>
SQL> start test.sql
Table dropped.
Table created.
Table dropped.
Table created.
Drop Table RADNIK cascade constraints
*
ERROR at line 1:
ORA-00942: table or view does not exist
)
*
ERROR at line 16:
ORA-00904: : invalid identifier
SQL>
A evo i datog koda....
Code:
DROP TABLE EMS cascade constraints;
CREATE TABLE EMS (
EMPNO NUMBER(4) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4) CONSTRAINT EMS_SELF_KEY REFERENCES EMS (EMPNO),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) NOT NULL,
CONSTRAINT EMS_FOREIGN_KEY FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
CONSTRAINT EMS_PRIMARY_KEY PRIMARY KEY (EMPNO));
DROP TABLE EMP cascade constraints;
CREATE TABLE EMP (
EMPNO number(4) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4) CONSTRAINT EMP_SELF_KEY REFERENCES EMP (EMPNO),
HIREDATE date,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) NOT NULL,
CONSTRAINT EMP_FOREIGN_KEY FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
CONSTRAINT EMP_PRIMARY_KEY PRIMARY KEY (EMPNO));
Drop Table RADNIK cascade constraints;
CREATE TABLE RADNIK (
employeecode varchar2(6),
title varchar2(6),
surname varchar2(15),
forename1 varchar2(12),
forename2 varchar2(12),
forename3 varchar2(12),
address1 varchar2(30),
address2 varchar2(30),
address3 varchar2(20),
postcode varchar2(7),
gender varchar2(1),
DOB date,
currentjob varchar2(15),
dateleft date,
);
DROP TABLE EMS cascade constraints;
CREATE TABLE EMS (
EMPNO NUMBER(4) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4) CONSTRAINT EMS_SELF_KEY REFERENCES EMS (EMPNO),
HIREDATE DATE,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) NOT NULL,
CONSTRAINT EMS_FOREIGN_KEY FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
CONSTRAINT EMS_PRIMARY_KEY PRIMARY KEY (EMPNO));
DROP TABLE EMP cascade constraints;
CREATE TABLE EMP (
EMPNO number(4) NOT NULL,
ENAME VARCHAR2(10),
JOB VARCHAR2(9),
MGR NUMBER(4) CONSTRAINT EMP_SELF_KEY REFERENCES EMP (EMPNO),
HIREDATE date,
SAL NUMBER(7,2),
COMM NUMBER(7,2),
DEPTNO NUMBER(2) NOT NULL,
CONSTRAINT EMP_FOREIGN_KEY FOREIGN KEY (DEPTNO) REFERENCES DEPT (DEPTNO),
CONSTRAINT EMP_PRIMARY_KEY PRIMARY KEY (EMPNO));
Drop Table RADNIK cascade constraints;
CREATE TABLE RADNIK (
employeecode varchar2(6),
title varchar2(6),
surname varchar2(15),
forename1 varchar2(12),
forename2 varchar2(12),
forename3 varchar2(12),
address1 varchar2(30),
address2 varchar2(30),
address3 varchar2(20),
postcode varchar2(7),
gender varchar2(1),
DOB date,
currentjob varchar2(15),
dateleft date,
);
-
