Semidifference via not in and a subquery , PL-SQL Programming

Semidifference via NOT IN and a subquery

SELECT StudentId

FROM IS_CALLED

WHERE Name = 'Devinder'

AND StudentId NOT IN (SELECT StudentId

FROM IS_ENROLLED_ON

WHERE CourseId = 'C1')

In above Example < > ALL replaces NOT IN and in the absence of NULL has the same effect. It reads, somewhat ambiguously, as "not equal to all". In fact the expression yields TRUE if and only if the condition comparing StudentId values is TRUE for every row in the result of the subquery.

Posted Date: 1/18/2013 5:43:20 AM | Location : United States







Related Discussions:- Semidifference via not in and a subquery , Assignment Help, Ask Question on Semidifference via not in and a subquery , Get Answer, Expert's Help, Semidifference via not in and a subquery Discussions

Write discussion on Semidifference via not in and a subquery
Your posts are moderated
Related Questions
What Is a Package? The package is a schema object that group logically related PL/SQL items, types, and subprograms. The Packages usually have 2 parts, a specification & a bo

Packages The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the bod

User-Defined Exceptions The PL/SQL defines the exceptions of your own. Dissimilar to the predefined exceptions, the user-defined exceptions should be declared and should be rai

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

The SQL ‘CREATE TABLE' scripts for all the tables you have implemented. Note that your tables must correspond exactly to the ERD you have provided in 1. above, or you will lose ma

Implicit Rollbacks Before execute the INSERT, UPDATE, or DELETE statement, the Oracle marks an implicit savepoint . When the statement fails, the Oracle rolls back to the save

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

Using raise_application_error The Package DBMS_STANDARD that is supplied with Oracle gives language facilities that help your application to interact with Oracle. For illustra

Using Operator DEREF: You cannot navigate through refs within the PL/SQL procedural statements. Rather than, you should use the operator DEREF in the SQL statement. The DEREF

Data Types and Representations This explains the concept possible representation, abbreviated possrep, and explains how these can be used in conjunction with constraints to de