336x280(권장), 300x250(권장), 250x250, 200x200 크기의 광고 코드만 넣을 수 있습니다.
CREATE TABLE [schema.]table
(column datatype [DEFAULT expr][, ...]);
(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.
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 |
---|---|
CREATE TABLE (0) | 2006.11.13 |
Database Objects , Naming Rules (0) | 2006.11.13 |
Database Objects , Naming Rules (0) | 2006.11.13 |
무지에서 오는 고통..(손상된 디비 복구하기) (0) | 2006.09.12 |