In operator-comparison operators, PL-SQL Programming

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 does not delete the rows in which the ename column is null:

DELETE FROM emp WHERE ename IN (NULL, ’KING’, ’FORD’);

Moreover, the expressions of the form

value NOT IN set

yield FALSE when  the set contains a null. For illustration, instead of deleting the rows in which the ename column is not null and not ’KING’, the statement below deletes no rows:


DELETE FROM emp WHERE ename NOT IN (NULL, ’KING’);


Concatenation Operator

The Double vertical bars (||) serve as the concatenation operator that appends one string to another. For illustration, the expression

’suit’ || ’case’

returns the value as shown below:

’suitcase’

If both the operands have datatype CHAR, the concatenation operator returns a CHAR value. Or else, it returns a VARCHAR2 value.

Posted Date: 10/3/2012 5:33:44 AM | Location : United States







Related Discussions:- In operator-comparison operators, Assignment Help, Ask Question on In operator-comparison operators, Get Answer, Expert's Help, In operator-comparison operators Discussions

Write discussion on In operator-comparison operators
Your posts are moderated
Related Questions
DBMS_PIPE: The Package DBMS_PIPE allows various sessions to communicate over the named pipes. (A pipe is a region of memory used by one of the process to pass information to

Example of Tables within a Table - SQL Example: Obtaining C_ER from COURSE and EXAM_MARK SELECT CourseId, CAST (TABLE (SELECT DISTINCT StudentId, Mark FROM EXAM_MARK AS EM

OUT Mode An OUT parameter returns values to the caller of a subprogram. Within the subprogram, an OUT parameter act like a variable. That means that you can use an OUT formal

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

BETWEEN and NOT BETWEEN Operator in SQL Example: Restricting exam marks to between 0 and 100 CREATE ASSERTION Marks_between_0_and_100 CHECK (NOT EXISTS (SELECT * FROM

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Transaction Control The Oracle is transaction oriented; that is, Oracle uses the transactions to make sure the data integrity. The transaction is a sequence of SQL data manip

Keyword and Parameter Description: label_name: This is an undeclared identifier which labels an executable statement or the PL/SQL block. You can use a GOTO statement to

Advantages of Packages The benefits of the Packages are as shown below: Modularity The Packages encapsulate logically associated items, types, and subprograms in the

Exception handling In the PL/SQL, a warning or error condition is known as an exception. The Exceptions can be internally defined (by the run-time system) or user defined. The