How to Use SQL ISOPEN and What is %ISOPEN?
In Oracle SQL ISOPEN attribute checks whether currently a cursor is open or not. cursor_name% %ISOPEN returns TRUE if its cursor is open. As you know Cursors are used to ...
Asiri Gunasena
Read More..
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..
Index Unusable Oracle | How to Find and Fix it
Oracle databases can have invalid indexes that are not usable. Such index unusable oracle state is UNUSABLE. Oracle DBA_INDEXES view returns all the indexes that are available in the database. ...
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..
