Sqls counterpart of the key words, PL-SQL Programming

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







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
Related Questions
Parameter and Keyword Description: procedure_name The user-defined procedure is declared by this construct. parameter_name: This identifies the formal parameter t

Interesting properties of CROSS JOIN - SQL Compare these with the "interesting properties of JOIN", CROSS JOIN is associative but not commutative. Unlike JOIN and NATURAL JOI

Parameter and Keyword Description: EXIT: An unconditional EXIT statement (i.e., one without a WHEN clause) exits the present loop instantly. The Execution resumes with th

Explicit Cursor Attributes The cursor variable or each cursor has four attributes: %FOUND, %ISOPEN, %ROWCOUNT, and %NOTFOUND. When appended to the cursor or cursor variable, th

Collection Methods:   The collection method is a built-in function or procedure which operates on the collections and is called using the dot notation. The methods like the C

DBMS: The answer to this question is of course given in of the theory book. This book is concerned with SQL DBMSs and SQL databases in particular. Soon we will be looking a

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

1. a. Write a trigger that fires when a part's price is updated. The trigger will write a record into a table called PriceUpdates. The record should contain the information of

Attributes: Just similar to variable, an attribute is declared with a name and datatype. The name should be exclusive within the object type. The datatype can be any Oracle ty

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