used BETWEEN optr with range 'a' and 'z'. i want to get all the name by using BETWEEN operator only but as you can see BETWEEN optr only include lower_range(a) and not upper_range(z) , but i also want name starting…
I have below JSON I want to Read all fields from 65300, 230935, 231832 objects which are under discountDetail objects. Problem is 65300, 230935, 231832 objects are dynamic and are not known in advance. These are ids which are created…
is there any way to write query without subquery?. i have with: with test as ( select 1 as user_id, 'sadasdasggg1' as order_id, sysdate - 1 as order_date from dual union select 1, 'sadasdasggg2', sysdate - 2 from dual union…
I'm trying to write a date in a Oracle database date column using php and pdo_oci ,but I got the above error and I can't go on: SQLSTATE[HY000]: General error: 1858 OCIStmtExecute: ORA-01858: a non-numeric character was found where a numeric was expected (extpdo_ocioci_statement.c:155)…
I recently started exploring sql basics in oracle to help myself to work on a migration project where project is subject to migrate from Oracle platform to a different one; while trying to google for a concept, say for instance,…
I need to create an INSERT INTO ... WHERE NOT EXISTS ... SQL query that works on both Postgres and Oracle. Unfortunately, since oracle does not support SELECT statements without FROM I'm struggling to get this query to work. I…
Is there any service offering from AWS, that does real time replication of data from Oracle which is on premises to Oracle instance running on EC2 in AWS ? But the catch is, the table structures are not same between…
I need to do this with Oracle 19c. I have arbitrary json data in a column of a table. I mean, I dont know the names of attributes, not even the deep the data is... Suppose that I can identify…
I have a redhat server with httpd and oci8 installed properly. I can access correctly oracle functions like oci_connect() when using a script runs through the browser. This is my problem: I have a shell script shell.sh that has the…
I am trying to create a JSON output but it is displayed truncated. Table creation and inserts: create table test(c1 number, c2 varchar2(10), c3 varchar2(100)); begin for i in 1 .. 1000 loop insert into test values (i, 'val_' ||…