Search found 2061 matches

by admin
Sun Feb 04, 2024 10:22 am
Forum: Oracle Cloud Services Tips & Tricks
Topic: Cloud access if lost phone and MFA enable?
Replies: 0
Views: 360

Cloud access if lost phone and MFA enable?

If you have Oracle Cloud Always Free account then you can be in this situation. Unfortunately Oracle Cloud always free don't have any option to recover from this situation in paid accounts you need to create SR or your administrator can reset it for you. If you will asked for help in Oracle Communit...
by admin
Sun Jan 28, 2024 5:39 pm
Forum: Oracle APEX
Topic: Oracle APEX Collection Details
Replies: 0
Views: 688

Oracle APEX Collection Details

50 character attributes (VARCHAR2(4000)) 5 number attributes 5 date attributes 1 XML Type attribute 1 large binary attribute (BLOB) 1 large character attribute (CLOB) 1 MD5 CREATE_COLLECTION CREATE_OR_TRUNCATE_COLLECTION CREATE_COLLECTION_FROM_QUERY CREATE_COLLECTION_FOM_QUERY2 CREATE_COLLECTION_FRO...
by admin
Wed Jan 17, 2024 4:46 am
Forum: Oracle APEX
Topic: WITH SQL Clause Concepts
Replies: 0
Views: 901

WITH SQL Clause Concepts

Show data of those employees who are having salary more than the average of total salary. WITH avg_sal_query (AVG_SAL) AS ( select round(avg(sal),2) from emp ) select e.empno, e.ename, d.dname, e.sal, a.avg_sal from emp e, dept d, avg_sal_query a where e.deptno = d.deptno and e.sal > a.avg_sal Show...
by admin
Sat Dec 30, 2023 4:45 am
Forum: Oracle APEX
Topic: create a shortest code function to count no of vowels in a string?
Replies: 0
Views: 57239

create a shortest code function to count no of vowels in a string?

Here was a challenge of problem solcing given to our APEX community and here are answers, Try to create a shortest code function to count no of vowels in a string and return count using Oracle PLSQL. Improving problem solving and logic building. enjoy CREATE OR REPLACE FUNCTION fraz.count_vowels(inp...
by admin
Mon Nov 27, 2023 6:07 am
Forum: Oracle APEX
Topic: APEX_WEB_SERVICE Settings
Replies: 0
Views: 73951

APEX_WEB_SERVICE Settings

BEGIN APEX_WEB_SERVICE.g_request_headers.delete(); APEX_WEB_SERVICE.g_request_headers(1).name := 'Content-Type'; APEX_WEB_SERVICE.g_request_headers(1).value := 'application/json'; DBMS_OUTPUT.put_line('name: ' || APEX_WEB_SERVICE.g_request_headers(1).name); DBMS_OUTPUT.put_line('value: ' || APEX_WEB...
by admin
Thu Nov 16, 2023 8:47 am
Forum: Oracle APEX
Topic: Query to check ORDS user Locked
Replies: 0
Views: 72930

Query to check ORDS user Locked

SELECT * FROM dba_users WHERE account_status = 'LOCKED' AND username LIKE '%ORDS%';
by admin
Sat Oct 21, 2023 11:05 am
Forum: Oracle Databases
Topic: Oracle Multitenant Architecture Deep Dive, APEX Installation, and Licensing Insights (12c & 19c)
Replies: 0
Views: 75070

Oracle Multitenant Architecture Deep Dive, APEX Installation, and Licensing Insights (12c & 19c)

Oracle Multitenant Architecture Deep Dive, APEX Installation, and Licensing Insights (12c & 19c) Dive into the intricate world of Oracle Database Multitenant Architecture with this insightful video! Covering the nuances of versions 12c and 19c, the discussion unfolds the complexities and advance...
by admin
Fri Oct 20, 2023 3:10 pm
Forum: Oracle Databases
Topic: CDB, PDB, APEX & ORDS Installation Steps & Commands
Replies: 0
Views: 72676

CDB, PDB, APEX & ORDS Installation Steps & Commands

Oracle Multitanent CDB & PDB commands connection to CDB you can open command prompt/termal and use following command to connect, D:\sqlplus / as sysdba the above will only connect to CDB not PDF. To connect directly with PDF you can create connection string and then use D:\sqlplus sys/my_pass@P...
by admin
Tue Sep 26, 2023 4:06 pm
Forum: Financials (GL, AP, AR, FA & CM)
Topic: Mapping & Importing MT940 in Oracle EBS R12 Cash Management Bank Statements | Auto Reconciliation
Replies: 0
Views: 75823

Mapping & Importing MT940 in Oracle EBS R12 Cash Management Bank Statements | Auto Reconciliation

Mapping & Importing MT940 in Oracle EBS R12 Cash Management Bank Statements | Auto Reconciliation
Oracle r12 cash management.rar
(3.18 MiB) Downloaded 624 times
Video Link

https://www.youtube.com/watch?v=yckov_eR3OE
by admin
Thu Sep 21, 2023 12:09 pm
Forum: Oracle APEX
Topic: Login Page Background Image
Replies: 0
Views: 72545

Login Page Background Image

This video is to show steps and code to change login page background image of Oracle APEX. CODE: body{ background-image: url('#APP_FILES#technology.jpg?auto=compress&cs=tinysrgb&dpr=2&h=650&w=940'); background-position: center; background-repeat: no-repeat; background-size: cover; } ...
by admin
Thu Sep 21, 2023 12:05 pm
Forum: Oracle APEX
Topic: Join ERPstuff Community
Replies: 0
Views: 70931

Join ERPstuff Community

ERPstuff.jpg
by admin
Sat Sep 16, 2023 7:05 am
Forum: Oracle Forms & Reports
Topic: How to connect oracle 6i form with oracle 12c,19c Database ?
Replies: 0
Views: 73719

How to connect oracle 6i form with oracle 12c,19c Database ?

Conn Sys As Sysdba alter profile DEFAULT limit PASSWORD_REUSE_TIME unlimited; alter profile DEFAULT limit PASSWORD_LIFE_TIME unlimited; ---------------Case Sensitive Login---------------------- alter system set sec_case_sensitive_logon=False; ---------------To Allow export of tables with no row-----...
by admin
Mon Sep 11, 2023 8:47 am
Forum: Oracle APEX
Topic: Javascript apex.item
Replies: 0
Views: 70784

Javascript apex.item

$v( "P2_ENAME" ) apex.item( "P2_ENAME" ).getValue() $s( "P2_ENAME", "Sikandar" ) apex.item( "P2_ENAME" ).setValue("Sikandar") apex.item( "P2_ENAME" ).hide() apex.item( "P2_ENAME" ).show() apex.item( "P2_ENAME" ...
by admin
Wed Sep 06, 2023 5:34 am
Forum: Oracle Cloud Services Tips & Tricks
Topic: Oracle Integration Cloud (OIC) and Oracle Cloud Infrastructure (OCI) | Empowering Cloud Solutions
Replies: 0
Views: 74347

Oracle Integration Cloud (OIC) and Oracle Cloud Infrastructure (OCI) | Empowering Cloud Solutions

OIC can refer to two different things, depending on the context: 1. **Oracle Integration Cloud (OIC):** **Oracle Integration Cloud (OIC)** is a cloud-based integration platform provided by Oracle Corporation. It is designed to facilitate the integration of various applications and services, whether ...
by admin
Tue Aug 22, 2023 4:04 pm
Forum: Oracle Cloud Services Tips & Tricks
Topic: How to create Free Oracle Cloud Account?
Replies: 1
Views: 25626

Re: How to create Free Oracle Cloud Account?

Problem 1; Challenge: I realized that on my laptop, I had installed a number of VPNs because my work requires me to connect remotely to execute tasks on client servers. Solution: I uninstalled/disconnected from all VPNs. ------- Problem 2; Challenge: I don't really know if the country originator of ...