Intellipaat Back

Explore Courses Blog Tutorials Interview Questions
0 votes
2 views
in SQL by (6.1k points)

I have the below simple Oracle INSERT.

INSERT INTO MY.LOGFILE
(id,severity,category,logdate,appendername,message,extrainfo)
VALUES
(
"dee205e29ec34",
"FATAL",
"facade.uploader.model",
"2013-06-11 17:16:31",
"LOGDB",
NULL,
NULL
)

But I am getting this error: 

[Err] ORA-00984: column not allowed here

Can anyone help me with this?

1 Answer

0 votes
by (12.7k points)

You need to replace the double quotes with the single ones:

INSERT
INTO    MY.LOGFILE
        (id,severity,category,logdate,appendername,message,extrainfo)
VALUES  (
       'dee205e29ec34',
       'FATAL',
       'facade.uploader.model',
       '2013-06-11 17:16:31',
       'LOGDB',
       NULL,
       NULL
       )

In SQL, the double quotes are used to mark identifiers, not string constants.

Willing to Learn SQL? Sign up for the SQL Certification course by Intellipaat now.

31k questions

32.8k answers

501 comments

693 users

Browse Categories

...