Restriction in sql, PL-SQL Programming

Restriction in SQL

Syntax:

SELECT DISTINCT StudentId

FROM IS_CALLED

WHERE Name = 'Boris'

The WHERE clause operates on the result of the FROM clause in analogous fashion to the way it operates on an arbitrary relation expression. Name = NAME ('Boris') is an open expression. The key word DISTINCT here is redundant, as it happens, because StudentId is a declared key for IS_CALLED.

Posted Date: 1/18/2013 5:24:32 AM | Location : United States







Related Discussions:- Restriction in sql, Assignment Help, Ask Question on Restriction in sql, Get Answer, Expert's Help, Restriction in sql Discussions

Write discussion on Restriction in sql
Your posts are moderated
Related Questions
Consider the following set of database tables (same tables from Assignment 6-1). Please take note of foreign keys (most of them carry the same names as the corresponding primary ke

Varrays versus Nested Tables The Nested tables are differing from varrays in the following ways: 1)  Varrays have a maximum size, while nested tables do not. 2)  Varrays are

Using NOT NULL Besides assigning an initial value, the declarations can impose the NOT NULL constraint, as the example below shows: acct_id INTEGER(4) NOT NULL := 9999; You ca

Using EXCEPTION_INIT To handle unnamed internal exceptions, you should use the OTHERS handler or the pragma EXCEPTION_INIT. The pragma is a compiler directive that can be th

Declaring Records Whenever you define a RECORD type, you may declare records of that type, as the illustration shows: DECLARE TYPE StockItem IS RECORD ( item_no INTEG

Cursors   To execute the multi-row query, the Oracle opens an unnamed work region which stores the processing information. The cursor names the work region, access the informa

Using SAVEPOINT The SAVEPOINT names and marks the present point in the processing of a transaction. Used with the ROLLBACK TO statement, the savepoints undo parts of a transac

Predicate - SQL Consider the declarative sentence-a proposition-that is used to introduce this topic:  "Student S1, named Anne, is enrolled on course C1." Recall that th

Block Structure The PL/SQL is a block-structured language. That is, the fundamental units (procedures, anonymous blocks, and functions) that make up a PL/SQL program are logi

Define basic operators of relational algebra with an example each