CODEWITHSUNDEEP
sqloracle-databaseoracle11g
user2808264
user2808264

Reputation: 569

INSERT values query throws error

I'm using Oracle 11g and I get the following error when i enter the following query

INSERT INTO Customer(Customer_id, First_Name, Last_Name, DOB, Gender, PAN_No) 
VALUES(301, ‘Robert’, ‘William’, 1986-10-05, ‘M’,’PQ56794’);

ERROR:

ORA-01756: quoted string not properly terminated

Upvotes: 0

Views: 52

Answers (1)

ak0053792
ak0053792

Reputation: 563

Problem is 

’PQ56794’

Try the below if it works:

INSERT INTO Customer(Customer_id, First_Name, Last_Name, DOB, Gender, PAN_N0) 
VALUES(301, 'Robert', 'William', to_date('19861005','YYYYMMDD'), 'M','PQ56794');

Tip : Always copy from Notepad to avoid problems related to quote.

Upvotes: 2

Related Questions