public synonym

Public Synonyms in Oracle PL/SQL

Public Synonyms By creating a Public Synonym you allow the user to reference the table name without using the schema owner prefixed on the record name (i.e. SYSADM.PS_VENDOR). This also eliminates the need to perform an ALTER SESSION  command. Example:

How to find tables that do not have a public synonym. Use the following example […]

Read More

combine

Combine Sub Queries in Oracle PL/SQL

Combine Sub Queries in Oracle PL/SQL Separate Sub Queries Most of us do this when we need the most effective date with the most effective sequence.

Combined Sub Queries

This reduces the number of lookup operations the database has to do to one instead of the two in the previous example.

Read More