الدرس الثامن : الفانكشن المهمة للتعديل على الجداول, ضمن سلسلة دروس كيف تبدأ في تعلم الأوراكل

CODE
ALTER TABLE table_name
ADD column_name column-definition;

CODE
ALTER TABLE supplier
ADD supplier_name varchar2(50);

CODE
ALTER TABLE table_name
ADD ( column_1 column-definition,
column_2 column-definition,
...
column_n column_definition );

CODE

ALTER TABLE supplier
ADD ( supplier_name varchar2(50),
city varchar2(45) );

CODE
ALTER TABLE table_name
MODIFY column_name column_type;

CODE
ALTER TABLE supplier
MODIFY supplier_name varchar2(100) not null;

CODE
ALTER TABLE table_name
MODIFY ( column_1 column_type,
column_2 column_type,
...
column_n column_type );

CODE
ALTER TABLE supplier
MODIFY ( supplier_name varchar2(100) not null,
city varchar2(75) );

CODE
ALTER TABLE table_name
DROP COLUMN column_name;

CODE

ALTER TABLE supplier
DROP COLUMN supplier_name;

Rename column(s) in a table
(NEW in Oracle 9i Release 2)

CODE
ALTER TABLE table_name
RENAME COLUMN old_name to new_name;

CODE
ALTER TABLE supplier
RENAME COLUMN supplier_name to sname;

CODE

DROP TABLE table_name;

DROP TABLE supplier;