How to Change Case vs Decode in Oracle Performance
How to change case vs decode in Oracle performance? Performance change oracle decode vs case is simple and easy. DECODE was introduced in early Oracle release but CASE was introduced ...
Asiri Gunasena
Read More..
How To Use Rank Function in Oracle: 5 Real-World Examples
The rank function in Oracle is a useful tool that gives a rank on each row in the specific data group filtered according to specific criteria. Hope to explain the ...
Asiri Gunasena
Read More..
How To Create Oracle Domain Index: with 5 Solutions
What is domain index in Oracle? oracle domain index is a specialized type of index in Oracle that is used to retrieve text, spatial, or user-defined data speedily. this specialized ...
Asiri Gunasena
Read More..
Oracle Bitmap Index Unleashed: Optimization Made Easy
Oracle provides this nice data retrieving mechanism for low occurrence of DML operation tables. oracle bitmap index is proposed for low cardinality columns. Those kinds of columns in a query ...
Asiri Gunasena
Read More..
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 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..
