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
I need to write one function and one procedure to query a Oracle 10.1 DB using PL SQL. I have the schema and exact queries...along with work Ive started and a template to put the a

Effects of NULL for UNIQUE Specification When a UNIQUE specification u for base table t includes a column c that is not subject to a NOT NULL constraint, the appearance of sev

Query: SELECT * FROM EMPLOYEE1; Select 5 columns and all rows from one table Query: SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_divide then d

Declaring Objects: You can use the object types wherever built-in types like CHAR or NUMBER can be used. In the block below, you can declare object r of type Rational. Then, yo

Due to an increase in overhead costs, the buying price of all items needs to be increased. Management wants to see a report before deciding how much each product will go up. Add to

Advantages of Subprograms The Subprograms give extensibility; that is, tailor the PL/SQL language to suit your requirements. For illustration, if you require a procedure which

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

Expressions   An expression is a randomly complex combination of the constants, variables, literals, operators, & function calls. The simplest expression is the single variabl

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d