How to use MOD Oracle SQL Function: 99.9%9
This is related to MOD Oracle SQL function. I hope to write about the simple example of mod in Oracle SQL and the invalid use of mod in Oracle plsql ...
Asiri Gunasena
Read More..
How to Oracle SQL Compare Dates (6 Ways)
Oracle SQL comparing dates is not complicated but you have to follow the correct syntax and match targeting columns. Otherwise, need to convert column types into the same matching data ...
Asiri Gunasena
Read More..
How to use SQL ROWCOUNT in Oracle.
SQL%ROWCOUNT is an attribute of SQL which is returns an INTEGER value for the implicit cursor in PLSQL. In this article, I’m aiming to explain how to use SQL ROWCOUNT ...
Asiri Gunasena
Read More..
How to Solve Oracle expdp ora-01555 snapshot too old
Once you export expdb job to backup the database table this error ORA-01555: snapshot too old: rollback segment number 12 with name might raise. Why is this error raised? One ...
Asiri Gunasena
Read More..
Poor SQL Index Usage including Good Examples
When making performance improvements in your database SQL Index Usage is one of the most valuable and essential features. SQL Indexes are used to retrieve data from databases by reducing ...
Asiri Gunasena
Read More..
