Expressions 

An expression is a randomly complex combination of the constants, variables, literals, operators, & function calls. The simplest expression is the single variable. The PL/SQL compilers determine the datatype of an expression from the types of the constants, variables, literals, and operators which comprise the expression. Every time the expression is computed, a single value of that type results.

Syntax:

Posted Date: 10/8/2012 6:23:15 AM | Location : United States

Ask an Expert

Related Discussions:- Expressions - syntax, Assignment Help, Ask Question on Expressions - syntax, Get Answer, Expert's Help, Expressions - syntax Discussions

Write discussion on Expressions - syntax
Your posts are moderated

Write your message here..

Related Questions

Assignment of DBMS in SQL server, i have an assignment of DBMS subject, thi... i have an assignment of DBMS subject, this assignment is based on SQL server and power BI

Accessing attributes in pl sql, Accessing Attributes: You can refer to ... Accessing Attributes: You can refer to an attribute only by its name not by its position in the object type. To access or modify the value of an attribute, you can use the dot

In operator-comparison operators, IN Operator The operator IN tests the ... 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

Expression in assignment statement - pl sql, Expression: This is a ran... Expression: This is a randomly complex combination of constants, variables, literals, operators, & function calls. The simplest expression consists of a single variable. If th

Cursors, What is Cursors how to use it in Real time application ? What is Cursors how to use it in Real time application ?

Data types in sql - interval, Data Types in SQL - Interval, Boolean I... Data Types in SQL - Interval, Boolean INTERVAL for values denoting, not intervals (!) but durations in time, such as 5 years, 3 days, 2 minutes, and so on. BOOLEAN, con

Logical connectives - sql, Logical Connectives - SQL SQL's extended t... Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (

Explicit cursors, Explicit Cursors The set of rows returned by the que... Explicit Cursors The set of rows returned by the query can include zero, one, or multiple rows, depending on how many rows meet your search criteria. Whenever a query returns

Out mode - parameter modes, OUT Mode An OUT parameter returns values t... OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

Long and long raw in pl/sql, LONG and LONG RAW You use the LONG datatyp... LONG and LONG RAW You use the LONG datatype to store the variable-length character strings. The LONG datatype is such as the VARCHAR2 datatype, except that the maximum length o