Pseudocolumn

How to Resolve ORA-08002: sequence CURRVAL is not yet defined in this session

by Ed Chen
June 8, 2020December 10, 2022

ORA-08002 ORA-08002 means that you don't have any sequence value cached in your session, so you can't check the current value (CURRVAL) of the sequence… Read More »

ORA-00904 Invalid Identifier - Oracle Database Object Name Recognition Examples

How to Resolve ORA-00904 Invalid Identifier

by Ed Chen
March 12, 2019April 20, 2023
4 Comments

ORA-00904 ORA-00904 means that you used an invalid identifier to be a column name, which is most likely unmatched in name or incorrect syntax. Since… Read More »

Oracle Limit Rows Returned

by Ed Chen
August 24, 2018December 10, 2022

Oracle Limit Query Returned In MySQL, we use SQL LIMIT clause to limit number of rows returned in SELECT SQL statements. But in Oracle, we… Read More »

JavaScript is not enabled. Please enable it and reload the page.