Search found 1956 matches

by admin
Fri Oct 22, 2021 7:24 am
Forum: Oracle APEX
Topic: Identity Column for Primary key
Replies: 0
Views: 17

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: 6

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: 173

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: 621

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: 214

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...
by admin
Wed May 05, 2021 6:10 pm
Forum: Oracle APEX
Topic: Quick SQL
Replies: 0
Views: 248

Quick SQL

Please note that indentation is important in the code, # settings = db: "18c", apex: true, api: true, auditcols: true, PK: "seq", genPK: true, history: true, verbose: true, createdByCol: "created_by_user", createdCol: "created_date", updatedByCol: "last_u...
by admin
Mon Feb 22, 2021 6:53 am
Forum: Oracle APEX
Topic: Convert string to rows/table
Replies: 0
Views: 345

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
by admin
Thu Feb 18, 2021 5:27 am
Forum: Oracle APEX
Topic: APEX Installation on Windows in Pluggable DB 19C
Replies: 0
Views: 290

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...
by admin
Sat Feb 13, 2021 6:11 am
Forum: Oracle APEX
Topic: PREPARE_URL Function
Replies: 0
Views: 253

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...
by admin
Sat Feb 13, 2021 5:55 am
Forum: Oracle APEX
Topic: Substitution Strings in APEX
Replies: 0
Views: 256

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_...
by admin
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: 346

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...
by admin
Tue Jan 26, 2021 5:15 pm
Forum: Oracle APEX
Topic: Dynamic List with Icons
Replies: 0
Views: 256

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 ...
by admin
Mon Jan 25, 2021 10:27 am
Forum: Order Management
Topic: RMA at what price?
Replies: 0
Views: 269

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...
by admin
Mon Jan 25, 2021 10:24 am
Forum: Application DBA & System Administration
Topic: Get SQL from an OAF Page
Replies: 0
Views: 312

Get SQL from an OAF Page

1) Set the following profiles FND: Diagnostics Personalize Self-Service Defn 2) Open Java OAF Page. 3) Click on About this Page in the bottom left of the page. 4) Expand the Business Component References Details Section and go to the View Objects Sub Section. 5) Click the Object by reading the last ...
by admin
Wed Jan 13, 2021 6:24 am
Forum: Oracle APEX
Topic: Load Data Using Pl_SQL APEX_DATA_PARSER
Replies: 0
Views: 819

Load Data Using Pl_SQL APEX_DATA_PARSER

-- The APEX_DATA_PARSER.PARSE function allows to "select" up to 300 columns (COL001 to COL300) from the -- parsed file. This example uses the following parameters. -- -- P_CONTENT the file content to be parsed as a BLOB -- P_FILE_NAME the name of the file; only used to derive the file typ...