Topic: Oracle Programming
Download (603) times
Last Download at Sunday 29th of January 2012 03:58:36 AM
Oracle/SQL Tutorial
This Oracle/SQL tutorial provides a detailed introduction to the SQL query language and the
Oracle Relational Database Management System. ...
A table is uniquely identiï¬ ed by its name and consists of rows that contain the stored informa-
tion, each row containing exactly one tuple (or record ). A table can have one or more columns.
A column is made up of a column name and a data type, and it describes an attribute of the
tuples. The structure of a table, also called relation schema, thus is deï¬ ned by its attributes.
The type of information to be stored in a table is deï¬ ned by the data types of the attributes
at table creation time.
SQL uses the terms table, row, and column for relation, tuple, and attribute, respectively. In
this tutorial we will use the terms interchangeably.
A table can have up to 254 columns which may have diï¬ erent or same data types and sets of
values (domains), respectively. Possible domains are alphanumeric data (strings), numbers and
date formats. Oracle oï¬ ers the following basic data types
...
Source: www.db.cs.ucdavis.edu
Related PDF Files
Comments for Oracle/SQL Tutorial