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
Referencing Records Unlike the elements in a collection, that are accessed using subscripts, the fields in a record are accessed by name. To reference an individual field, you

Data Types in SQL - Integer INTEGER or  synonymously INT, for integers within a certain range. SQL additionally has types SMALLINT and BIGINT for certain ranges of integers. T

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_divide then d

Variable Declaration - SQL SQL's support for variables is very similar to Tutorial D's, except that the syntax for creating persistent  variables-base tables-is quite differen

Manipulating Local Collections Within PL/SQL, to manipulate the local collection, by using the  TABLE and CAST operators . The operands of CAST are a collection declared locally

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

Data Types in SQL SQL's concept does not differ significantly from that defined in the theory book, apart from that business concerning NULL. However, the theory book equates

Disjunction (OR, ∨) Again we have nine rows instead of just four and again, when unknown is not involved, the rows are as for 2VL. Also, when anything is paired with true, t

Assignment of Variable - Updating a Variable Syntax: SET SN = SID ('S2'); This can obviously be read as "set the variable SN to be equal in value to SID ( 'S2' )".

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th