Home »
» C language (loop)
4:27 PM
Related Posts:
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
- function
**
THIS FUNCTION WILL CHECK WEEKEND DAY<>
CREATE OR REPLACE FUNCTION FNC_ROOMWEEKFLAG (p_room_no varchar,p_day date )
return int
as
v_s char(1);
v_n char(1);
v_m char(1);
v_t char(1);
v_w… 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
- MENU ITEM CALL FROM RESTRICTION PL/SQL
declare
xx number(1) := 0;
begin
if USER IN ('PMS','SUPER') THEN
xx :=1;
elsif PMS.IS_PERMITTED_TO_FORM(USER,'BILL','ACNO_REB') = 1 THEN
xx :=1;
&nbs… 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