Top "Oracle" questions

ORA-04036: PGA memory used by the instance exceeds PGA_AGGREGATE_LIMIT

I came across ORA-04036 (on 12c) while one of my team members was creating an oracle text index. ORA-29855: error …

oracle oracle12c

Simple Oracle variable SQL Assignment

Despite having spent an hour researching I can't seem to figure out how to correctly define a variable and then …

oracle variables plsql toad

Is there any way to flush output from PL/SQL in Oracle?

I have an SQL script that is called from within a shell script and takes a long time to run. …

sql oracle plsql dbms-output

BETWEEN clause versus <= AND >=

Is there a performance difference between using a BETWEEN clause or using <= AND >= comparisons? i.e. these two …

sql performance oracle oracle10g oracle11g

SQL: How to find duplicates based on two fields?

I have rows in an Oracle database table which should be unique for a combination of two fields but the …

sql oracle unique unique-constraint ora-00918

oracle convert DD-MON-YY to DD/MM/YYYY

I am trying to convert the format of a varchar2 column from 'DD-MON-YY' to 'DD/MM/YYYY'. In example: from …

oracle date varchar2

How to find foreign-key dependencies pointing to one record in Oracle?

I have a very large Oracle database, with many many tables and millions of rows. I need to delete one …

database oracle database-schema

SqlPlus SP2-0734: Error

I am new to using SqlPlus but not new to using SQL, and I get the following error after writing …

sql oracle unix sqlplus

How to give a unique constraint to a combination of columns in Oracle?

I have a Table with 4 Columns Each Column will be A,B,C,D Column A is the Primary key. …

sql oracle constraints unique-constraint composite-key

What does "%Type" mean in Oracle sql?

I'm getting my first experience with Oracle and TOAD (I know SSMS). I came across this "%Type" next to an …

sql oracle plsql