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
Varrays versus Nested Tables The Nested tables are differing from varrays in the following ways: 1)  Varrays have a maximum size, while nested tables do not. 2)  Varrays are

Constants and Variables:   You can declare the constants and variables in the declarative section of any PL/SQL subprogram, block, or package. The Declarations allot the stor

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Parameter Default Values As the illustration below shows, you can initialize the IN parameters to the default values. In that way, you can pass various numbers of actual par

Question: (a) The objective of query optimization is to choose the most efficient strategy for implementing a given relational query, thereby improving the system performance. On

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Parameter and Keyword Description: select_item: This select_item is a value returned by the SELECT statement, and then assigned to the equivalent variable or field in the

Parameter and Keyword Description: SQL: This SQL is the name of the implicit SQL cursor. %FOUND: This attribute results TRUE if an INSERT, DELETE, or UPDATE state

Using LOCK TABLE You use the LOCK TABLE statement to lock the whole database tables in the specified lock mode so that you can share or deny the access to them. For illustrati

IN OUT Mode An IN OUT parameter passes initial values to the subprogram being called and return efficient values to the caller. Within the subprogram, an IN OUT parameter acts