Assignment of variable - updating a variable, PL-SQL Programming

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' )".

Posted Date: 1/18/2013 2:57:59 AM | Location : United States







Related Discussions:- Assignment of variable - updating a variable, Assignment Help, Ask Question on Assignment of variable - updating a variable, Get Answer, Expert's Help, Assignment of variable - updating a variable Discussions

Write discussion on Assignment of variable - updating a variable
Your posts are moderated
Related Questions
IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

Write a program to implement the inverted file shown in the slides (Simple Index file, LabelID file and Data file).  Use the Avail_List to point at the deleted Label IDs so that th

If two relations R and S are joined, then the non matching tuples of both R and S are ignored in __________________.

Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (

Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Manipulating Collections Within PL/SQL, the collections add procedural power and flexibility. The biggest benefit is that your program can compute subscripts to process the spec

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

Manipulating Individual Elements Faraway you have manipulated an entire collection. Within the SQL, to manipulate the individual elements of the collection, and then use the ope