Search found 2067 matches

by admin
Sun Jun 23, 2024 5:00 am
Forum: Oracle APEX
Topic: Configuring SMTP Connection in APEX Autonomous Database
Replies: 0
Views: 63

Configuring SMTP Connection in APEX Autonomous Database

1. Loging to your OCI account. 2. Then Developer Services Under Application Integration, click Email Delivery. email1.png 3. Now Under Email Delivery, click Configuration and the SMTP sending information panel displays the following information: Public Endpoint: smtp.email.ap-singapore-1.oci.oraclec...
by admin
Tue Jun 18, 2024 8:47 am
Forum: Oracle APEX
Topic: Upgrading Oracle APEX in Oracle Cloud Autonomous Database
Replies: 0
Views: 110

Upgrading Oracle APEX in Oracle Cloud Autonomous Database

Hi everyone! If you're using an Oracle Cloud Infrastructure (OCI) account and have Oracle APEX in an Autonomous Database, this article is for you. Whenever a new version of Oracle APEX is released, you might notice a message about Available Updates. This notification ensures that you're aware of the...
by admin
Thu Jun 13, 2024 10:55 am
Forum: Oracle APEX
Topic: Change ORDS_PUBLIC_USER in ORDS 23.2 password
Replies: 0
Views: 19

Change ORDS_PUBLIC_USER in ORDS 23.2 password

ords --config E:\app19c\ords\config config --db-pool default secret db.password

it will ask for password twice.
by admin
Wed Jun 12, 2024 3:13 pm
Forum: Oracle APEX
Topic: ORA-20001: You have exceeded the maximum number of web service requests per workspace
Replies: 0
Views: 33

ORA-20001: You have exceeded the maximum number of web service requests per workspace

Hi, If you get this error while using RESFULL web service then you need to login as Internal/Administration and set setting to higher, ORA-20001: You have exceeded the maximum number of web service requests per workspace Under Workspace isolation as by default it is 1000 in last 24hrs rolling window...
by admin
Wed Apr 24, 2024 3:28 am
Forum: Application DBA & System Administration
Topic: How to delete an Oracle Service in Windows?
Replies: 0
Views: 7681

How to delete an Oracle Service in Windows?

C:\Windows\System32>sc stop OracleServiceORCL21
[SC] ControlService FAILED 1062:

The service has not been started.


C:\Windows\System32>sc delete OracleServiceORCL21
[SC] DeleteService SUCCESS

C:\Windows\System32>sc delete OracleVssWriterORCL21
[SC] DeleteService SUCCESS
by admin
Fri Mar 01, 2024 4:51 pm
Forum: Application DBA & System Administration
Topic: Tasks Scheduling in Windows
Replies: 0
Views: 8335

Tasks Scheduling in Windows

In this video, I explain Windows Scheduler, a powerful tool that allows users to automate tasks in Windows operating systems. Through a series of examples and step-by-step instructions, I demonstrate how to schedule tasks such as software updates, system maintenance, and backups. By utilizing the Sc...
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: 10884

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

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

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

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

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

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

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

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

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 13551 times
Video Link

https://www.youtube.com/watch?v=yckov_eR3OE