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
Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi

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

Problem: (a) Define the following terms: (i) data mining. (ii) OLAP. (b) Differentiate between snowflake schema and star schema. Support your answer with appropriate

Use Object Types and Collections The Collection types and object types increase your efficiency by allowing for the realistic data modeling. The Complex real-world entities an

Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

what is the use of declare keyword

which operation is used if we are interested in only certain columns of a table?

Raise_application_error -  procedure of package DBMS_STANDARD , allows to issue an user_defined error messages by stored sub-program or database trigger.

What Are Cursor Variables  ? The Cursor variables are like C or Pascal pointers that hold the memory location (address) of some item rather of the item itself. Therefore, decl