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
Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

Primary Key - SQL A PRIMARY KEY specification carries an implicit NOT NULL constraint on each column of the specified key. When more than one key constraint is required, the k

#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

Assignment Statement: The assignment statement sets the present value of the variable, parameter, field, or element. The statement consists of an assignment target followed by

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

Use the RETURNING Clause Frequently, the application requires information about the row affected by a SQL operation, for illustration, to produce a report or take a subsequent

heap sort program in pl/sql

Records Records are the items of the type RECORD. The Records have exclusively named fields that can store the data values of various types. And hence, a record treat associate

Cursor FOR Loops In most cases that need an explicit cursor, you can simplify the coding by using a cursor FOR loop rather of the OPEN, FETCH, and CLOSE statements. A cursor FO