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 →
Thumbnail image for MULTISET Operations: Combining Nested Tables Made Easy

MULTISET Operations: Combining Nested Tables Made Easy

Oracle 10G onwards, MULTISET operations using UNION, INTERSECT, MINUS can work as single-step set operations on PL/SQL nested tables without procedural code for row-by-row comparison. Here’s how.

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 →