Monthly Archives: January 2015

Sequence insight

ORA-02287 Sequence fit into many business requirement where we need to implement incremental logic for a integer column value. Using two pseudo columns, we increment and fetches sequence values. NEXTVAL – Increment sequence value CURRVAL – Reuse current incremented value … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , | Leave a comment

Playing with ORDER BY clause in oracle.

Most of us must be aware of “ORDER BY” clause and its importance to present data in a specific order (Ascending or Descending). Order by clause is an optional Component of SELECT Query. Oracle Say “Use the ORDER BY clause … Continue reading

Rate this:

Posted in Oracle Internal | Tagged , , , , , , , | 1 Comment