Top "Oracle" questions

Is it safe to put an index on an Oracle Temporary Table?

I have read that one should not analyze a temp table, as it screws up the table statistics for others. …

oracle indexing temp-tables

How to install Oracle Instant Client on a Mac?

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 …

oracle macos oracle12c instantclient

Sql*plus always returns exit code 0?

Whenever I run a sql script using Sql*plus and check for $?, I get 0 even when the script wasn't succesful. …

oracle scripting sqlplus exit-code

How would I create a table in Oracle 11g R2 from a SELECT AS and partition the table by range-list?

I am trying to create a new table called Titles2 from an existing table called Titles. I have to use …

sql oracle oracle11gr2

How to use DBMS_CRYPTO.encrypt function in oracle

I want to encrypt password column in the database and I am trying to use encrypt function present inside DBMS_…

database oracle oracle11g oracle10g database-administration

ORA-12899 value too large for column despite of same length

I am running the following query. But getting ORA-12899. Altough the length of string am trying to insert is 30. INSERT …

sql oracle varchar varchar2

PL/SQL Developer Initialization error

I want use PL/SQL Developer first my oracle directory C:\oracle\product\10.2.0\client_1\BIN I use windows10 and environment …

oracle plsqldeveloper

Difference between Oracle Client and ODAC

What is the difference between installing the full Oracle Client and an Oracle Odac install? Which will I need to …

oracle odac

Clear Screen in SQL*Plus

I'm running the following report but getting an error /* Simple table formatting */ clear screen; accept Report_File char prompt 'Enter …

sql oracle sqlplus

oracle sql plus spool

I'm using sql plus to execute a query (a select) and dump the result into a file, using spool option. …

sql oracle sqlplus spool