the tables i have created in sqlplus not appearing in Navicat lite

Question

Guys I am using oracle 11g and I am pretty new with it.

the problem is when I try to create a table and insert a value in sqlplus terminal, it is not showing in the Navicat lite(Graphical representation software).

Here, let me make this more clear by showing you the pictures.

here are the rows that are getting printed on SQLPlus terminal

But take a look at the rows in the Navicat

Here the table name is TIME.

Can anyone explain to me what is the problem?

Answer 1

Looks like you didn't

commit;

in SQL*Plus after inserting rows. Unless you do that, those values are visible only to you, but not other sessions (which is what Navicat sees). So - commit.

---

As of letter case and double quotes:

This is how you should be doing it - don't use double quotes, reference tables any way you want:

SQL> create table test (id number);

Table created.

SQL> insert into test (id) values (1);

1 row created.

SQL> select * from test;

        ID
----------
         1

SQL> select * from TEST;

        ID
----------
         1

SQL> select * from tEsT;

        ID
----------
         1

SQL> drop table test;

Table dropped.

If you use double quotes, you have to reference the table exactly the same way as you created it:

SQL> create table "test" (id number);

Table created.

SQL> insert into test (id) values (1);
insert into test (id) values (1)
            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> insert into TEST (id) values (1);
insert into TEST (id) values (1)
            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> insert into "TEST" (id) values (1);
insert into "TEST" (id) values (1)
            *
ERROR at line 1:
ORA-00942: table or view does not exist


SQL> insert into "test" (id) values (1);

1 row created.

SQL>