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
Main features of PL/SQL A good way to get familiar with PL/SQL is to look at a sample program. The below program processes an order for tennis rackets. At first, it declares a

Change Sql file into CSV for product registration on Magento Project Description: I have a set of files that are in Sql format and could like for a developer to help me with

SQL Cursor   The Oracle implicitly opens a cursor to process each SQL statement not related with an explicit cursor. The PL/SQL refers to the most current implicit cursor as t

What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

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

Implicit Cursors The Oracle implicitly opens a cursor to process each SQL statement not related with an explicitly declared cursor. The PL/SQL lets you refer to the most recen

Boolean Values Only the values TRUE, FALSE, & NULL can be assigned to a Boolean variable. For illustration, given the declaration DECLARE done BOOLEAN; the following statements

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

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

Project Description: I have two types of data sources. One that is a list in SharePoint and another that is an access desktop database. The access desktop database is fairly com