How to Get Number of Days In a Year ?

If you cannot calculate how many days in a year, here is an easy example for you. Write down the bellow code directly in sql*plus or SQL Developer or any others tools and get the result. :)

SELECT ADD_MONTHS(TRUNC(SYSDATE,'RRRR'),12)-TRUNC(SYSDATE,'RRRR')
FROM DUAL;

Hope it helps...

If any query, just leave your comments...

Oracle Forms Designer has stopped working/ How to apply Patchset 7047034 ?

As salamualikum Readers,

When you install Oracle Developer Suite 10g Release 2 on windows 7 and try to open any form within the builder, you may face the following issues..

Oracle Forms Designer Has stopped Working

Windows can check online for a solution to the problem.

---> Check online for a solution and close the program
----> close the program

What is the solution ?

There is two solution for this issue.

Solution # 1

1. Open form builder.
2.  Make connection with database.
3.  Now open the form.

If solution # 1 doesn't work in your case then your need metalink (support.oracle.com) access which required valid support account.

 Solution #2

1. Download Patchset no. 7047034
2. Extract in root drive like C:\ 7047034
3. open command prompt with admin previlage (@ write cmd)
4. set oracle_home like (C:\Users\Administrator>set oracle_home=C:\DevSuiteHome_1)
5. set PATH=%ORACLE_HOME%\OPatch;%PATH% like (C:\Users\Administrator>set PATH=%ORACLE_HOME%\OPatch;%PATH%)
6. go to patchset folder like (C:\Users\Administrator>cd c:\7047034)
7. write opatch apply like (c:\7047034>opatch apply)

8. When your see >>Is this system ready for updating?
   Please respond Y|N > << Type Y and press Enter Key

9. at finishing you will see >>OPatch succeeded.
   OPatch returns with error code = 0 <<

10. write cscript //nologo remove_demo.js like (c:\7047034>cscript //nologo remove_demo.js)

Your are done. ;)

Now open form builder and open any form without error.

Enjoy Oracle Forms Developing..

If it helps, Leave your message.