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
Question: (a) In the context of database security explain how the following database features help to enforce security in the database system: (i) Authorisation (ii) Access

LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ

Using LOCK TABLE You use the LOCK TABLE statement to lock the whole database tables in the specified lock mode so that you can share or deny the access to them. For illustrati

%FOUND Subsequent to a cursor or cursor variable is opened but before the first fetch, the %FOUND yields NULL. Afterward, it yields TRUE when the last fetch returned a row, or

Exception handling In the PL/SQL, a warning or error condition is known as an exception. The Exceptions can be internally defined (by the run-time system) or user defined. The

Functions The function is a subprogram which can take parameters and be invoked. Normally, you can use a function to calculate a value. The function has 2 sections: the specifi

Stored Subprograms Normally, tools (like Oracle Forms) which incorporate the PL/SQL engine can store subprograms locally for later, strictly local execution. Though, to become

UNION and OR - SQL SQL supports UNION explicitly but differently from the way it supports JOIN explicitly. As we have seen, JOIN is used exclusively within the FROM clause, su

Iteration Schemes The bounds of a loop range can be variables, literals, variables, or expressions but must compute to integers. Below are some of the examples. As you can see t

I have a Pascal Source file that needs to be compiled into a Service. In addition, there are various functions (Pascal Procedures I guess) that need to be created to Read and Write