Search found 2063 matches
- Wed Nov 10, 2021 8:08 am
- Forum: Oracle APEX
- Topic: Add Extra Display Column in IG - Interactive Grid
- Replies: 0
- Views: 10533
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
- Wed Nov 10, 2021 7:59 am
- Forum: Oracle APEX
- Topic: Login Page Background Image
- Replies: 0
- Views: 10238
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...
- Fri Oct 22, 2021 7:24 am
- Forum: Oracle APEX
- Topic: SEQUENCES | Primary Key | ID | Foreign Key
- Replies: 0
- Views: 10803
SEQUENCES | Primary Key | ID | Foreign 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...
- Thu Oct 21, 2021 2:22 am
- Forum: Oracle APEX
- Topic: User Creation API
- Replies: 0
- Views: 10252
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...
- Tue Jul 27, 2021 6:50 am
- Forum: Application DBA & System Administration
- Topic: Reset User password Script
- Replies: 0
- Views: 11683
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...
- Mon Jul 19, 2021 5:28 pm
- Forum: Oracle APEX
- Topic: Generating Barcodes Using Java Script
- Replies: 0
- Views: 10696
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...
- Sat May 22, 2021 7:03 pm
- Forum: Application DBA & System Administration
- Topic: Oracle Procedures, Functions and Packages Sample Code
- Replies: 0
- Views: 11532
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...
- Wed May 05, 2021 6:10 pm
- Forum: Oracle APEX
- Topic: Quick SQL
- Replies: 0
- Views: 9806
Quick SQL
Please note that indentation is important in the code, # settings = db: "18c", apex: true, api: true, schema: "erpstuff", prefix: "JS" # PK: "seq", genPK: true, history: true, verbose: true # auditcols: true, createdByCol: "created_by", createdCol: &...
- Mon Feb 22, 2021 6:53 am
- Forum: Oracle APEX
- Topic: Convert string to rows/table
- Replies: 0
- Views: 9752
Convert string to rows/table
select * from table(apex_string.split('1,2,3',','))
select * from table(apex_string.split('1:2:3',':'))
Output will be
1
2
3
select * from table(apex_string.split('1:2:3',':'))
Output will be
1
2
3
- Thu Feb 18, 2021 5:27 am
- Forum: Oracle APEX
- Topic: APEX Installation on Windows in Pluggable DB 19C
- Replies: 0
- Views: 9733
APEX Installation on Windows in Pluggable DB 19C
Oracle APEX 19.2 or below installation on Pluggable Database 12C or greater version of Oracle database, 1. Download and install the Oracle 19C database 2. Install APEX 19.2 3. Go inside APEX folder Login from sqlplus as sys/sysdba 4. show pdbs and switch to ORCLPDB SQL> show pdbs CON_ID CON_NAME OPE...
- Sat Feb 13, 2021 6:11 am
- Forum: Oracle APEX
- Topic: PREPARE_URL Function
- Replies: 0
- Views: 9361
PREPARE_URL Function
APEX_UTIL.PREPARE_URL ( p_url IN VARCHAR2, p_url_charset IN VARCHAR2 default null, p_checksum_type IN VARCHAR2 default null, p_triggering_element IN VARCHAR2 default 'this') RETURN VARCHAR2; Note: As shown below each dot is mandatory so don't remove even a dot as without dot it will give an error li...
- Sat Feb 13, 2021 5:55 am
- Forum: Oracle APEX
- Topic: Substitution Strings in APEX
- Replies: 0
- Views: 9291
Substitution Strings in APEX
How to get certain value using substitution strings, Examples: f?p=&APP_ID.:&APP_PAGE_ID.:&APP_SESSION. the above is to create a URL and if you see &APP_PAGE_ID. will bring page ID and note the last dot must be there. In this URL 3 substitutions are there &APP_ID., &APP_PAGE_...
- Tue Jan 26, 2021 7:25 pm
- Forum: Excel 2010, 2013, 2016, 365
- Topic: Generate Random Complex Passwords Using Excel without VBA
- Replies: 0
- Views: 20860
Generate Random Complex Passwords Using Excel without VBA
These days security of information is a real concern no matter it is personal or business. Normally people keep very simple passwords while thinking no one can guess it but believe me these days cracking a password is very easy and simple. So setting personal passwords of your social media account l...
- Tue Jan 26, 2021 5:15 pm
- Forum: Oracle APEX
- Topic: Dynamic List with Icons
- Replies: 0
- Views: 9579
Dynamic List with Icons
1- Create Dynamic List in Shared Components SELECT null, FUNCTION label, Page_URL target, 'NO' is_current, 'fa-plus-square' icon << FROM My_Table List of icons: https://apex.oracle.com/pls/apex/f?p=42:icons 2- Creation List region and assign list item created above. 3- Select the list region and in ...
- Mon Jan 25, 2021 10:27 am
- Forum: Order Management
- Topic: RMA at what price?
- Replies: 0
- Views: 11158
RMA at what price?
There are 2 aspects, in RMA one is revenue reversal and the other is COGS reversal. Revenue would get reserved at Selling Prices which is does via. Credit Note creation, on the other, had Receipt of the Material would be reversed at COGS value of parent sales order issue. and also get debited to Inv...