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
Parameter & Keyword Description: function_name: The user-defined function is identifying by that keyword. parameter_name: This identifies the formal parameter that

1. Create a procedure called TAX_COST_SP to accomplish the tax calculation task. Keep in mind that the state and subtotal values are inputs into the procedure and the procedure is

which operation is used if we are interested in only certain columns of a table?

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Parameter and Keyword Description: package_name: This construct identifies the package. AUTHID Clause: This determine whether all the packaged subprograms impleme

SELECT a.child_fname,a.child_lname,concat(b.parent_title,b.parent_fname), b.parent_lname,b.parent_tphone FROM child a,parent b WHERE a.parent_id=b.parent_id ORDER BY a.child_fnam

SQL Database: So, an SQL database is one whose symbols are organized into a collection of tables. Now, shows an SQL table as the current value of an SQL variable, ENROLMENT, b

set serveroutput on declare a number(5); b number(5); c number(5); begin a:=&a; b:=&b; c:=a/b; dbms_output.put_line(c); exception when zero_d

Case Sensitivity Similar to all the identifiers, the variables, the names of constants, and parameters are not case sensitive. For illustration, PL/SQL considers the following n

Example of GROUP BY and COLLECT Operator Example: Using GROUP BY and COLLECT to obtain C_ER2 SELECT CourseId, CAST ( COLLECT (ROW (StudentId, Mark)) AS ROW (Studen