Inserting a value of ROWNUM to a column of a database table causes issue in Oracle 11g
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