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
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

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: cursor_name: This identifies an explicit cursor formerly declared within the present scope. cursor_variable_name: These identif

Using INNER JOIN INNER JOIN is used to retrieve the data from all tables listed based on a condition of equality listed after keyword ON. If the condition is not meet, rows ar

IF Statement The IF statement executes a series of statement conditionally. Whether the series is executed or not depends on the value of the Boolean expression. Syntax:

Packages The package is a schema object which groups logically associated to the PL/SQL items, types, and subprograms. The Packages have 2 sections: the specification & the bod

EXCEPTION_INIT Pragma The pragma EXCEPTION_INIT relates an exception name with an Oracle error number. Which allow you to refer to any internal exception by the name and to wri

Query: SELECT * FROM EMPLOYEE1; Select 5 columns and all rows from one table Query: SELECT C_ID, COMPANY, BUILDING, DEPARTMENT, BRANCH FROM CONTRACT;

How Calls Are Resolved? The figure shows that how the PL/SQL compiler resolves the subprogram calls. When the compiler encounters the procedure or function call, it tries to di

Semidifference and NOT - SQL In this section first describe the relational difference operator, named MINUS. Example here shows SQL's closest counterpart of that operator.