parameters

Thumbnail image for ORA-01450: Maximum Key Length Exceeded – Possible Causes and Fix

ORA-01450: Maximum Key Length Exceeded – Possible Causes and Fix

ORA-01450 might crop up when a table index is being created in the database: ORA-01450: maximum key length (6398) exceeded Oracle documentation has this to say about the error: Cause: The combined length of all the columns specified in a CREATE INDEX statement exceeded the maximum index length. The maximum index length varies by operating […]

Read the Full Article →
Thumbnail image for MULTISET Operations: Combining Nested Tables Made Easy

MULTISET Operations: Combining Nested Tables Made Easy

Set operators (UNION, INTERSECT, MINUS) have long been available in basic SQL to process data in tables, but for data in PL/SQL nested tables, we’d earlier have to go through the ritual of traversing through the collections in a loop, doing a row-by-row comparison. Oracle 10G onwards, MULTISET features have made possible single-step set operations […]

Read the Full Article →
find-database-name

Quick way to find out your database name

Oracle gives you a number of ways to know the name of the database you are connected to, from inside a SQL*Plus session. Through V$DATABASE: The above will work only if your login has access to V$DATABASE. This is generally accessible to DBA logins only. If you have a non-DBA login, use one of the […]

Read the Full Article →
Thumbnail image for About ORACLE_HOME

About ORACLE_HOME

In Oracle installation guides and scripts, you will often come across the term ORACLE_HOME. In fact, we used it on this site a couple of posts back, in the script to install SCOTT schema in Oracle. This post will cover: the meaning and purpose of ORACLE_HOME how to check if ORACLE_HOME is set how to […]

Read the Full Article →