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
Fetching with a Cursor The FETCH statements retrieve the rows in the result set one at a time. After each and every fetch, the cursor advance to the next row in the result set

Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Using a join on 3 tables, select 5 columns and 10 rows from the 3 tables without the use of a Cartesian product Query: SELECT E.LAST_NAME, E.FIRST_NAME, S.BUILDING, S.BRAN

Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r

SQL Functions The PL/SQL uses all the SQL functions involving the following aggregate functions that summarize the whole columns of the Oracle data: GROUPING, AVG, COUNT, STDDE

Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Example of EXCEPT Operator - SQL Example, like its counterpart in the theory book, illustrates the convenience of allowing any table expression to be the source for an INSERT

Effects of NULL in Table Literal When a VALUES expression appears as the source value for an SQL INSERT statement, the key word NULL can appear as a field value, such that for

Data Types in SQL - Character CHARACTER or, synonymously, CHAR, for character strings. When this type is to be the declared type of something (e.g., a column), the permissible

Components of an Object Type: An object type encapsulates the operations and data. Therefore, you can declare the methods and attributes in an object type specification, but no