Naming conventions-pl/sql, PL-SQL Programming

Naming Conventions

The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exceptions, functions, and packages. The Names can be simple, remote, qualified, or both qualified and remote. For illustration, you might use the procedure name raise_salary in any of the following ways shown below:

raise_salary(...); -- simple
emp_actions.raise_salary(...); -- qualified
raise_salary@newyork(...); -- remote
emp_actions.raise_salary@newyork(...); -- qualified and remote

In the first condition, you basically use the procedure name. In the second condition, you should qualify the name using the dot notation as the procedure is stored in a package named as the emp_actions. In the third condition, using the remote access indicator (@), you reference the database link newyork as the procedure is stored in the remote database. In the fourth condition, you qualify the procedure name and reference the database link.

Posted Date: 10/3/2012 4:50:07 AM | Location : United States







Related Discussions:- Naming conventions-pl/sql, Assignment Help, Ask Question on Naming conventions-pl/sql, Get Answer, Expert's Help, Naming conventions-pl/sql Discussions

Write discussion on Naming conventions-pl/sql
Your posts are moderated
Related Questions
Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

Using Operator VALUE: As you may expect, the operator VALUE returns the value of an object. The VALUE takes its argument a correlation variable.  For illustration, to return a

Number Types The Number types permit you to store the numeric data (real numbers, integers, and floating-point numbers), show quantities, and do computations. BINARY_INTEG

DELETE Command - SQL Loosely speaking, DELETE removes some existing rows from its target table. Suppose the university decides that course C3 is to be withdrawn. Example shows

LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o

Data Types in SQL - Interval, Boolean INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on. BOOLEAN, con

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

Parameter Modes   To define the behavior of formal parameters you use the parameter modes. The 3 parameter modes, IN, OUT, & IN OUT, can be used with any subprogram. Though, a

Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN