Archive for January, 2013
ORACLE : How to Add or Remove List Text Anywhere from List Item?
January 30th, 2013, posted in OracleHere 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.
Try the following shortcut keys:
ORACLE : How to Show / Get, Year Month and Date between two date ?
January 28th, 2013, posted in Oracle QueriesUse bellow sql to show year month and date :
SELECTÂ Â Â TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE) / 12) as YEARS,
MOD(TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE)), 12) as MONTHS,
(Â TO_DATE (:END_DATE)- ADD_MONTHS (:START_DATE,TRUNC (MONTHS_BETWEEN (:END_DATE, :START_DATE))))Â as Date
FROM DUAL;
********************************************************************************************************************* Note : Please not do make backups before using these queries and also confirm them yourself or by aother means as well. *********************************************************************************************************************
