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
How do I display usernames for students from a student table, assigning each student a username initials001 (initials is the actual student initials), and if the students initials

Sequential Control Dissimilar to the IF and LOOP statements, the GOTO and NULL statements are not important to the PL/SQL programming. The configuration of PL/SQL is such that th

Using FOR UPDATE If you declare a cursor which will be referenced in the CURRENT OF clause of an UPDATE or DELETE statement, you should use the FOR UPDATE clause to obtain an

ROWNUM The ROWNUM returns a number representing the order in which a row was selected from the table. The first row selected has a ROWNUM of 1; the second row has a ROWNUM of

What Is a Record  ? A record is a group of related data items that stored in the fields, each with its own name and datatype. Assume that you have different data about an em

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

Great Plains (Microsoft Dynamics) Purchases Report Project Description: I want to build a purchases report that matches the General Ledger. presently, when I join the PM20

LEVEL You use the LEVEL with the SELECT CONNECT BY statement to categorize rows from a database table into a tree structure. The LEVEL returns the level number of a node in a

Using Savepoints The scope of the savepoint is a transaction in which it is defined. The Savepoints defined in the major transaction are not related to the savepoints defined

Deleting Objects You can use the DELETE statement to eradicate objects from an object table. To eradicate objects selectively, you use the WHERE clause, as shown below: BEG