CODEWITHSUNDEEP
sqloracle-database
Shoaib Sayyad
Shoaib Sayyad

Reputation: 131

ORA-01747: invalid user.table.column

create table class_1(column1,column2)

while inserting values

INSERT INTO class_1 (column1, column2, [Section]) 
VALUES(1, 'First')

Erorr: SQL Error: ORA-01747: invalid user.table.column, table.column, or column specification
01747. 00000 - "invalid user.table.column, table.column, or column specification"

Upvotes: 0

Views: 10372

Answers (2)

Sathiya_ethiraj
Sathiya_ethiraj

Reputation: 51

Error:

SQL Error: ORA-01747: invalid user.table.column, table.column, or column specification

Description of error: The table is created with only 2 columns. However, while inserting, [Section] is considered as a new column. Due to this, column class_1.[Section] is not available is thrown as ORA-01747 error.

Upvotes: 0

Sawalhah
Sawalhah

Reputation: 156

the table name is different in insert statement from class1 to class_1

INSERT INTO class1 (column1, column2, [Section]) 
VALUES(1, 'First', 'A')

Upvotes: 0

Related Questions