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

Role of Abstraction in pl/sql: The abstraction is a high-level description or model of a real-world entity. The Abstractions keep our daily lives convenient. They help us ca

INSERT Command in SQL Loosely speaking, INSERT takes the rows of a given source table and adds them to the specified target table, retaining all the existing rows in the targ

Scope and Visibility The References to an identifier are resolved according to its visibility and scope. The scope of an identifier is that area of a program unit (subprogram, b

Cursor Variables Similar to a cursor, cursor variable points to the current row in the result set of a multi-row query. But, dissimilar a cursor, a cursor variable can be opene

Name Resolution   During the compilation, the PL/SQL compiler relates identifiers like the name of a variable with an address or memory location, actual value, or datatype. Th

Organi c Evolution Evolution is a slow continuous, irreversible and natural process of change to give rise to advance and diverse forms of life i.e. formation of new specie

Existential Quantification - SQL Existential quantification-stating that something is true of at least one object under consideration-can be expressed by OR(r,c), meaning tha

Aggregate Operators SQL Supports all of the aggregate operators mentioned in the theory book and many more besides. The syntax, however, involves an unusual trick that SQL cal

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