Expressions - syntax, PL-SQL Programming

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:

1015_expression syntax.png

986_expression syntax1.png

643_expression syntax2.png

995_expression syntax3.png

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







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
Related Questions
Advantages of Exceptions Using the exceptions for the error handling has many benefits. Without an exception handling, every time you issue a command, you should ensure for th

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem

Parameter and Keyword Description:   table_reference: This identifies a table or view which should be available when you execute the INSERT statement, and for that you sho

PL SQL Code Review HEADER ELEMENTS File Name Clear, meaningful and descriptive about main objective of the file. Multiple words are joined using underscores which adh

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

How Exceptions Are Raised By the run-time system, the internal exceptions are raised implicitly as are user-defined exceptions that you have related with an Oracle error number

Forward Declarations The PL/SQL needs that you declare an identifier before using it. And hence, you should declare a subprogram before calling it. For illustration, the decla

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

Cursor Variables:   To execute the multi-row query, the Oracle opens an unnamed work region that stores the processing information. You can use an explicit cursor that names

The Package Specification The package specifications contain the public declarations. The scopes of these declarations are local to your database representation and global to t