ORA-01747: invalid user.table.column

1
votes
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"

2
sqloracle
[Section] is an invalid identifier. You can't use [ or ] in an identifier in SQL. See the chapter "Basic Elements of Oracle SQL" in the manual: docs.oracle.com/database/121/SQLRF/… - a_horse_with_no_name

2 Answers

0
votes

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

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

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.