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
Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

Updating by replacement Syntax: UPDATE ENROLMENT SET Name = 'Ann' WHERE StudentId = SID ('S1'); Note the use of SET, as already noted in connection with direct a

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

%ROWTYPE: This attribute gives a record type which represents a row in the database table or a row fetched from a formerly declared cursor. The Fields in the record and corresp

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Control Structures The Control structures are the most important PL/SQL extension to the SQL. Not only does PL/SQL let you manipulate Oracle data, it lets you process the data

Write a cursor to open an employee database and fetch the employee record whose age is greater than 45

Using LIMIT For nested tables, that have no maximum size, the LIMIT returns NULL. For varrays, the LIMIT returns the maximum number of elements that a varray can have (that yo

The accuracy of product table data is critical and the Brwebean's. owner wants to have an audit file that contains information regarding all DML activity on the BB_PRODUCT table. T

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax: