I have a main table that contains the data I have, and a reference table telling me what values the main table should have. I want to check if the mai...

I have an Oracle query that returns one or zero rows, from a complex query containing lots of joins and filters. I was tasked with optimizing that que...

I have encountered an odd behaviour of Oracle 23c. As far as I understand lack of the second parameter in the ROUND function should work exactly the s...

I want to hide/show columns in my interactive grid depending on condition. So far I wrote this: function Filter_columns(column_name) { var grid = ap...

I want to create a query in oracle that looks like this DECLARE my_count NUMBER; BEGIN SELECT COUNT(table.column1) INTO my_count FROM table; I...

My Table structure & data- CREATE TABLE T_PTS_TEST ( CITY_ID NUMBER, MNTH DATE, EARNS NUMBER, BURNS NUMBER ...

This question follows from this, but I ran into another different issue. I am generating a large text output using PL/SQL set serveroutput on size 100...

Using oracle plsql, please tell me how to use JSON_TABLE, bfilename and "bulk collect" in order to read data from a json file. The json file contains ...

I'm new with Oracle and I'm just trying to import a dump file. I'm able to create my container database, however when I go to run impdp gy/gy@mygy fi...

I would like to pivot the columns in the original table (Table1) below to produce the desired output on Oracle SQL. Below is the query to create the t...

I have an IG with the following query for PL/SQL returning function body: declare L_sql varchar2(4000); l_instead varchar2(100); begin l_sql := 'selec...

I have below code trying to fetch some data from Oracle DB tableName based on post request sent. I form query queryString using all post request input...

Suppose I have a query like this (not so practical, and I'm aware this is not the approach) SELECT * FROM CO.CUSTOMERS WHERE CUSTOMER_ID = '1' AN...

I have data structured like this: ID Begin Date End Date 1 1/1/2023 2/1/2023 1 2/2/2023 2/15/2023 1 2/20/2023 9/21/2023 1 9/22/2023 10/1...

I am unable to understand why below function throws invalid parameter error for p_id and p_name parameters. CREATE OR REPLACE FUNCTION GET_DIFF( link ...

There are tables transactions and currencyRate: fiddle I am displaying transactions of client (sender_name) with total amount sent money more than (am...

I have a CLOB column in my database that contains content like this: "1.0"?> tdfmt sel-start="218">31 05 2022 Rico Strydombr/> Op verzoek (zie e-mail)...

I always need the 1st of the next year for a query in my Oracle. The date format from today's perspective should therefore look like this: 01-JAN-24 H...

I have created and Oracle 21 CDB named netcoolc, but because of some reason I cannot connect with the sys user with the right connection string... [re...

I am making a user profile page and the user (currently logged in) data is stored in USERS table. I created a user profile page and I have been changi...

I have one JSON file and I´m trying to insert in database. Inserts are not working, not sure if I am looping correctly json I´ve done a very easy exam...

while migrate project code from oracle 12c to 19c we are facing parallels hint issue for view. when we are using below code the parallel degree workin...

On a complete new environment I have created restful services. Using PLSQL, Through below code on SQL developer when tried, I received ORA-20001: Aut...

I have confidential numbers that I want to replace. For Example: 5712221479 6782236690 I want to replace the last four digits by adding 1 digit. 57122...

I wanna search for certain data with the a certain pattern. But I would like to do it as an user-input function, search for the pattern that i put in....