I need to get the the specified mapped column names only, I tried using <%=odiRef.getColList("", "[CX_COL_NAME]",",", "","")%> and <%=odiRef.getColList
I had this query working properly for years until recently where i changed another query in the collector and saved. I didnt change this xml query at all, but
I have a query that uses Oracle's MDSYS.ST_GEOMETRY type (link): select mdsys.st_point(1, 2, 26917) from dual Output: [MDSYS.ST_POINT] The query outp
Here is a fairly simple query that is throwing this error: SELECT RR.REQUEST_ID FROM CCS_REQUEST_RESPONSE RR INNER JOIN VW_STUDENT_CURRENT_AND_HIST VW ON RR.S
I've looked up questions here as well as looking online and watching videos but I'm still confused exactly what IN, OUT is. The reason I'm asking is because I'm
Consider a query with this structure: select ..., ROWNUM from t where <where clause> group by <columns> having <having clause> order by &
I followed the instructions mentioned to install SQL*Plus from Oracle Instant Client and How to Install SQLPlus. SQL*Plus is successfully installed on my syste
I have a problem when trying to read Blob from oracle DB by using this rs.getBlob("ARCHIVE_REQ_FILE_BLOB") and also i try this oracle.sql.BLOB blob= (orac
I have 2 columns called MONTH, and YEAR. The YEAR is just pulling in as INT and contains values such as 2017 2018 2019 etc... The MONTH column however is pul
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