CODEWITHSUNDEEP
oracle-database
bernie2436
bernie2436

Reputation: 23901

I am able to create a table in oracle -- but not use desc or insert

I am brand new to Oracle 11g. I login to SQL plus and create a table like this.

SQL> create table "Skills" ("SkillID" Number(20), "Level" Number(20), "Area" Varchar2(20));

Table created.

But then I try to insert into or describe the table and it does not work.

SQL> desc skills;
ERROR:
ORA-04043: object skills does not exist

It does not appear to be a simple issue of case-sensitivity:

SQL> desc Skills;
ERROR:
ORA-04043: object Skills does not exist

I don't understand why I am seemingly able to create the table but then unable to call up its structure or add in data. What's going on? It is not a permissions issue because I am able to insert into other tables I have created on the account.

Upvotes: 0

Views: 839

Answers (1)

Scott S
Scott S

Reputation: 2746

You're creating the table as "Skills", instead of "skills". By using the quotes, you specify that the table name should be case sensitive. Try desc "Skills" and see if that works better for you.

Upvotes: 3

Related Questions