Home »
» Hospital Management Software Menu Screens Video
9:16 AM
Related Posts:
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
- procedure
Use procedure in oracle forms :
CREATE PROCEDURE PRC_BED_WARD (p_ADMISSION_NO IN IP_ADMISSION.ADMISSION_NO%TYPE,
p_COMPANY_NO IN SC_SYSTEM_CONTROL.COMPANY_NO%TYPE,
p_… Read More
- Forms Alert
Example 1 :
SHOW_ALT('PMF_M35_007',V_ALET);
IF UPPER(V_ALET) = 'NO' THEN
RETURN;
… Read More
- 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
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