Search found 2073 matches
- Tue Sep 17, 2024 10:31 am
- Forum: Oracle APEX
- Topic: Oracle SQL Analytic (Window) Functions: AVG, MAX, MIN, LAG, LEAD, ROW_NUMBER, RANK, DENSE_RANK
- Replies: 0
- Views: 232
Oracle SQL Analytic (Window) Functions: AVG, MAX, MIN, LAG, LEAD, ROW_NUMBER, RANK, DENSE_RANK
In this youtube video , I provide an in-depth explanation of Oracle SQL Analytic (Window) Functions, covering the following functions: AVG, MAX, MIN, LAG, LEAD, ROW_NUMBER, RANK, and DENSE_RANK. These functions are powerful tools for performing advanced queries and calculations across rows within a ...
- Fri Aug 23, 2024 1:59 pm
- Forum: Oracle APEX
- Topic: Substitution Strings and Bind Variables for Tasks
- Replies: 0
- Views: 252
Substitution Strings and Bind Variables for Tasks
APEX$TASK_PK If a primary key column has been defined, this bind variable contains the primary key value. APEX$TASK_PK can also be used as a bind variable in any PL/SQL query used by Task Definition Actions and Task Definition Participants. When used as a bind variable, the syntax is :APEX$TASK_PK ...
- Sun Jul 14, 2024 1:19 pm
- Forum: Oracle APEX
- Topic: Important Scripts & Tips
- Replies: 0
- Views: 2097
Important Scripts & Tips
SELECT * FROM apex_release; Upgrade @apexins.sql sysaux sysaux temp /i @apex_rest_config.sql Patch Starting ORDS service ords --config D:\Oracle_19c\ords\config serve There is a problem with your environment because the Application Express files have not been loaded. Please verify that you have ...
- Tue Jul 02, 2024 5:43 pm
- Forum: Oracle APEX
- Topic: Basic Authentication vs OAuth & OAuth Demo in Oracle APEX 24.1
- Replies: 0
- Views: 2670
Basic Authentication vs OAuth & OAuth Demo in Oracle APEX 24.1
First of all, we need to understand differences between these two methods used to implement security while doing integration of two applications. Once understanding is established then it will be very easy to implement one of them as per your requirements in Oracle APEX. In is topic we will be doing ...
- Mon Jul 01, 2024 12:59 pm
- Forum: Application DBA & System Administration
- Topic: Finding OPP Log File
- Replies: 0
- Views: 2801
Finding OPP Log File
SELECT fcpa.concurrent_request_id request_id, PUBLISHER_RETURN_RESULTS, fcp.node_name node_name, fcp.logfile_name logfile_path FROM fnd_conc_pp_actions fcpa, fnd_concurrent_processes fcp WHERE fcpa.processor_id = fcp.concurrent_process_id -- AND fcpa.action_type = 6 AND fcpa.concurrent_request_id ...
- Sun Jun 30, 2024 6:55 am
- Forum: Oracle APEX
- Topic: Oracle APEX QR-Codes, EAN-8, and Code-128 Comprehensive Explanation, Demo & Scripts
- Replies: 0
- Views: 2320
Oracle APEX QR-Codes, EAN-8, and Code-128 Comprehensive Explanation, Demo & Scripts
Generation of QR code, EAN8 and Code128 was offered by Oracle first time in Oracle APEX release 23.2. You can use PL/SQL to generated using provided package APEX_BARCODE. Here I have provided code the way you can generate these code and practice in your Oracle APEX instance. Classic Report basrcodes ...
- Sun Jun 23, 2024 5:00 am
- Forum: Oracle APEX
- Topic: Configuring SMTP Connection in APEX Autonomous Database
- Replies: 0
- Views: 2321
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 ...
- Tue Jun 18, 2024 8:47 am
- Forum: Oracle APEX
- Topic: Upgrading Oracle APEX in Oracle Cloud Autonomous Database
- Replies: 0
- Views: 2392
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 ...
- Thu Jun 13, 2024 10:55 am
- Forum: Oracle APEX
- Topic: Change ORDS_PUBLIC_USER in ORDS 23.2 password
- Replies: 0
- Views: 2156
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.
it will ask for password twice.
- 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: 2221
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 ...
- Wed Apr 24, 2024 3:28 am
- Forum: Application DBA & System Administration
- Topic: How to delete an Oracle Service in Windows?
- Replies: 0
- Views: 9820
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
[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
- Fri Mar 01, 2024 4:51 pm
- Forum: Application DBA & System Administration
- Topic: Tasks Scheduling in Windows
- Replies: 0
- Views: 10363
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 ...
- 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: 13958
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 ...
- Sun Jan 28, 2024 5:39 pm
- Forum: Oracle APEX
- Topic: Oracle APEX Collection Details
- Replies: 0
- Views: 14016
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 ...
- Wed Jan 17, 2024 4:46 am
- Forum: Oracle APEX
- Topic: WITH SQL Clause Concepts
- Replies: 0
- Views: 10675
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 ...