Create an Oracle database table - speaker notes
Introduction to the creation of an Oracle database table.
CREATE TABLE table-name
(field/column name type with size in parenthesis for non
fixed length types,
field/column name type with size in parenthesis,
If you want a separation between words in the name of a table or the name of a field, use the underscore. Do not use embedded spaces.
CREATE TABLE is used to create the table.
DESCRIBE is used to show the structure of a table that has already been created.
To put data into the table, you use the INSERT command.
INSERT INTO table
Values(list the fields that are going into each column for this row/record - varchar2, char and date fields must be enclosed in single quotes - numeric columns are not enclosed in quotes)
NOTE that the column names are abbreviated since the column size is determined by the specified data length.