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
Using a Host Variable You can declare the cursor variable in the PL/SQL host environment like an OCI or Pro C program. To use the cursor variable, you should pass it as a host

Using a join on 2 tables, select all columns and 10 rows from the 2 tables without the use of a Cartesian product. Query: SELECT * FROM EMPLOYEE1 E JOIN STAFF S ON E.EMP_

Name Resolution   During the compilation, the PL/SQL compiler relates identifiers like the name of a variable with an address or memory location, actual value, or datatype. Th

write the program for traffic control system with 10 second, 15 secod, and 20 second delay

Package STANDARD package named STANDARD defines the PL/SQL atmosphere. The package specification globally declares the exceptions, types, and subprograms that are available a

Parameter and Keyword Description: cursor_variable_name: This identifies a cursor variable or the parameter formerly declared within the present scope. host_cursor_va

Transaction Visibility As the figure shows, the changes made by an autonomous transaction become visible to another transaction whenever the autonomous transaction commits. Th

Manipulating Objects: You can use an object type in the CREATE TABLE statement to indicate the datatype of a column. When the table is created once, you can use the SQL statem

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

Assignment Source Not a Literal - Variable Syntax: SET SN = SID (SUBSTRING (SN.C FROM 1 FOR 1)||'5');