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
Example of COALESCE operator Example: Give the total of marks for each exam (simplified solution) SELECT CourseId, COALESCE ((SELECT SUM (Mark) FROM EXAM_MARK AS EM

Using the Collection Methods The collection methods below help to generalize the code and make collections easier to use and also make your applications easier to maintain:

Predefined Exceptions The internal exception is raised implicitly whenever your PL/SQL program exceeds a system-dependent limit or violates an Oracle rule. Each & every Oracle

Synonyms You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages. Though,

Records Records are the items of the type RECORD. The Records have exclusively named fields that can store the data values of various types. And hence, a record treat associate

Object Type: The object type is a user-defined composite datatype which encapsulates a data structure along with the functions and procedures required to manipulate the data

Structure of an Object Type: Similar to package, an object type has 2 parts: the specification and the body. The specification is the interface to your applications; it declar

Multiple Assignment- SQL SQL supports multiple assignment to local variables and also applies multiple assignment semantics in SET clauses of UPDATE statements, but does not

Example of Foreign Key Constraint Example: Alternative formulation for 6.3 as a foreign key constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_take_exam

DBMS_OUTPUT: The Package DBMS_OUTPUT enables you to display output from the PL/SQL subprograms and blocks, that makes it easier to test and debug them. The procedure put_ line