I tried deleting a row which confirmed it but after initatin

I tried deleting a row which confirmed it but after initating SELECT * FROM ERIK_MORATAYA; it says that no row was selected. My table is the following

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)

);

The row that I deleted was this DELETE FROM Erik_MORATAYA where ID=1;

Solution

Answer :-

1) First insert data in database ,

2) Then execute the query

SELECT * FROM ERIK_MORATAYA ;

2) After we can delete

DELETE FROM Erik_MORATAYA where ID=1;