Technical Development - Tiveloper.

SET UNUSED / DROP UNUSED COLUMNS ALTER TABLE SET UNUSED (); Or ALTER TABLE SET UNUSED COLUMN ; ALTER TABLE DROP UNUSED COLUMNS; * DROP UNUSED COLUMNS : removes from the table all columns currently makred as unused. Does not actually remove the target columns. Does not restore the disk space used by these columns. DROP will be faster than a normal Dropping. Related data dictionary view : USER_UNU..

SET UNUSED / DROP UNUSED COLUMNS ALTER TABLE SET UNUSED (); Or ALTER TABLE SET UNUSED COLUMN ; ALTER TABLE DROP UNUSED COLUMNS; * DROP UNUSED COLUMNS : removes from the table all columns currently makred as unused. Does not actually remove the target columns. Does not restore the disk space used by these columns. DROP will be faster than a normal Dropping. Related data dictionary view : USER_UNU..

Modifying a Column ALTER TABLE dept80 MODIFY (last_name VARCHAR2(30)); The width or precision of a numeric column The width of numeric or character columns Decrease the width of a column if: - contains only null value - The table has no rows - the decrease in column width is not less than the existing values in that column. Data type (if contains null values) exception : Char to VARCHAR2 (when i..

Modifying a Column ALTER TABLE dept80 MODIFY (last_name VARCHAR2(30)); The width or precision of a numeric column The width of numeric or character columns Decrease the width of a column if: - contains only null value - The table has no rows - the decrease in column width is not less than the existing values in that column. Data type (if contains null values) exception : Char to VARCHAR2 (when i..

Add a new column Modify an existing column Define a default value for the new column Drop a column ALTER TABLE table ADD (column datatype [DEFAULT expr ] [, column datatype] …..); ALTER TABLE table MODIFY (column datatype [DEFAULT expr] [, column datatype] ……..); ALTER TABLE table DROP (column); - DEFAULT expr : specifies the default value for a new column Adding a Column Ex) ALTER TABLE dept80 ..

Add a new column Modify an existing column Define a default value for the new column Drop a column ALTER TABLE table ADD (column datatype [DEFAULT expr ] [, column datatype] …..); ALTER TABLE table MODIFY (column datatype [DEFAULT expr] [, column datatype] ……..); ALTER TABLE table DROP (column); - DEFAULT expr : specifies the default value for a new column Adding a Column Ex) ALTER TABLE dept80 ..

Object PrivilegesTableViewSequenceProcedureALTER★ ★ DELETE★★ EXECUTE ★INDEX★ INSERT★★ REFERENCES★ SELECT★★★ UPDATE★★

Object PrivilegesTableViewSequenceProcedureALTER★ ★ DELETE★★ EXECUTE ★INDEX★ INSERT★★ REFERENCES★ SELECT★★★ UPDATE★★

Object Privileges vary from object to object.The owner has all the privileges.The owner can give specific privileges on that owner's object.[ Syntax ] GRANT object_priv [(columns)] ON object TO {user|role|PUBLIC} [WITH GRANT OPTION] - ALL : spcifies all object privileges. - PUBLIC : grants object privileges to all users [Ex] GRANT select ON employees TO sue, rich; GRANT update (department_name, ..

Object Privileges vary from object to object.The owner has all the privileges.The owner can give specific privileges on that owner's object.[ Syntax ] GRANT object_priv [(columns)] ON object TO {user|role|PUBLIC} [WITH GRANT OPTION] - ALL : spcifies all object privileges. - PUBLIC : grants object privileges to all users [Ex] GRANT select ON employees TO sue, rich; GRANT update (department_name, ..