Parameters

Proxy authentication in Oracle

Proxy User Authentication in Oracle

Proxy user authentication in Oracle provides an effective way to manage both security and ease of setup, especially useful in a multi-user work environment.

Read the Full Article →
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 maximum key length (6398) exceeded” might occur when a table index is being created in the Oracle database. Possible reasons why this error shows up and how to fix it.

Read the Full Article →
MULTISET Operations

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 →
Thumbnail image for How to Find Out Your Oracle Database Name

How to Find Out Your Oracle Database Name

Oracle gives you easy ways to find out your Oracle database name from inside a SQL*Plus session. Here are three ways: using V$DATABASE, GLOBAL_NAME, and DBMS_UTILITY.GET_PARAMETER_VALUE.

Read the Full Article →
Thumbnail image for How to Set ORACLE_HOME Path

How to Set ORACLE_HOME Path

Answers to frequently asked questions about ORACLE_HOME: what is ORACLE_HOME, how to check if ORACLE_HOME path is set, and how to set or unset it.

Read the Full Article →