I need to statistics multiple columns,the following is my writing: with t_suml1 as(select id, date, sum(list1) result from table group by id,date), t_avgl
I'm currently creating an app in Oracle APEX and for some unknown to me reason while trying perform UPDATE/DELETE action by clicking on 'edit' button in the rep
I was interested in MT0's answer on this question using intervals and dates. I was working through trying to find a different way to answer the question and I s
I am trying to test an Oracle Stored Procedure in JMeter. I have already done the configuration to the DB successfully, but when I call the stored procedure and
How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the fil
How to install Oracle Instant Client Version 12.1.0.2 (64-bit) on a Mac (OS X 10.11.5) I have downloaded version 12.1.0.2 (64-bit) version and unzipped the fil
i'm developing an android app with MAF 2.3.0 in Jdeveloper 12.2.1 on a Ubuntu x64 OS and i have android SDK emulator running but everytime i want to deploy my a
Using Oracle Form Builder 10.1.2.3.0, I have a List Item of type Combo Box with a Prompt and next to it in the same Block is a CheckBox. When I disable these tw
I was using Oracle apex cloud account on https://apex.oracle.com/pls/apex Unfortunately my workspace account got locked. As I don't know the password of admin
The table tbl has a column xml_data of type XMLTYPE. Consider the following XML: <root> <element> <id>1</id> <data>abc&l
I´m trying to get a sequence number from an oracle database using a jpaRepository. The main problem is because I don´t have any Object in JpaReposi
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