Search found 1966 matches

by admin
Mon Nov 29, 2021 4:11 am
Forum: Oracle APEX
Topic: Trigger to Assign sequence as PK
Replies: 0
Views: 16

Trigger to Assign sequence as PK

create or replace SEQUENCE JS_HEALTH_CHECK_seq start with 1 nocache;

CREATE OR REPLACE TRIGGER JS_HEALTH_CHECK_BIU
before insert OR UPDATE ON JS_HEALTH_CHECK
for each row
BEGIN
IF :NEW.ID IS NULL THEN
SELECT JS_HEALTH_CHECK_seq.nextval INTO :NEW.ID FROM sys.dual;
END IF;
END;
/
by admin
Mon Nov 22, 2021 2:08 am
Forum: Oracle APEX
Topic: Uninstall PWA
Replies: 0
Views: 22

Uninstall PWA

C:\Users\Sikandar\AppData\Local\WhatsApp

C:\Users\Sikandar\AppData\Roaming\Microsoft\Windows\Start Menu\Programs\Chrome Apps
by admin
Sat Nov 20, 2021 4:29 am
Forum: Oracle APEX
Topic: Check box in Interactive Reports
Replies: 0
Views: 25

Check box in Interactive Reports

-- A column to be added as below, so the user will check the lines and then in the process loop will insert values in a table. select ID, apex_item.checkbox2(1,PROFILE_ID) as "Select", name from js_users -- Process begin for i in 1..apex_application.g_f1.count loop apex_debug_message.log_m...
by admin
Thu Nov 18, 2021 2:19 am
Forum: Oracle APEX
Topic: Add or Remove Roles
Replies: 0
Views: 27

Add or Remove Roles

apex_acl.add_user_role ( p_application_id => wwv_flow_security.g_flow_id, , p_user_name => p_app_user , p_role_static_id => 'ACCOUNTANT' ); apex_acl.remove_user_role ( p_application_id => default wwv_flow_security.g_flow_id, , p_user_name => p_app_user , p_role_static_id => 'ACCOUNTANT' ); APEX_ACL....
by admin
Thu Nov 18, 2021 1:42 am
Forum: Oracle APEX
Topic: Setting Language Preference
Replies: 0
Views: 19

Setting Language Preference

apex_util.set_preference(
p_preference => 'FSP_LANGUAGE_PREFERENCE',
p_value => 'en-us'
);
by admin
Tue Nov 16, 2021 4:06 am
Forum: Oracle APEX
Topic: APEX 21.1 standard Views
Replies: 0
Views: 23

APEX 21.1 standard Views

SQL> select view_name from all_views where owner = 'APEX_210100'; VIEW_NAME -------------------------------------------------------------------------------- WWV_INSTALL_ERRORS WWV_FLOW_RT$SERVICES WWV_FLOW_RT$IDM_PRIVS WWV_FLOW_RT$APEX_ACCOUNT_PRIVS WWV_FLOW_CURRENT_SGID WWV_FLOW_CURRENT_WORKSPACES ...
by admin
Sat Nov 13, 2021 3:57 pm
Forum: Oracle APEX
Topic: Listener and APEX config on XE 21c
Replies: 0
Views: 43

Listener and APEX config on XE 21c

Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 # listener.ora Network Configuration File: C:\app\Sikandar\product\21c\homes\OraDB21Home1\NETWORK\ADMIN\listener.ora # Generated by Oracle configuration tools. DEFAULT_SERVICE_LISTENER = XE SID_LIST_LISTENER = (SI...
by admin
Wed Nov 10, 2021 8:11 am
Forum: Oracle APEX
Topic: Showing image inside a Region
Replies: 0
Views: 39

Showing image inside a Region

To add an image inside a region click the region and in the HTML Code property enter image reference which was uploaded in application static file as a shared component,

<img src="#APP_FILES#technology.jpg">
region1.PNG
by admin
Wed Nov 10, 2021 8:08 am
Forum: Oracle APEX
Topic: Add Extra Display Column in IG - Interactive Grid
Replies: 0
Views: 35

Add Extra Display Column in IG - Interactive Grid

1. Write an SQL as below, select EMPNO, ENAME, JOB, MGR, HIREDATE, SAL, COMM, DEPTNO, (select d.dname from dept d where d.deptno = emp.deptno) DEPT_NAME from EMP IG1.PNG 2. Keep all settings default and now click this DEPT_NAME column under IG and change the property to Query Only. ig2.PNG
by admin
Wed Nov 10, 2021 7:59 am
Forum: Oracle APEX
Topic: Login Page Background Image
Replies: 0
Views: 37

Login Page Background Image

Steps to add a background image on Oracle APEX Login page, background.PNG 1. upload your image file in Oracle APEX, Application 75605 > Shared Components > Static Application Files 2. Once uploaded copy reference of uploaded file #APP_FILES#technology.jpg 3. Open the login page and enter the followi...
by admin
Fri Oct 22, 2021 7:24 am
Forum: Oracle APEX
Topic: Identity Column for Primary key
Replies: 0
Views: 100

Identity Column for Primary key

Oracle had introduced an identity column in 12C and it is to generate auto sequence no for a primary key in a table. A table can have only a single identity column and it has GENERATED [ ALWAYS | BY DEFAULT [ ON NULL ] ] AS IDENTITY [ ( identity_options ) ] create table emp2 ( id number generated al...
by admin
Thu Oct 21, 2021 2:22 am
Forum: Oracle APEX
Topic: User Creation API
Replies: 0
Views: 45

User Creation API

DECLARE l_workspace_id := apex_util.find_security_group_id (p_workspace => 'ERPSTUFF'); apex_util.set_security_group_id (p_security_group_id => l_workspace_id); BEGIN APEX_UTIL.CREATE_USER( p_user_name => 'SIKANDAR', p_first_name => 'Malik Sikandar', p_last_name => 'Hayat', p_description => 'This sc...
by admin
Tue Jul 27, 2021 6:50 am
Forum: Application DBA & System Administration
Topic: Reset User password Script
Replies: 0
Views: 240

Reset User password Script

declare p_user_name varchar2(50) default 'erpstuff'; v_new_password varchar2(50) default 'ERPstuff_123'; BEGIN --select dbms_random.string('A',6) into v_new_password from dual; fnd_user_pkg.updateuser( x_user_name => p_user_name , x_owner => NULL , x_unencrypted_password => v_new_password, x_passwor...
by admin
Mon Jul 19, 2021 5:28 pm
Forum: Oracle APEX
Topic: Generating Barcodes Using Java Script
Replies: 0
Views: 694

Generating Barcodes Using Java Script

Table script CREATE TABLE "JS_PRODUCTS" ( "PRODUCT_NAME" VARCHAR2(100), "PRODUCT_PRICE" NUMBER, "PRODUCT_BARCODE" VARCHAR2(32) ) / insert into JS_PRODUCTS (PRODUCT_NAME,PRODUCT_PRICE,PRODUCT_BARCODE) Values ('Orange',34,'123456789012'); insert into JS_PRODUCT...
by admin
Sat May 22, 2021 7:03 pm
Forum: Application DBA & System Administration
Topic: Oracle Procedures, Functions and Packages Sample Code
Replies: 0
Views: 272

Oracle Procedures, Functions and Packages Sample Code

Here you can find sample code to practice procedure, function, and packages explained in the following video in youtube, https://youtu.be/_FdPeyjfols --select my_procedure(10,10) from dual; exec my_package.myprocedure(10); declare D number; begin my_procedure(A => 10, B => 10); --DBMS_OUTPUT.PUT_LIN...