Oracle11g error: table or view does not exist when using INSERT INTO

Question

After creating a table I would like to insert data but I've encountered an error.

Creating the table:

CREATE TABLE "Buildings"(
  "idBuilding" Integer NOT NULL,
  "buildingName" Varchar2(30 ) NOT NULL,
  "city" Varchar2(30 ) NOT NULL,
  "street" Varchar2(30 ) NOT NULL,
)

and then

INSERT INTO Buildings VALUES(1, 'Empire State', 'New York', 'West');

and the error is

SQL Error: 00942. 00000 -  "table or view does not exist"

I know that there are a lot of similar questions here but I couldn't find any solution. I've tried using GRANT and it didn't help. I'm using Oracle SQL Developer.

You're creating a table named "Building", but inserting into a table named "Banki"? — Waterstraal
– Waterstraal, Commented Apr 30, 2017 at 19:51

Erich Kitzmueller · Accepted Answer · 2017-04-30 22:18:38Z

1

Since you created the table with quotes and some lowercase letter, you have to use quotes in your insert statement as well. "Buildings" instead of Buildungs.

Identifiers are case sensitive in Oracle, but identifiers without quotes are automatically turned to uppercase. Therefore, "ABC"=ABC=Abc=abc

edited Apr 30, 2017 at 22:18

answered Apr 30, 2017 at 20:26

Erich Kitzmueller

37.1k5 gold badges85 silver badges104 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

adek111 · Accepted Answer · 2017-04-30 20:29:03Z

1

It's a bug in Oracle that adding values' of names with " symbol at the start and at the end of an object's name doesn't show its' symbol in database but it's still somehow saved in database.

Try:

INSERT INTO "Buildings" VALUES(1, 'Empire State', 'New York', 'West');

answered Apr 30, 2017 at 20:29

adek111

1,5072 gold badges19 silver badges39 bronze badges

1 Comment

Erich Kitzmueller Over a year ago

Not a bug.without quotes, names are turned to uppercase.

Community · Accepted Answer · 2017-05-23 12:10:35Z

0

Well per your latest edit, check and make sure that you have selected the correct database under which you have created the table named Buildings.

See this post How to Query Database Name in Oracle SQL Developer?

edited May 23, 2017 at 12:10

CommunityBot

11 silver badge

answered Apr 30, 2017 at 19:51

Rahul

78.1k14 gold badges80 silver badges132 bronze badges

3 Comments

mikro098 Over a year ago

My bad, I've pasted the wrong command and made a typo. Table name is "Buildings" and I'm trying to insert into Buildings. I've edited my post.

mikro098 Over a year ago

how to do it? I'm quite new when it comes to DB. I'm inside my .sql file and when I click on the left on Tables I can see all of my created tables.

Rahul Over a year ago

@codddeer123, see edit again and search in SO or Google

Collectives™ on Stack Overflow

Oracle11g error: table or view does not exist when using INSERT INTO

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

1 Comment

3 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related