SQLs counterpart of the key words:

The text from the opening parenthesis to the end of the fourth line specifies the declared type of the table, meaning that every table ever assigned to ENROLMENT must be a table of that type.The declared type of ENROLMENT is a  table type, indicated by the key word TABLE and a comma-separated list (commalist, for short) of column definitions. A column definition consists of a column name followed by a type specification. Thus, each column of the table also has a declared type. Two or more columns can have the same type but not the same name. The type names SID and CID (for student ids and course ids) refer either to user-defined types or to user-defined domains. User-defined types and domains have to be defined by some user of the DBMS before they can be referred to. The type name VARCHAR(30) (character strings of length 30 or less), by contrast, is a predefined type: it is provided by the DBMS itself, is available to all users, and cannot be destroyed.

Posted Date: 1/11/2013 5:21:34 AM | Location : United States

Ask an Expert

Related Discussions:- Sqls counterpart of the key words, Assignment Help, Ask Question on Sqls counterpart of the key words, Get Answer, Expert's Help, Sqls counterpart of the key words Discussions

Write discussion on Sqls counterpart of the key words
Your posts are moderated

Write your message here..

Related Questions

Providing results of queries, Providing Results of Queries Expressing ... Providing Results of Queries Expressing queries in SQL is the (big) subject. Here I present just a simple example to give you the flavour of things to come in those chapters.

Effects of null, Effects of NULL The numeric variable X, perhaps of ty... Effects of NULL The numeric variable X, perhaps of type INTEGER, might be assigned NULL. In that case the result of evaluating X + 1 is NULL, and so SET Y = X + 1 assigns NULL

Relational algebra, Define basic operators of relational algebra with an ex... Define basic operators of relational algebra with an example each

Package utl file in pl/sql, UTL_FILE: The Package UTL_FILE permits you... UTL_FILE: The Package UTL_FILE permits your PL/SQL programs to read & write operating system (OS) text files. It gives a restricted version of the standard OS stream file I/O,

Read-only operator (+) - sql, Read-Only Operator (+) - SQL The term r... Read-Only Operator (+) - SQL The term read-only operator to the mathematical term function. Here I just need to add that the SQL standard reserves the term function for read-

Restriction and and - sql, Restriction and AND - SQL Restriction is av... Restriction and AND - SQL Restriction is available via the WHERE operator, and so it is in SQL. However, by Example showing how a certain simple restriction can be expressed u

Projection in sql - correct version, Projection in SQL - correct version ... Projection in SQL - correct version Student StudentId is enrolled on some course. SELECT DISTINCT StudentId FROM IS_ENROLLED_ON In more complicated examples it is someti

Loop statements, LOOP Statements The LOOP statements execute a series o... LOOP Statements The LOOP statements execute a series of statements at multiple times. The loops enclose the series of statements that is to be repeated. The PL/SQL provides typ

Predicate - sql, Predicate - SQL Consider the declarative sentence-a p... 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 th

Comparison operators- pl/sql, Comparison Operators The Comparison operat... Comparison Operators The Comparison operators can compare one expression to another. The outcome is always true, false, or null. Usually, you use a comparison operators in condi