ie-soft.de Blog

The Better Blog

manuel.trunk@ie-soft.de (Manuel) — Tue, 11 Dec 2007 13:37:20 GMT

New entries will be published by the better blog.

How do I add columns to table in Oracle

manuel.trunk@ie-soft.de (Manuel) — Thu, 28 Sep 2006 12:00:16 GMT

Syntax 1

To add a column to an existing table, the ALTER TABLE syntax is:

ALTER TABLE TableName
ADD ColumnName column-definition;

For example:

ALTER TABLE yourtable
ADD yourcolumn varchar2(50);

This will add a column called yourcolumn to the yourtable table.

Syntax 2

To add multiple columns to an existing table, the ALTER TABLE syntax is:

ALTER TABLE TableName

ADD ( column1 column-definition,

column2 column-definition,

...

columnn column_definition );

For example:

ALTER TABLE yourtable

ADD ( yourcolumn1 varchar2(50),

yourcolumn2 varchar2(45) );

This will add two columns (yourcolumn1 and yourcolumn2) to the yourtable table.

How to get information about tables and table columns in Oracle?

manuel.trunk@ie-soft.de (Manuel) — Mon, 15 May 2006 11:30:39 GMT

Get all tables including the system ones:
SELECT table_name FROM all_tables;

That will give you only the tables owned by the user that you are connecting as:
SELECT table_name FROM user_tables;

Query table columns:
SELECT * FROM all_tab_cols WHERE table_name = 'whatever table name you are looking for'

Looking for comments on the tables:
SELECT * FROM all_tab_comments WHERE table_name = 'whatever table name you are looking for'

ALTER TABLE TableName
ADD (	column1	column-definition,
	column2	column-definition,
	...
	columnn	column_definition );

ALTER TABLE yourtable
ADD (	yourcolumn1	varchar2(50),
	yourcolumn2	varchar2(45) );