What would you learn in this session: 1. Attendance Generations (using DBlinks to get data from access DB). 2. DBLink from another DB. 3. Get data from Excel and Access DB. http://www.easysoft.com/applications/oracle/database-gateway-d…
The following function will calculate total seconds getting parameter of two time values: CREATE OR REPLACE FUNCTION F_TIME (VTIMEIN VARCHAR2,VTIMEOUT VARCHAR2) RETURN number IS VSEC_IN NUMBER(10); VSEC_OUT NUMBER(10); VHH …
Disallow Update or delete in Oracle Apex through Process : NB: CREATE PROCESS ON SAVE/"Apply Changes" Button: VAL_UPDATE_PERMISSION DECLARE V_USER_TYPE NUMBER(10); BEGIN SELECT USERTYP INTO V_USER_TYPE FROM APPSUSERS WHERE LTRIM(RTRIM(US…
To create menu based on Table: CREATE TABLE MENUTREE ( CODE VARCHAR2(10), PARENT VARCHAR2(10), TYP CHAR(1), ----------- USER TYPE NAME VARCHAR2(50), ACTIVE CHAR(1), -------…
CREATE TABLE SALARY AND ADD THESE COLUMNS : MON, BONUS_PERC, BONUS_AMOUNT, TOTAL Process : delete from salary where mon=:P21_YR||:P21_MON; INSERT INTO SALARY (EMPNO,ENAME,JOB,MGR,HIREDATE,SAL,COMM,DEPTNO,GENDER,MON, BONUS_PERC, BONUS_AMOUNT, TOTAL) S…
The following function will convert any number to Word Text Format: CREATE OR REPLACE Function LIERP.Wrd(N real default 0,M number default 0) return Varchar2 IS x number(14,2); --:=round(least(n,999999999999.99),2); b char(12); --:=lpad(floor(x),12,&#…
The Function is : CREATE OR REPLACE FUNCTION F_NAMES(V VARCHAR2) RETURN VARCHAR2 IS VNAMES VARCHAR2(100):=' '; BEGIN FOR R IN 1..LENGTH(LTRIM(RTRIM(V))) LOOP VNAMES:=VNAMES||' '||SUBSTR(V,R,1); END LOOP; RETURN LTRIM(RTRIM…
This function will convert any number values to word: CREATE OR REPLACE Function Wrd(N real default 0,M number default 0) return Varchar2 IS x number(14,2); --:=round(least(n,999999999999.99),2); b char(12); --:=lpad(floor(x),12,'0'); c ch…
