I am using oracle transaction to insert into multi-tables one master table and two details tables at the same time. so i will insert one record to the master t
I am trying to fetch 1000 rows using the Hibernate createNativeQuery. The query contains two joins. When I execute the same in SQL developer I see that response
Let be the number of CITY entries in STATION, and let be the number of distinct CITY names in STATION; query the value of from STATION. In other words, find
I have a very simple query that results in two rows: SELECT DISTINCT id, trunc(start_date) start_date FROM example.table WHERE ID = 1 This results in the fol
I living problem in my query. When i add ROUND and DECODE query takes too long time but when i delete directly return value. When i search for sql advice no any
I use a user-defined type (UDT) in Oracle 18c called ST_GEOMETRY: The ST_Geometry storage type ST_Geometry in Oracle SQL functions used with ST_Geometry I have
when merge native query is used using JPA, it is resulting into following error: {"ts":"2022-05-05T17:03:12.124+0000","level":"ERROR","message":"SQL Error: 500
I'm trying to update a single column in multiple rows by appending the string '999': UPDATE integration.ol_orders SET order_id = ((SELECT order_id
How to export output in a CSV format through a procedure. My output is stored in v_output variable Please find below query Declare view_name VARCH
I have a query that uses the listagg function to get all rows as a comma delimited string to ultimately be shipped to a big text box. I'm gett
When I run the following query, I get ORA-00934: group function is not allowed here what is the problem ? select c.Numcom,c.Nompr,c.salaire_fix from com
I have Oracle Database 11g Release 11.2.0.3.0 - 64bit Production With the Real Application Clusters and Automatic Storage Management. OS is Linux Red Hat 2.6.18
I have PHP 8.0 Ubuntu 20.4 running in a VM Symfony Version 5 doctrine/orm 2.8.2 doctrine/dbal 2.12.1 doctrine/migrations 3.1.1 and oracle19c running I have als
I am creating database connection pool using Hikari and it connects and create connection pool successfully on application startup. Application also works fine
I'm forced to use Oracle Form Builder 10.1.2.3.0. An ideal control I can use in the form for a particular item is a List Item using a List Style called Combo Bo
I've a strange behavior with oracle and it's seems it causes problem with Security Policies. When I look the V$Session table, some connection "MACHINE" are only
I have just installed a oracle 12c 12.1.0 DB on a linux machine. after completing the installation i tried to login to database as sysdba [oracle@bjorn adump]
I'm trying to solve the Hackerrank problem Weather Observation Station 3 which is stated below: I came up with the following solution: SELECT CITY FROM STAT
I have following incrementing id: create table PATIENT ( PATIENTID INTEGER generated by default on null as identity ( start wit
Query: Query the 2 cities contained in STATION table with the shortest and longest CITY names, as well as their respective lengths (i.e.: numb