How to Oracle SQL Developer Export to Excel in 3 steps
Oracle SQL developer is a great tool for doing various tasks in the Oracle database. This powerful tool allows you to do hundreds of tasks including exporting query results to ...
Asiri Gunasena
Read More..
Now Oracle can we Delete Temp Tablespace
Oracle can we delete temp tablespace? Yes, it is. Deleting a temporary tablespace in Oracle is a significant database operation that requires extra caring and understanding of its consequences. This ...
Asiri Gunasena
Read More..
How to Add raise_application_error in Oracle
Exception handling is most important in any programming and the same rule applies with Oracle. When a user need to raise a user-defined error from the application raise_application_error allows you ...
Asiri Gunasena
Read More..
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..
4 Pillars Of OOP With Real World New Examples
Before moving on to the 4 Pillars of OOP I would like to add a small recap on what is Object-Oriented Programming (OOP). OOP is one of the famous techniques ...
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..
