Manage table in Oracle
Create table command is used for creating new table in the Oracle Database. Table is defined as object in Oracle.
Table is primary thing in Oracle Database to stored the data of user. RDBMS used to stored data in form of table.
Syntax
Create table
(
column_name1 datatype1,
column_name2 datatype2,
column_name3 datatype3
)
Example
--Example of create employee table
Create table employee ( emp_id number, emp_name varchar2(100) );
Check the table created in which owner or tablespace
Select owner, table_name, tablespace_name from dba_tables;
Check the column of tables
select column_name, data_type,data_length from dba_tab_columns;
Check partition tables
Select owner,table_name,partition_type from dba_part_tables;
Drop table
Drop table table_name;
Check table created date
select created from dba_objects where object_name='table_name';