User Tools

Site Tools


oracle:sql:table:alter_table

Oracle - SQL - Table - Alter Table

ALTER TABLE TABLE_NAME
ADD column_name datatype

or

ALTER TABLE TABLE_NAME
DROP COLUMN column_name
AS (alias) 	SELECT column_name AS column_alias
FROM TABLE_NAME

or

SELECT column_name
FROM TABLE_NAME  AS table_alias
BETWEEN 	SELECT column_name(s)
FROM TABLE_NAME
WHERE column_name
BETWEEN value1 AND value2
oracle/sql/table/alter_table.txt · Last modified: 2021/08/08 18:30 by peter

Donate Powered by PHP Valid HTML5 Valid CSS Driven by DokuWiki