Questions

It took me 25 years to get used to Oracle using 1-based indexing in pretty much all API's.How the rather new json_array_t data structure used a 0-based indexing and drives me crazy.Is there any reason behind this "strange anomaly" or did someone just want to d...

We requested oracle apex work space area 100MB?It exceeds the over 90% size? How to calculate Current file Utilization and current database size?Requested Size: 100(in MB)Current File Utilization: 6.49(in MB) What is this?Current Database Size: 91....

I have a table like below.<code>create table t2 ( id varchar2(1),val number) ;insert into t2 values ('a',1);insert into t2 values ('a',2);insert into t2 values ('a',3);insert into t2 values ('a',4);insert into t2 values ('b',1);insert into t2 values ('b',2);in...

Got information from your archives, BUT solution is not provided or there's no solution???Archive : "Why the trigger disappears... May 28, 2003 Reviewer: Kamal Kishore from New Jersey, USA "Hi Tom,After you re-create the view definition using CREATE OR REPL...

Hi Tom,We run a multi-user OLTP system on Exadata Quarter Rack (Linux version). Though the system response time is consistent and is performing well. We observed Run queues with CPU utilization at 70% on both the nodes. What could be the reason?My understandin...

Hi Tom , I need to write a query which will give me a list of dates between two date ranges (start date and end date) . For Example if my start date is 12/01/2003 and end Date is 12/31/2003. i need to generate my output as Date----12/01/200312/02/200312/03/200...

I am looking for read consistency across multiple cursors in a packaged procedure. In the past I have opened the cursors that I wanted to be consistent at the start of the procedure, used them, and closed them at the end. I am starting to think that the time...

According Metalink note 785347.1 it seems possible to have a dataguard with primary 11.2 and standby 12.2 or even later but it is really very condensed.Could you please just confirm that 11.2 -> 12.2 is really possible?If so, what about 11.2 -> 19.x ?Or 12.2 -...

Here is my challenge. I am developing an application that receives webhook notifications when events occur. I have successfully used the restful services functionality in Apex (SQL Workshop>Restful Services) to retrieve data at the first (root?) level succes...

How to call rest api which accept x-www-form-urlencoded in PL/SQL procedure in Apex I am calling https://api.textlocal.in/docs/sendsms...

When i try to run this code:DECLARE STUDENT_ID NUMBER;BEGIN -- Generate the next value for the sequence SELECT LMS_STUDENT_DETAILS_SEQ.nextval; -- Insert data into LMS_STUDENT_DETAILS table INSERT INTO LMS_STUDENT_DETAILS (STUDENT_ID, STUDEN...

Tom,I create databases then I run the catalog.sql and catproc.sql. Sometimes, I donot run pupbld.sql. Users may get warning message but they could login and work.But, My friend says that if pupbld.sql is not run as system then users will get the error messages...

connect system password : password. i got following errorsORA-01034: ORACLE NOT AVAILABLEORA-27101: shared memory realm does not exist...

We have an application that has been written to insert a variable that is char(50) into a column that is defined as char(40). In Oracle 11g (I know this is very old) it would merely truncate the last 10 characters without issue. However, Oracle 19c doesn't a...

Hi TeamI have below scenario.Step#1) User clicks to particular App UI screen.Step#2) User selects multiple filters on UI - say filter1, filter2 which correspond to table columns.Step#3) For each filter selected by user, he needs to enter data - say Mark (for f...

I have a user defined database package which is used quite heavily. When I need to update the code body, I will get several<code>ORA-04061: existing state of package body "CS.PACKAGE" has been invalidatedORA-04065: not executed, altered or dropped package bod...

Hi,I used explain plan and got the following results. Based on cost and time, does query 2 perform significantly better than query 1? The runtime for query 1 is approximately 1 minute and 40 seconds, but it shows 07:47:02. Why is the estimated time so differen...

Hi, Tom. Please see below script.<code>create table t0326 (id number, num varchar2(100)); declare v_empno number:=125854437665589038536841445202964995521300;begin dbms_output.put_line('v_empno -- ' || v_empno); dbms_output.put_line('to_char(v_empno) -- '||...

Hello Tom,A colleague of mine is a big fan of service-oriented architectures and middle-ware. His view is that dblinks are 99.9% of the time a bad idea and that you should go via some sort of message layer in order to pass information between applications.In ...

We recently had a database failure that resulted in data loss after an Oracle 19.3.0.0.0 database had both both its control, and redo log files deleted. Please note that I am not a DBA, but simply an analyst that supports the system that sits on this Oracle da...