Create and drop statements for 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';