I am trying to add a column in a SQL query to use as an alternative ID. The data has this format: UserID | Value --------------- 1 | 23 2 | ...

I've just started working in an Oracle database after years of using MySQL and I'm a little confused about the grouping differences. As a starting poi...

I'm inserting data into the table column whose type is NUMBER(5,2) but when i insert the record it is rounding off the number. I want the number to b...

I'm new to Oracle PLSQL and I'm finding difficulty to find an exact logic which can convert my json_array _t type of data to a SQL table object type a...

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...