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

Built-in functions-comparison operators, Built-In Functions The PL/SQL p... Built-In Functions The PL/SQL provides a lot of powerful functions to help you to manipulate the data. These built-in functions fall into the categories as shown below: error r

Example of cast operator - sql, Example of Cast Operator So long as C... Example of Cast Operator So long as CAST is used as shown, we could obtain the total marks for each exam in similar fashion, using SUM (Mark) AS TotalMarks. However, this giv

Create Tables, Hi there, I have the final part of a submission to do, it ... Hi there, I have the final part of a submission to do, it is a demonstration that takes place tomorrow. I do not have to use previous information, but i have resources that sho

Tautologies, Tautologies: Above given table allows us to read the trut... Tautologies: Above given table allows us to read the truth of the connectives in the next manner. Just expect we are looking at row three. It means this says that, if there P

Declaring subprograms, Declaring Subprograms   You can declare subprog... Declaring Subprograms   You can declare subprograms in any PL/SQL subprogram, block, or package. But, you should declare subprograms at the end of the declarative part after a

Example of coalesce operator - sql, Example of COALESCE operator Examp... 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 aggregation on nested tables - sql, Using Aggregation on Nested Table... Using Aggregation on Nested Tables Example is the most direct translation of its counterpart in the theory book that can be obtained in SQL but it is so over-elaborate that no

Product-specific packages in pl/sql, Product-specific Packages The Ora... Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illu

Anatomy of a table, Anatomy of a Table: Figure shows the terminology u... Anatomy of a Table: Figure shows the terminology used in SQL to refer to parts of the structure of a table. As you can see, SQL has no official terms for its counterpa

Parameter & keyword description - functions, Parameter & Keyword Descriptio... Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that