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