Use round function
Round(Column_Name,3);
take care
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Search found 132 matches
- Fri Jul 21, 2006 5:35 am
- Forum: General / Others
- Topic: how i control then Decimal
- Replies: 2
- Views: 2090
- Wed Jul 19, 2006 2:12 am
- Forum: Oracle Forms & Reports
- Topic: Number of Character left in Text Item
- Replies: 0
- Views: 2399
Number of Character left in Text Item
Here is sample for number of text left in Text item
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
- Wed Jul 19, 2006 2:00 am
- Forum: Oracle Forms & Reports
- Topic: Search in T-List
- Replies: 0
- Views: 1303
Search in T-List
Here is good sample for search in T-List with 3 different Techniques [img]/images/icon_zip.gif[/img] <b>Attachment:</b> search_tlist.zip <i>( 10881bytes )</i> Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pray Please remember me and my...
- Tue Jul 18, 2006 10:17 am
- Forum: Oracle Forms & Reports
- Topic: which event use for checking befor delete
- Replies: 2
- Views: 1738
Write thers code in <b>PRE-DELETE</b> trigger at block lavel select count(*) into :CHQFOUND from voumaster where cheqno=:rchqno; if :CHQFOUND>0 then message('Can not be del this chq is use'); message('Can not be del this chq is use'); Raise Form_Trigger_Failure; else Message('delete your cheq'); mes...
- Thu Jul 13, 2006 3:57 pm
- Forum: Oracle Forms & Reports
- Topic: GL ERD
- Replies: 5
- Views: 2947
- Thu Jul 13, 2006 3:56 pm
- Forum: Oracle Forms & Reports
- Topic: Invetory control ERD
- Replies: 1
- Views: 1538
- Tue Jul 11, 2006 3:17 pm
- Forum: General / Others
- Topic: Screen capture utility
- Replies: 3
- Views: 2489
- Tue Jul 11, 2006 8:54 am
- Forum: Oracle Forms & Reports
- Topic: Data Import and Export from Text file
- Replies: 1
- Views: 1900
Data Import and Export from Text file
Here is example for import and export data in Comma seperated text file [img]/images/icon_zip.gif[/img] <b>Attachment:</b> data_imp_exp_Oracleforms6i.zip <i>( 12027bytes )</i> Best regards, R E H A N M I R Z A System Analyst / Senior Oracle Developer Cell: +92-304-2120807 When ever you pray Please r...
- Mon Jul 10, 2006 4:44 am
- Forum: General / Others
- Topic: need every first character are upper in query
- Replies: 2
- Views: 2230
Aamir there are 2 ways for this, if you are using PL/Sql function then user initcap function. For example your function name is <b>SpellNumber</b> <b>Initcap(SpellNumber(1251));</b> If you are using this way <b>select to_Char(To_Date(Sal,'j'),'Jsp') splSal from emp</b> Then you you set date formate ...
- Fri Jul 07, 2006 4:00 pm
- Forum: Oracle Forms & Reports
- Topic: how order by use in master detail form
- Replies: 1
- Views: 1266
- Fri Jul 07, 2006 7:22 am
- Forum: Oracle Forms & Reports
- Topic: Navigate Canvas items
- Replies: 8
- Views: 3375
check this code , Bold letter are solved yours new requirement Declare v_NxtItm Varchar2(30) := Get_Block_Property('B1',First_Item); v_Val Varchar2(50); Begin Loop if Get_Item_Property(v_NxtItm,Item_Type) = 'DISPLAY ITEM' then <b>v_Val := Name_In(v_NxtItm); Message(v_Val);</b> Set_Item_Property(v_Nx...
- Fri Jul 07, 2006 5:13 am
- Forum: Oracle Forms & Reports
- Topic: how to handle the LOV
- Replies: 5
- Views: 2795
- Thu Jul 06, 2006 8:43 am
- Forum: Oracle Forms & Reports
- Topic: Navigate Canvas items
- Replies: 8
- Views: 3375
Here is sample code for yours required task, hope it will help you. I assue first item is button and this trigger code put on that buttion <b>Declare v_NxtItm Varchar2(30) := :System.Trigger_Item; Begin Loop v_NxtItm := Get_Item_Property(v_NxtItm,NextItem); if Get_Item_Property(v_NxtItm,Item_Type) =...
- Thu Jul 06, 2006 8:21 am
- Forum: Oracle Forms & Reports
- Topic: how to handle the LOV
- Replies: 5
- Views: 2795
- Wed Jul 05, 2006 2:11 am
- Forum: Oracle Forms & Reports
- Topic: try this but not work
- Replies: 3
- Views: 2783
Use same logic as this link
topic.asp?TOPIC_ID=181
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family
topic.asp?TOPIC_ID=181
take care
Allah Hafiz
Best regards,
R E H A N M I R Z A
System Analyst / Senior Oracle Developer
Cell: +92-304-2120807
When ever you pray
Please remember me and my family