SQL Language (MOSC)

MOSC Banner

Inserting a value of ROWNUM to a column of a database table causes issue in Oracle 11g

edited Jan 30, 2013 11:29PM in SQL Language (MOSC) 3 commentsAnswered
Hi All,

I have a insert command as below which is running fine in Oracle 9i, but in oracle 11g it is throwing an error like "Specified pseudocolumn or operator not allowed here". please help me in idetifying substitute for ROWNUM in oracle 11g.

INSERT into EMP

                       (empid

                         ,salary

                      )

Values        (102

                    ,ROWNUM

                    );

The above statement is working fine in oracle 9i, but not oracle 11g. (Error message: Specified pseudocolumn or operator not allowed here)

Thanks

Siva

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center