Predicate - sql, PL-SQL Programming

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 the terms S1, Anne, and C1 are designators, each referring unambiguously to a particular thing. The chapter later explains how a tuple can provide values-attribute values-to be interpreted as designators to be substituted for the corresponding parameters of a predicate. Thus, this sentence might be represented by the tuple denoted in Tutorial D by TUPLE{StudentId SID('S1'), Name NAME('Anne'), CourseId CID('C1') }.

As SQL allows NULL to appear wherever a value can appear, we have to entertain the notion that the row denoted in SQL by ( SID('C1'), NULL, CID('C1') ) might represent some sentence. (Aside: SQL does not use attribute names to connect values to their corresponding parameters.

Instead, the correspondence is determined by position and I have assumed that the parameters are to be considered in the order StudentId, Name, CourseId. End of aside.) Now, could that sentence be "Student S1, named NULL, is enrolled on course C1"? Well, no, because NULL is not a name and really doesn't designate anything. The row might instead represent the sentence "Student S1, whose name is not known, is enrolled on course C1". But that sentence contains nothing that can be regarded as a designator substituted for the parameter Name.

Posted Date: 1/18/2013 3:06:00 AM | Location : United States







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

Write discussion on Predicate - sql
Your posts are moderated
Related Questions
At times, customers make mistakes in submitting their orders and call to cancel the order. Brewbean's wants to create a trigger that automatically updates the stock level of all pr

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 do

OPEN-FOR Statement The OPEN-FOR statements execute the multi-row query related with a cursor variable. It also allocates the resources used by the Oracle to process the query a

%FOUND Until the SQL data manipulation statement is executed, the %FOUND yields NULL. Afterward, the %FOUND yields TRUE, when an INSERT, UPDATE, or DELETE statement affected o

Transactions in SQL BEGIN TRANSACTION, COMMIT, and ROLLBACK, SQL has the same syntax except for START in place of BEGIN. However, START TRANSACTION is used only for outermost

Declaring and Initializing Objects: An object type is once defined and installed in the schema; you can use it to declare the objects in any PL/SQL, subprogram, block or packa

Pl/sql Conditional Control: IF statements Frequently, it is necessary to take the alternative actions depending on the circumstances. The IF statement execute a series of statem

Synonyms You can create the synonyms to provide location transparency for the remote schema objects like tables, views, sequences, stand-alone subprograms, and packages. Though,

Create the four tables and populate them with the given data. Answer the following queries in SQL. 1. Get all part-color/part-city combinations. Note: Here and subsequently, the

Parameter Modes: You do not require to specify a parameter mode for the input bind arguments (those used, for illustration, in the WHERE clause) as the mode defaults to IN. Th