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.

How to Add or Remove List Text Anywhere from List Item?

Dear Mates,
Hope your are fine. Here we will talk a trick of Oracle List Item for Forms Version 10g and 6i.

If you want to remove list text and values from a oracle forms list item. How will you do this ? When there is no remove icons and Backspace and Delete key doesn't work, both just lest blank spaces.

Don't worry. I'm here for your help. Try the following shortcut key..

"Ctrl + Shift + >" - add list element.

"Ctrl + Shift + <" - remove list element.

Leave comment and SMILTE :)