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
#quesWrite a cursor to open an employee database and fetch the employee record whose age is greater than 45.tion..

IN Operator The operator IN tests the set membership. This means "equal to any member of." The set may have nulls, but they are ignored. For illustration, the statement below do

Example of Alternative formulation as a table constraint Example: Alternative formulation as a table constraint ALTER TABLE EXAM_MARK ADD CONSTRAINT Must_be_enrolled_to_

Example of NOT EXISTS in SQL Example: Use of NOT EXISTS CREATE ASSERTION Must_be_enrolled_to_take_exam_alternative1 CHECK ( NOT EXISTS (SELECT StudentId, CourseId

Selecting Objects: Suppose that you have run the SQL*Plus script below that creates object type Person and object table persons, and that you have settled the table: CREATE

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

Write a cursor to open an employee database and fetch the employee record whose age is greater than 45

Effects of NULL for union - SQL The treatment of NULL in invocations of EXCEPT is as for UNION. This is different from its treatment in those of NOT IN and quantified compari

COMMIT Statement The COMMIT statement explicitly makes everlasting changes to the database during the present transaction. The Changes made to the database are not considered e