Inserted Data into a table is not showing up when selected in oracle

Question

I've inserted a row in a table in oracle using SQL Developer and committed too. But when selected the data it is not showing up. Did I go wrong somewhere ?

Below is the how I inserted and selected.

insert into table1 (seqn,pname,city,country,irank,icode,idate,imatch)
values('1234','ABCD','NY','USA','1','XYZ',sysdate,'9999');

The output I get is 1 rows inserted and then I commit;. Now when I do select the data, nothing is showing up.
select count(*) from table1; is fecthing me 0 rows.

Please help me out with where I am going wrong.

Note: All are of datatype varchar2() and the date is of DATE datatype. I've other columns in the table which can accept NULL data.

Answer 1

Take care to insert into the CORRECT SCHEME!!!

In my case I was inserting table in another scheme:

insert into table1 -- this inserts into some default scheme


insert into correct_scheme.table1 -- this inserts into the correct scheme