Home »
» ATI LTD USER MANUAL
12:00 PM
Related Posts:
Oracle date function(Attendance related).
Note : Your database table name hr_biometricattendancecnt it has one field login_time
this query give you first login time and last login time.
select to_char(first_login,'HH24:Mi:SS AM')First,to_char(last_login,'HH2… Read More- Colling form condition add.
DECLARE
cl_frm varchar2(10);
begin
cl_frm := GET_APPLICATION_PROPERTY(calling_form);
if
cl_frm='ORF_M03' THEN
SET_TAB_PAGE_PROPERTY('OR_ADVICE', enabled, property_false);
SET_TAB_PAGE_PROPERTY('OR_ADVICE', vis… Read More
- Exception handle
If used function
EXCEPTION
WHEN NO_DATA_FOUND THEN
RETURN null;
end;
Others
EXCEPTION
WHEN NO_DATA_FOUND THEN
null;
end;
… Read More
- Forms Alert
Example 1 :
SHOW_ALT('PMF_M35_007',V_ALET);
IF UPPER(V_ALET) = 'NO' THEN
RETURN;
… Read More
- oracle forms where condition default where
PROCEDURE PRC_SEARCH IS
V_WHERE varchar2(4000);
BEGIN
V_WHERE := 'COMPANY_NO=:GLOBAL.G_COMPANY_NO';
IF :CTRL_SEARCH.SLOT_GROUP IS NOT NULL THEN
V_WHERE := V_WHERE||' AND SLOT_GROUP = :CTRL_SEARCH.SLOT_GROU… Read More
Time in Dhaka 
All lINK : 1. http://www.123techguru.com/types-of-controls/ Built_in sub programs used in Form Triggers . 1 commit_form used to ...
বয়স সবে ত্রিশের কোটা পেরোচ্ছে। আর এরই মধ্যে খেয়াল করলেন , মাথার চুল পড়ে যেন টাক হয়ে যাচ্ছে ! ব্যাপারটা মোটেই সুখকর ...
How to Connect Oracle Database with Microsoft Access Database? My first post for oracle developer. when you want to try c...
0 comments:
Post a Comment