Re: How to create database?

Tables are created by Create Table command.

The general syntax is

create table table_name(
  column1_name column_type,
  column2_name column_type,
);

Using a practical example

create table test1(
  id number,
  customer varchar2(50),
  startdate date
);

Then insert values using

insert into test1(id, customer, startdate) values (1, 'Fictional', TO_DATE('08/06/99','MM/DD/YY'));
commit;

Select using

select id, customer, startdate from test1;

You can dismiss table using
drop table test1;

My book recommendations:

Oracle7: The Complete Reference
George Koch and Robert Muller, ISBN 0-07-881919-9, published by McGraw Hill This book explains SQL*Plus, command and function syntax.

Oracle8 PL/SQL Programming
Scott Urman, ISBN 0-07-882305-6, published by Oracle Press/Osborne/McGraw Hill

For more books visit:
http://www.phptr.com
http://www.osborne.com (official site of Oracle Press. All book examples are available for download)
http://www.amazon.com (powered by Oracle Application Server)

Kevin Lo wrote:

> Hi,
>
> I'm a newbie for Oracle. I use 'oracle' to login, but I don't know how to
> create a
> database, would anyone tell me, thanks.
>
> - Kevin

Received on Fri Aug 06 1999 - 14:39:39 CDT