Assignment source not a literal - variable, PL-SQL Programming

Assignment Source Not a Literal - Variable

Syntax:

SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');

Posted Date: 1/18/2013 2:58:53 AM | Location : United States







Related Discussions:- Assignment source not a literal - variable, Assignment Help, Ask Question on Assignment source not a literal - variable, Get Answer, Expert's Help, Assignment source not a literal - variable Discussions

Write discussion on Assignment source not a literal - variable
Your posts are moderated
Related Questions
Find the account numbers of all customers whose balance is more than 10,000 $

Using the BULK COLLECT Clause The keywords BULK COLLECT specify the SQL engine to bulk-bind output collections before returning them to the PL/SQL engine. You can use these ke

Mutual Recursion The Subprograms are mutually recursive if they directly or indirectly call each other. In the illustration below, the Boolean functions odd & even, that dete

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

DECLARE : This keyword signals the beginning of the declarative section of the PL/SQL block, that contains local declarations. The Items declared locally exist only within the

UPDATE Command- SQL Loosely speaking, UPDATE changes some of the column values of some existing rows of its target table. Thus, although some rows disappear from the target an

Using Cursor Attributes To process the SQL data manipulation statements, the SQL engine must opens an implicit cursor named SQL. This cursor's attributes (%FOUND, %NOTFOUND, %

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

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Oracle 10G new features:- Automatic Database Diagnostic Monitor System Advancements - these methods will provides several methods for extracting reports through the Automatic