not properly quoted string terminated_ORA-01756: quoted string not properly terminated — oracle-tech...

ERROR MASSAGE KEEPS POPPING UP BUT I CANT SEEM TO BE ABLE TO DEBUG THIS ONE PLS HELP

SQL> INSERT INTO COPY VALUES(12345,987654322,'Y','FAIRLY USED','1 WEEKS','ON SHELF',to_date('26/1

4/2006,'dd/mm/yyyy',)'20.00');

ERROR:

ORA-01756: quoted string not properly terminated

INSERT INTO COPY VALUES(12345,987654322,'Y','FAIRLY USED','1 WEEKS','ON SHELF',to_date('26/14/2006,'dd/mm/yyyy',)'20.00');

CREATE TABLE BookTitle(

itemRef VARCHAR2(10) CONSTRAINT itemRef NOT NULL,

ISBN VARCHAR2(13) CONSTRAINT ISBN NOT NULL,

title VARCHAR2(30) CONSTRAINT title NOT NULL,

author VARCHAR2(30) CONSTRAINT author NOT NULL,

edition VARCHAR2(4),

publisher VARCHAR2(20),

year NUMBER(4),

location VARCHAR2(4),

city VARCHAR2(20),

postcode VARCHAR2(8),

CONSTRAINT BookTitle_PK PRIMARY KEY(itemRef)

);

-- Creation of Copy table

CREATE TABLE Copy(

copyNo NUMBER(10) CONSTRAINT copyNo NOT NULL,

itemRef VARCHAR2(10) CONSTRAINT itRef NOT NULL,

referenceOnly VARCHAR2(1),

condition VARCHAR2(50),

loanType VARCHAR2(20) CONSTRAINT loanType

CHECK(loanType IN('1 WEEK','2 WEEK','1 MONTH')),

status VARCHAR2(20) CONSTRAINT status

CHECK(status IN('ON SHELF','ON LOAN','AT COUNTER',

'ON ORDER','LOST')),

dateAcquired DATE CONSTRAINT dateAc NOT NULL,

purchasePrice NUMBER(6,2),

CONSTRAINT Copy_Pk PRIMARY KEY (copyNo),

CONSTRAINT Copy_BookTitle_FK FOREIGN KEY (itemRef) REFERENCES BookTitle (itemRef)

);

0