Top "Oracle" questions

pseudo columns & DUAL table - what do they actually mean?

Dual table is used to select pseudo columns. it has one row and one column DUMMY which has a value …

sql oracle dual-table

How to sync and optimize an Oracle Text index?

We want to use a ctxsys.context index type for full text search. But I was quite surprised, that an …

oracle full-text-search oracle-text

Replacing System.Data.OracleClient to Oracle.DataAccess (ODP.NET)

I have a project which is using System.Data.OracleClient at the moment and since it is being deprecated so …

c# .net oracle oracle11g odp.net

Select statement inside NVL

I'm trying to run the following query: select a.*, case when NVL (SELECT max(b.field1) FROM b where b.…

oracle nvl

SQL Loader Error: "Variable length field exceeds maximum length."

I have a SQL Loader Control file, LOAD DATA INFILE 'test.txt' INTO TABLE TEST replace fields terminated "|" optionally enclosed …

oracle sql-loader

How to export & import only data in oracle 11g?

I want to export only data on of my master tables and then imports it to some other server on …

database oracle database-administration

Variables in TOAD scripts

I have a SQL script that is being executed in TOAD. Currently, I have it laid out with just statement …

sql oracle plsql toad

grant permission for dbms_crypto

I am using dbms_crypto.encrypt function in my oracle procedure for encryption of passwords. I have connected to oracle …

oracle permissions grant sysdba dbms-crypto

How do I specify date literal when writing SQL query from SQL Server that is linked to Oracle?

I have a SQL Server 12.0 database that is linked to an Oracle 12.1 database. I want to create a view in …

sql sql-server oracle date-formatting

Setting Oracle size of row fetches higher makes my app slower?

As detailed here and confirmed here, the default number of rows Oracle returns at time when querying for data over …

java performance oracle jdbc oracle11g