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
I have a table in database with this structure: Username Password Age email Address Phone Number I want to store this table's data manually(not by an input
I have a table in database with this structure: Username Password Age email Address Phone Number I want to store this table's data manually(not by an input
I have been trying for 4 days to: Deploy Oracle Instant Client with Docker. I can give you the Dockerfile but it is 96 lines To use Oracle Instant Client on my
I have a job that runs periodically , and I am not interested in the response ?? is there anyway to make the calling convention , request without waiting for t