Pl/sql expressions , PL-SQL Programming

Pl/SQL Expressions

The Expressions are constructed by using the operands and operators. An operand is a constant, literal, variable, or function call which contributes a value to an expression. An illustration of a simple arithmetic expression is shown below:

-X / 2 + 3

The Unary operators like the negation operator (-) operate on one operand; the binary operators like the division operator (/) operate on two operands. The PL/SQL has no ternary operators.

The simplest expressions consist of a single variable that yields a value directly. The PL/SQL evaluates (finds the present value of) an expression by combining the values of the operands in ways specify by the operators. This forever yields a single value and datatype. The PL/SQL determines the datatype by examining the expression and the context in which it appear.

Posted Date: 10/3/2012 5:08:56 AM | Location : United States







Related Discussions:- Pl/sql expressions , Assignment Help, Ask Question on Pl/sql expressions , Get Answer, Expert's Help, Pl/sql expressions Discussions

Write discussion on Pl/sql expressions
Your posts are moderated
Related Questions
Other monadic - SQL In 2VL there are just 4 (2 2 ) monadic operators, of which negation is really the only "useful" one. When a third truth value is introduced we have 27 (3 3

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

BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

Why Use Cursor Variables ? Primarily, you use the cursor variables to pass the query result sets between the PL/SQL stored subprograms and different clients. Neither PL/SQL nor

Updating Tables in SQL The topic of updating by describing the assignment operator, ":=" in Tutorial D. SQL uses a different syntax for assignment, using the key word SET and

Parameter and Keyword Description: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

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

DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

Fetching from a Cursor Variable The FETCH statement retrieve rows one at a time from the product set of a multi-row query. The syntax for the same is as shown: FETCH {curso

SELECT INTO Statement   The SELECT INTO statement retrieve data from one or more database tables, and then assigns the selected values to the variables or fields. Syntax: