Oracle

CREATE TABLE

Figo Kim 2006. 11. 13. 14:14
336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
CREATE TABLE [schema.]table
                  (column datatype [DEFAULT expr][, ...]);

-  Immediate effect on the database.
-  record record information in the data dictionary.

schema              is the same as the owner's name
table                   is the same name of the table
DEFAULT expr     specifies a default value if a value is omitted in the INSERT statement.
column               is the name of the column
datatype             is the column's data type and length

** schema **
A schema is a collection of objects. Schema objects are the logical structures that directly refer to the data in a database. Schema objects include tables, views, synonyms, sequences, stored procedures, indexes, clusters, and database link.

ex) SELECT * FROM user_B.employees;
    SELECT * FROM user_A.employees;

'Oracle' 카테고리의 다른 글

DEFAULT option  (0) 2006.11.13
DEFAULT option  (0) 2006.11.13
CREATE TABLE  (0) 2006.11.13
Database Objects , Naming Rules  (0) 2006.11.13
Database Objects , Naming Rules  (0) 2006.11.13