oracle database

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

July 27, 2023

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

July 15, 2023

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

June 28, 2023

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

June 10, 2023

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

May 12, 2023

EXISTS Vs IN | How To Change Performance In Subqueries

Performance improvement is not a stick into theory. It’s the same with EXISTS vs IN keywords. It’s practical. In certain cases, EXISTS does well for subqueries rather than IN. In ...

Asiri Gunasena

March 1, 2023

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

July 27, 2023

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

July 15, 2023

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

June 28, 2023

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

June 10, 2023

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

May 12, 2023

Performance improvement is not a stick into theory. It’s the same with EXISTS vs IN keywords. It’s practical. In certain cases, EXISTS does well for subqueries rather than IN. In ...

Asiri Gunasena

March 1, 2023

Services

Resources

Contact