Skip to content
Advertisement

What is the correct way of inserting values in to tables and link tables in oracle?

I am currently trying to build a database but have become stuck after creating the tables. I have tried inserting values into a table but it gives me the following error:

Error starting at line : 73 in command –

Error at Command Line : 73 Column : 66 Error report – SQL Error: ORA-00984: column not allowed here 00984. 00000 – “column not allowed here” *Cause:
*Action:

I am really struggling to find what is wrong with this but i am new to oracle so am not sure, any help would be greatly appreciated.

My code can be seen below:

Advertisement

Answer

for string value use single quote otherwise that value is as column name

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement