We found Tables of Following along with Data. Created the Tables : CREATE TABLE "COUNTRY" ( "COUNTRY_ID" VARCHAR2(3), "COUNTRY_NAME" VARCHAR2(100), CONSTRAINT "PK_COUNTRY" PRIMARY KEY ("COUNT…
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…
To manage Stock in the POS System, We can build a View with the following Tables : Products Purchase Details Sell Details Purchase Return Details Sell Return Details Damage View : CREATE OR REPLACE VIEW V_STOCK AS SELECT A.PRODUCT_ID, NVL(A.STOCK,0) …
Column Name Display from Data Dictionary table: SELECT COLUMN_NAME FROM USER_TAB_COLUMNS WHERE TABLE_NAME='EMPLOYEES' ORDER BY COLUMN_ID; output : COLUMN_NAME ----------------------- EMPLOYEE_ID FIRST_NAME LAST_NAME EMAIL PHONE_…
This command will delete duplicate data from any table: delete from Table-Name a where rowid <> ( select max(rowid) from Table-Name b where ltrim(rtrim(a.column1)) = ltrim(rtrim(b.column1)));
-- NAME -- pupbld.sql -- -- DESCRIPTION -- Script to install the SQL*Plus PRODUCT_USER_PROFILE tables. These -- tables allow SQL*Plus to disable commands per user. The tables -- are used only by SQL*Plus and do not affect other clien…
