I have tried updating the following query but it keeps giving me this error \" Q

ID: 3931879 • Letter: I

Question

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)

);

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.