How To Use Oracle SQL NOTFOUND (6 Example %NOTFOUND)
Oracle PL/SQL cursors are used to fetch records from a table. Oracle SQL NOTFOUND is used to check whether has any row been fetched. Cursors are the most commonly used ...
Asiri Gunasena
Read More..
How to use Oracle ROUND Function | Round(Number/Date)
In Oracle, the Oracle Round function is used to round a numeric value to a specific number of the nearest integer or the nearest decimal value. I have listed 10 ...
Asiri Gunasena
Read More..
How to find Oracle SQL First Day of Month
To retrieve the Oracle SQL first day of Month, you can use the TRUNC function. There are specific parameters to set on TRUNCT to retrieve it. I would like to ...
Asiri Gunasena
Read More..
Ora-28001 the Password has Expired. How to Fix? 5 Solutions
If you are an Oracle database user you may face ora-28001 the password has expired problem. This means your password has expired already. So, you must fix this issue to ...
Asiri Gunasena
Read More..
Query to check the Table Size in Oracle | 5 Simple Queries
Oracle table size does not fix it constantly changes with DML operation. There is not only one query to check the table size in Oracle. Some factors change the actual ...
Asiri Gunasena
Read More..
SQL Query to Check Password Expiry Date in Oracle | How to Turn Off?
Database user password expiry date is important to access the database and there is an SQL query to check password expiry date in Oracle. Here I would add some frequent ...
Asiri Gunasena
Read More..
How to Check Database Name in Oracle | 6 Tips
If you want to check database name in Oracle that you connected there are several ways to get it. I added 6 different methods to check it. Sometimes if you ...
Asiri Gunasena
Read More..
Oracle Long Running Queries | Health Check Now
Oracle databases have great ways of taking Oracle long running queries. I hope to add some examples of queries below. I would like to use some Oracle views for performance ...
Asiri Gunasena
Read More..
