Top "Oracle" questions

Oracle Database is a Multi-Model Database Management System created by Oracle Corporation.

Oracle DBMS_LOB.INSTR and CONTAINS performance

Is there any performance difference between dbms_lob.instr and contains or am I doing something wrong? Here is my …

sql oracle oracle10g oracle-text
How to insert/update larger size of data in the Oracle tables?

I want to insert large size of data that character length is more than 10,000. I used CLOB data type to …

oracle oracle10g clob
How to make WHERE clause case insensitive: From SQL Server querying Oracle linked server

We have a MS SQL Server 2005 installation that connects to an Oracle database through a linked server connection. Lots of …

sql-server oracle linked-server case-insensitive openquery
Getting "ORA-01017: invalid username/password; logon denied" when trying to create a data source in Tomcat 6

Been pulling my hair trying to set up a data source in in Tomcat for an application. The steps I've …

oracle tomcat servlets datasource ora-01017
What is the minimum client footprint required to connect C# to an Oracle database?

I have successfully connected to an Oracle database (10g) from C# (Visual Studio 2008) by downloading and installing the client administration …

c# oracle client
Error: ORA-00955: name is already used by an existing object in Oracle Function

I have function which i am trying to compile and getting an error as Error: ORA-00955: name is already used …

sql oracle function privileges grant
Alter a nonunique index to a unique index

I have a few non-unique constraints that I want to alter into unique constraints ( business rules have changed since the …

oracle oracle10g constraints unique-constraint
Oracle number and varchar join

I have a query that joins two tables. One table has a column that is of type varchar, and the …

performance oracle join to-char ora-01722
Oracle -- WITH CLAUSE => MERGE? (Syntax error, )

I'm trying to get the WITH clause to work with merge in Oracle, but for some reason I can't get …

oracle merge with-statement ora-00928 subquery-factoring
Is it ok to use oracle 11g client with a 10g server?

I am creating a .NET program that uses odp.net, specifically the 11g version. Our oracle server is running 10g. …

oracle oracle10g oracle11g odp.net