Case sensitivity-naming conventions, PL-SQL Programming

Case Sensitivity

Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following names to be the similar:

DECLARE
zip_code INTEGER;
Zip_Code INTEGER; -- same as zip_code

Posted Date: 10/3/2012 4:56:25 AM | Location : United States







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

Write discussion on Case sensitivity-naming conventions
Your posts are moderated
Related Questions
Implicit Cursor is declared and used by the oracle environment internally. while the explicit cursor is declared and used by the external user. more over implicitly cursors are no

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

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

Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an

Updating a Variable Assignment of an attribute value in a variable of a structured type Synatx: SET SN.C = 'S2'; As in Example the entire statement is equivalent to a

Defining REF CURSOR Types To make cursor variables, you take 2 steps. At first, you define a REF CURSOR type, and then declare the cursor variables of that type. You can defin

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

Keyword & Parameter Description: boolean_expression: This is an expression which yields the Boolean value that is TRUE, FALSE, & NULL. character_expression: This

SQL Operators The PL/SQL uses all the SQL set, comparison, and row operators in the SQL statements. This part briefly describes some of these operators.  1. Comparison Opera

Defining and Declaring Records To create records, you have to define a RECORD type, and then declare records of that type. You may also define RECORD types in the declarative