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
Redeclaring Predefined Exceptions Keep in mind that, the PL/SQL declares predefined exceptions globally in the package STANDARD; Therefore you need not declare them yourself.

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

Need Windows and Linux system Administrator We are seeking a part time system administrator to take care of our servers. Your things to do would add, but not limited to: -

%ROWCOUNT The %ROWCOUNT yields the number of rows affected by the INSERT, UPDATE, or DELETE statement, or returned by a SELECT INTO statement. The %ROWCOUNT yields zero when a

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

Some Varray Examples In SQL Plus, assume that you define an object type Project, as described below: SQL> CREATE TYPE Project AS OBJECT ( 2 project_no NUMBER(2), 3 title VARCHA

Logical Connectives - SQL SQL's extended truth tables in which the symbol, for unknown, appears along with the usual T and F. Negation (NOT, ¬) Conjunction (

Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

I need a query for PL/SQL, selecting names with cursor, goes down the list, assigns usernames (initials001) based on initials in the name. If two names have same initials the user

Overview of control structures According to the structure theorem, any computer program can be written by using the basic control structures as shown in figure below. They can b