Manage table in Oracle

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';

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

This site uses Akismet to reduce spam. Learn how your comment data is processed.