Scoping

Within the similar scope, all the declared identifiers should be unique. So, even if their datatypes differ, the variables and parameters cannot share the similar name. For illustration, two of the declarations below are illegal:

DECLARE
valid_id BOOLEAN;
valid_id VARCHAR2(5); -- illegal duplicate identifier
FUNCTION bonus (valid_id IN INTEGER) RETURN REAL IS...          -- illegal triplicate identifier

Posted Date: 10/3/2012 4:54:27 AM | Location : United States

Ask an Expert

Related Discussions:- Scoping-naming conventions, Assignment Help, Ask Question on Scoping-naming conventions, Get Answer, Expert's Help, Scoping-naming conventions Discussions

Write discussion on Scoping-naming conventions
Your posts are moderated

Write your message here..

Related Questions

Manipulating local collections - pl/sql, Manipulating Local Collections ... 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

Data types in sql - xml, Data Types in SQL - XML, Array, Row ... Data Types in SQL - XML, Array, Row BINARY LARGE OBJECT for arbitrarily large bit strings. XML for XML documents and fragments. ARRAY types for arrays.

Cause of indeterminacy in sql, Cause of Indeterminacy in SQL One root ... Cause of Indeterminacy in SQL One root cause of indeterminacy in SQL lies in its implementation of comparison for equality. For certain system-defined types it is possible for

Fetch statement - syntax, FETCH Statement The FETCH statement retrieve ... FETCH Statement The FETCH statement retrieve rows of data one at a time from the result set of the multi-row query. The data is stored in fields or variables which correspond t

Iteration schemes- iterative control, Iteration Schemes The bounds of a ... Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

Delete statement - syntax, DELETE Statement The DELETE statement elimin... DELETE Statement The DELETE statement eliminates whole rows of data from the specified table or view. Syntax:

Sql cursor - syntax, SQL Cursor   The Oracle implicitly opens a cursor... SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

Operator precedence-pl/sql expressions , Operator Precedence The operati... Operator Precedence The operations within an expression are completed in a particular order depending on their precedence (priority). The table shows the default order of the op

Group and having query, Using a join on 2 tables, select all columns and 10... Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Using operator deref - manipulating objects in pl sql, Using Operator DEREF... Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF