Read-only operator (+) - sql, PL-SQL Programming

Read-Only Operator (+) - SQL

The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-only operators that are invoked using prefix notation: an operator name followed by a commalist of argument expressions enclosed in parentheses, as in for example SQRT(2), denoting the positive square root of 2, or SUBSTRING(X FROM 1 FOR 2) denoting the first two characters of the character string denoted by X. The term operator is used for those invoked using infix notation, like + for example.

Posted Date: 1/18/2013 1:36:21 AM | Location : United States







Related Discussions:- Read-only operator (+) - sql, Assignment Help, Ask Question on Read-only operator (+) - sql, Get Answer, Expert's Help, Read-only operator (+) - sql Discussions

Write discussion on Read-only operator (+) - sql
Your posts are moderated
Related Questions
Advantages of Invoker Rights The Invoker-rights routines centralize the data retrieval. They are particularly helpful in applications which store data in various schemas. In su

Naming Conventions The similar naming conventions apply to all PL/SQL program items and units including the variables, cursors, constants, cursor variables, procedures, exception

Initializing and Referencing Collections Until you initialize a collection, a nested table or varray is automatically null (i.e. the collection itself is null, not its elements)

WHILE-LOOP The WHILE-LOOP statement relates a condition with the series of statements enclosed by the keywords LOOP and END LOOP, as shown: WHILE condition LOOP sequence_of_sta

Ensuring Backward Compatibility   The PL/SQL Version 2 permits some abnormal behavior which Version 8 disallows. Particularly, Version 2 permits you to (i) Make the forw

Bitmap Join Indexes - This feature will increase the performance and detains the size and format of your databases in data Character Semantics and Globalization -This featur

Keys in SQL SQL support for keys in the following respects: SQL does not require at least one key for every base table. If no key is explicitly declared, then KEY {ALL B

Transaction context As the figure shows, the major transaction shares its context with the nested transactions, but not with the autonomous transactions. Similarly, If one aut

IS NULL Operator The IS NULL operator returns the Boolean value TRUE whenever its operand is null or FALSE if it is not null. The comparisons including the nulls always yield NU

Keyword and Parameter Description select_statement: This is a query which returns a result set of the rows. Its syntax is such that of select_ into_statement without the IN