Top "Oracle" questions

How to force oracle to not to use an index

I have a requirement in which i have to force the sql not to use a particular index which exists …

sql oracle query-performance hints

Insert CLOB into Oracle database

My question is: How do you get around the ORA-01704: string literal too long error when inserting (or doing anything …

java oracle jdbc insert clob

How to call REPLACE with CLOB (without exceeding 32K)

Oracle 11g has certainly improved usability of CLOBs, having overloaded most of the string functions so they now work natively …

oracle plsql oracle11gr2

Error: Could not find or load main class weblogic.Server in soa12c

I have installed the oracle soa 12c in windows.I am getting the Error: Could not find or load main …

oracle soa osb soa-suite

How to fix "The provider is not compatible with the version of Oracle client"?

We're using the Oracle.DataAccess.dll assembly version 2.102.2.20 (32 bit). I deployed our Web API application to IIS and tried openning …

c# asp.net oracle data-access oracle-client

How to show comments of a column with desc operation

I want the desc table; operation to show the comments of the columns. I have seen that some people achieved …

oracle oracle-sqldeveloper

Is "NUMBER" and "NUMBER(*,0)" the same in Oracle?

In Oracle documentation it is mentioned that NUMBER (precision, scale) If a precision is not specified, the column stores values …

sql oracle types oracle11g sqldatatypes

How to connect in java as SYS to Oracle?

I receive this error: java.sql.SQLException: ORA-28009: connection as SYS should be as SYSDBA or SYSOPER How to fix? (…

java database oracle sys

Missing artifact com.oracle:ojdbc7 in eclipse

I have imported a Maven Project in Eclipse (EE Developer) and I have in my pom.xml file the following …

java eclipse oracle maven ojdbc

Oracle Pivot query gives columns with quotes around the column names. What?

I'm trying to use PIVOT in Oracle and I'm getting a weird result. It's probably just an option I need …

sql oracle pivot