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
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

Multiset types - SQL An SQL multiset is what in mathematics is also known as a bag-something like a set except that the same element can appear more than once. The body of an

GOTO Statement The GOTO statement branches to a label unconditionally. The label must be exclusive within its scope and should precede an executable statement or a PL/SQL block.

Avoiding Collection Exceptions   In many cases, if you reference a nonexistent collection element, then PL/SQL raises a predefined exception. Consider the illustration shown b

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

What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

When Are Constraints Checked Under the model constraints are conceptually checked at all statement boundaries (and only at statement boundaries). By default the same is true

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

Calling Constructors: The Calls to a constructor are allowed wherever the function calls are allowed. Similarly to the functions, a constructor is called as a section of an ex

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illus