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

Exit statement - syntax, EXIT Statement   You can use the EXIT stateme... EXIT Statement   You can use the EXIT statement to exit a loop. The EXIT statement has 2 forms: the conditional EXIT WHEN and the unconditional EXIT. With the either form, you

Difference between 9i & 10g, Difference between 9i & 10G When Oracle r... Difference between 9i & 10G When Oracle releases any new databases then it are having some discrepancy with them. But 10G is having much difference than oracle 9i has. Oracle

Example of not exists operator - sql, Example of NOT EXISTS Operator - SQL ... Example of NOT EXISTS Operator - SQL Example is a translation into SQL of the corresponding example, which is included there merely to show that for any scalar comparison the

Implicit cursor attributes, Implicit Cursor Attributes The Implicit cur... Implicit Cursor Attributes The Implicit cursor attributes returns the information about the execution of an INSERT, DELETE, UPDATE, or SELECT INTO statement. The cursor attribu

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

Semijoin and composition - sql, Semijoin and Composition - SQL For sem... Semijoin and Composition - SQL For semijoin, the dyadic relational operator MATCHING, defined thus: r1 MATCHING r2, where r1 and r2 are relations such that r1 JOIN r2 is de

What is a record, What Is a Record  ? A record is a group of related... 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

Using %rowtype-declarations in sql, Using %ROWTYPE The %ROWTYPE attribut... Using %ROWTYPE The %ROWTYPE attribute gives a record type which represents a row in a table (or view). The record can store the whole row of data selected from the table or fetc

Introduction to SQl and DQL, which operation is used if we are interested i... which operation is used if we are interested in only certain columns of a table?

Best practices/Data Warhousing, What are 3 good practices of modeling and/o... What are 3 good practices of modeling and/or implementing data warehouses?