[ [Venom] @ 10.02.2009. 01:37 ] @
Pozdrav, 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, ); |