Fundementals of PL/SQL
You are currently browsing the articles from Techno Oracle matching the category Fundementals of PL/SQL.
NLS_LOWER function returns a string with eache letter in lower case corresponding to the input string given. <strong>Syntax for uisng NLS_LOWER Function</strong> NLS_LOWER( ‘string’,’nlsparam’); Both string and ‘nlsparam’ can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. The output returned is of VARCHAR2 datatype if string is a character datatype and a LOB if string [...]
Written by admin on June 20th, 2010 with no comments.
Read more articles on Fundementals of PL/SQL.
INSTRC function finds Location of a string, within another string, in Unicode complete characters.INSTRC calculates lengths using Unicode complete characters. Synatx For using INSTRC function INSTRC(string_1, string_2 [, starting_position [, nth_appearance ] ] ) string_1 is the string to search. string_2 is the substring to search for in string_1. starting_position is the position in string_1 [...]
Written by admin on June 19th, 2010 with no comments.
Read more articles on Fundementals of PL/SQL.
ASCII function returns the NUMBER corresponding to the first Character of expression. Syntax for using ASCII Function ASCII(character); some examples follow SQL>SELECT ASCII(a) from DUAL; this query would return 97 SQL>SELECT ASCII(a) from DUAL; this query would would return 65
Written by admin on June 19th, 2010 with 3 comments.
Read more articles on Fundementals of PL/SQL.
The comments are a piece of code that exist to improve readability. The comments are written in the program, either as a single line or multiple lines of documentation. A single line or multiline comments are separated from the rest of the program through delimiters, so the PL / SQL engine will ignore them.Comments are [...]
Written by admin on June 18th, 2010 with no comments.
Read more articles on Fundementals of PL/SQL.
Lexical units are the characters that make up PL/SQL Characters are grouped together into four lexical units: identifiers,literals, delimiters, and comments. We discuss the main components of PL/SQL Lexical Units in the following sections. click on the following links to read more about Lexical units Identifiers Literals Delimiters Comments
Written by admin on June 18th, 2010 with no comments.
Read more articles on Fundementals of PL/SQL.
PL/SQL program stores values in variables and constants.You can declare variables and constants in the declarative part of any PL/SQL block, subprogram, or package. Declarations allocate storage space for a value, specify its datatype, and name the storage location so that you can reference it. As the program executes, the values of variables can change, [...]
Written by admin on June 18th, 2010 with no comments.
Read more articles on Fundementals of PL/SQL.
Delimiters are symbols used by Oracle for a special purpose.In other words a delimiter is a simple or compound symbol that has a special meaning to PL/SQL. They act as separators, database link indicators, mathematical operators, and concatenation operators. The following table lists the delimiters available. Delimiter Description +, –, *, /, ** Mathematical operators [...]
Written by admin on June 18th, 2010 with no comments.
Read more articles on Fundementals of PL/SQL.
A PL/SQL program consists of a sequence of statements, each PL/SQL statments are written using a specific set of characters.These characters are shown below Type Characters Letters a-z,A-Z, Digits 0..9 Symbols ~ ! @ # $ % & amp; * ( ) _ – + = | [ ] { } : ; ” ‘ [...]
Written by admin on June 18th, 2010 with 5 comments.
Read more articles on Fundementals of PL/SQL.