Creating and destroying base tables, PL-SQL Programming

Creating and Destroying Base Tables:

Example shows an SQL command to create the base table counterpart of the ENROLMENT variable

Example  Creating a base table.

CREATE TABLE ENROLMENT
( StudentId  SID ,
  Name   VARCHAR(30),
  CourseId  CID ,
  PRIMARY KEY ( StudentId, CourseId )
) ;

(Example and the other examples in this chapter all end in semicolons. Actually, a semicolon is required in SQL only in scripts consisting of more than one statement. A script consisting of a single statement must not end in a semicolon.)

Posted Date: 1/11/2013 5:20:19 AM | Location : United States







Related Discussions:- Creating and destroying base tables, Assignment Help, Ask Question on Creating and destroying base tables, Get Answer, Expert's Help, Creating and destroying base tables Discussions

Write discussion on Creating and destroying base tables
Your posts are moderated
Related Questions
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

Adding Table Constraints ALTER TABLE ENROLMENT ADD CONSTRAINT NameNotNull CHECK (Name IS NOT NULL) ; ALTER TABLE ENROLMENT ADD CONSTRAINT PK_StudentId_CourseId PRIM

Product-specific Packages The Oracle and different Oracle tools are supplied with the product-specific packages which help you to build the PL/SQL-based applications. For illus

Processing Transactions This part describes how to do the transaction processing. You learn the fundamental techniques that safeguard the consistency of your database, involvin

%ISOPEN The %ISOPEN yields TRUE if its cursor or cursor variable is open; or else, the %ISOPEN yields FALSE. In the illustration, you use the %ISOPEN to select an action:

FOR-LOOP While the number of iterations through a WHILE loop is unknown till the loop completes, then the number of iterations through a FOR loop is known before the loop is ent

MERGE and TRUNCATE in SQL SQL has two more table update operators, MERGE and TRUNCATE. MERGE, like INSERT, takes a source table s and uses it to update a target table t. Brief

Using EXTEND To enlarge the size of a collection, use EXTEND. This process has 3 forms. The EXTEND appends one null element to a collection. And the EXTEND(n) appends n null e

THEO R Y OF PANSPERMIA - Arrhenius (1908) postulated the cosmic panspermia theory that claims that organisms existed throughout the universe, and their spores, etc., could

Important Distinctions The list of important distinctions are given below: Value versus variable Syntax versus semantics Variable versus variable reference