About Oracle to create data tables

ljeternity

Create a data table in SQL Server using Enterprise Manager or Query Analyzer
What is the purpose of creating a data table in Oracle?
Using SQL / PLUS? Or OEM?
If so, what is the difference between the two?
Thank you! !!

ljeternity

Please come, silly question

ljeternity

nobody? ? ? ? ? ? ? ? ? ? ? ?

saoshe

There is no third-party tool to use sql / plus directly. I use the pb development tool. It is easy to write SQL directly in it. Java uses jdbc. It is OK. There are many methods, as long as you can connect to the database and have permissions to create tables. .

saoshe

In addition, there is no essential difference, all are sending sql to oracle, executing and returning the result set. There may be differences in the implementation of different tools, for example, when I use pb, some intermediate tables for pb are generated Store some table information.

netspace

Toad, pl/sql developer, the tool for building tables

kissly

SQL> CREATE OR REPLACE TABLE TABLE_NAME (..,SID NUMBER, SNAME VARCHAR2(10),..);