I have tried updating the following query but it keeps givin

I have tried updating the following query but it keeps giving me this error \" Quoted String not Properly TErminated\'. Below is the query.

UPDATE Erik_Morataya SET Lastname varchar2=\'Schmidt\', Firstsname=\'Alfred\',Gender=\'M,DOB=\'12/12/1995\';

Below is the table that I created

create Table Erik(p_id number primary key);

Create table

Erik_Morataya

(

Id_number NOT NULL. Unique,

Lastname varchar2(20) NOT NULL,

Firstsname varchar2(20),

Gender char(10),

DOB date,

PRIMARY KEY(Id),

Foreign Key (Id) REFERENCES Erik(P_Id)

Check (Id>0)

);

Solution

Answer :-

UPDATE Erik_Morataya SET Lastname=\'Schmidt\' , Firstsname=\'Alfred\',Gender=\'M\',DOB=\'12/12/1995\';

Explanation :

Update keyword will update all keywords data to the table and also a seperate record in the table by where keyword.