Column

A column is one of the two components of a relational table (the other is called a row). Every table in a relational database has one or more columns. A column is named and contains related information. In non-relational terminology, a column can be thought of as a field.

Add column to table

One can add columns to a table, example:

ALTER TABLE t1 ADD (c2 NUMBER);

Remove column from table

One can remove columns from a table, example:

ALTER TABLE t1 DROP COLUMN c2;

Change column values

Example, changing a the salary column:

UPDATE emp SET sal=sal*1.1 WHERE empno = 123;

Adding column values

Example, inserting a value into column c1:

INSERT INTO t1 (c1) VALUES (123);

Glossary of Terms
A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q	R	S	T	U	V	W	X	Y	Z	#