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
Project Description: I want to write some SQL statements. The things I need are between pages 5-7. The only problem is that i want it till tomorrow. Skills required is SQL

Database Values You can use the SELECT statement to have the Oracle assign values to a variable. For Each and every item in the select list, there must be a matching, type-compa

Using TRIM This process has two forms. The TRIM removes an element from the end of the collection. The TRIM(n) removes the n elements from the end of the collection. For e.g.

Character Types The Character types allow you to store alphanumeric data, represent words and text, and manipulate the character strings. CHAR You use the CHAR dataty

heap sort program in pl/sql

I want someone to write a TSQL function that returns the name of the ODBC DSN. I will use the queries below, to get information about the connection, but none of these return th

Using %TYPE The %TYPE attribute gives the datatype of a variable or the database column. In the example below, the %TYPE gives the datatype of a variable: credit REAL(7,2); debi

Effects of NULL Operator As a general rule-but not a universal one-if NULL is an argument to an invocation of a system-defined read-only operator, then NULL is the result of t

Object Types An object type is a user-defined complex datatype which encapsulates the data structure along with the functions and procedures required to manipulate the data. Th

%NOTFOUND The %NOTFOUND is the logical opposite of the %FOUND. The %NOTFOUND yields TRUE when an INSERT, UPDATE, or DELETE statement affected no rows, or the SELECT INTO state