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
Ending Transactions A good quality programming practice is to commit or roll back every transaction explicitly. Whether you rollback or issue the commit in your PL/SQL program

Using the FORALL Statement The keyword FORALL instruct the PL/SQL engine to bulk-bind input collections before sending them all to the SQL engine. Though the FORALL statement

Using Invoker Rights: By default, the stored procedure executes with the privileges of its definer, not its invoker. These procedures are bound to the schema in which they inh

THEO R Y OF ETERNITY OF LIFE (PRAYER - 1880) - The theory of eternity of life, also called the steady-state theory , states that life has ever been in existence as at presen

ALTER TABLE bb_basketitem ADD CONSTRAINT bitems_qty_ck CHECK (quantity BEGIN INSERT INTO bb_basketitem VALUES (88,8,10.8,21,16,2,3); END; Brewbean’s wants to add a check

Use of Table Comparisons - SQL Table comparisons where it is noted that although table expressions cannot be compared, we have TABLE (t) to convert a table expression t into

Use the PLS_INTEGER Datatype When you require to declare an integer variable, use the datatype PLS_INTEGER that is the most efficient numeric type. That is as the PLS_INTEGER

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

Defining Autonomous Transactions To define an autonomous transaction, you use the pragma (compiler directive) AUTONOMOUS_TRANSACTION. The pragma instructs the PL/SQL compiler

Creating a Table Syantax: CREATE TABLE ENROLMENT (StudentId SID, Name   VARCHAR (30) NOT NULL, CourseId CID, PRIMARY KEY (StudentId, CourseId)) ; Explan