database

[suha]

hello
i'm new to oracle,i've been informed that to create tables of a database, i have first to write them first in notepad then i generate them by oracle i wonder if there is a direct way by oracle to create these tables instead of writing them in notepad.

suha

 

[mrcomino]

I really dont understand you.

There are a lot of ways to generate a table i a oracle DB.

You can create via
- a SQL command SQL>Create table t1 (col1 number);
- or via a script SQL>@table_creation.sql
- or using some graphical tool that generate the SQL and
execute it in a transparent manner
(ie,Visio2000 ,Designer, TOAD,...).


Sorry for my english.
Antonio

 

[Yvessss]

Suha,

the idea is to create sql script that you can save
somewhere (unless you use a tool).