Synonyms- naming conventions, PL-SQL Programming

Synonyms

You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages.
Though, you cannot create synonyms for the items declared within subprograms or packages. That involves variables, constants, cursors, exceptions packaged subprograms, and cursor variables.

Posted Date: 10/3/2012 4:51:05 AM | Location : United States







Related Discussions:- Synonyms- naming conventions, Assignment Help, Ask Question on Synonyms- naming conventions, Get Answer, Expert's Help, Synonyms- naming conventions Discussions

Write discussion on Synonyms- naming conventions
Your posts are moderated
Related Questions
Autonomous versus Nested Transactions Though an autonomous transaction is started by the other transaction, it is not a nested transaction for the reasons shown below: (i)

Cursor Variables As Parameters You can declare the cursor variables as the formal parameters of the functions and procedures. In the illustration below, you define the REF CUR

THEO R Y OF ETERNITY OF LIFE (PRAYER - 1880) - The theory of eternity of life, also called the steady-state theory , states that life has ever been in existence as at presen

Controlling Autonomous Transactions The first SQL statement in an autonomous routine starts a transaction. Whenever one transaction ends, the next SQL statement starts the oth

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

MECHANISTI S THEORY-HAECKEL (1866) - Haeckel stating that after each catalysm, some new organism suddenly forms as a chance event in one stride from inanimate matter and sub

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Project Description: I want a small relational database to be built. I want the database to have the subsequent information tables: Employee Information Document storage

Scoping Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name.

Introduction Oracle 9i - it was made public in the year 2001 with over 400 features, and graphics, it has merged the traditional business with modern internet application