Scoping-naming conventions, PL-SQL Programming

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







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
Related Questions
Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

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

Example of Null operator - NiNo Rule If we wanted to make HIGHER_OF adhere to "NULL in, NULL out"-let's call it the NiNo rule-we would have to write something like what is sho

EXCEPTION_INIT Pragma The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to wri

Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

Find the account numbers of all customers whose balance is more than 10,000 $

At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean’s wants to create a trigger that automatically updates the stock level of all pr

Truth Tables: However in propositional logic - here we are restricted to expressing sentences and where the propositions are true or false - so we can check where a particular

(a) What are decision support systems, and what role do they play in the business environment? (b) Data warehousing is defined as "a subject-oriented, integrated, non-volatile c

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b