How to Manage Schema Objects in Oracle

1
How to Manage Schema Objects in Oracle
Schema Objects A collection of databaseobjects
is called schema. A schema is belonging to a user
of the database and both share the same name.
Logical structures created by the users
represents Schema Objects.
2
Schema Object Management

• Either in your own schema or some other schema
  you can either create, modify and delete schema
  objects as a database administrator.
• For various reasons of this conversation, a data
  base administrator means any professional who has
  the command over the DBA part.

3

• So let us see the some of the subtopics of Schema
  Objects
• The SQL ALTER TABLE statement has the usage to
  add, modify, or drop/delete content in a table.
• The SQL ALTER TABLE declaration is also used to
  relabel a table.

4
Add column in table

• Syntax
• For adding a column in a table, the ALTER TABLE
  format in SQL is
• ALTER TABLE table_name
• ADD column_name column-definition
• Example
• Here is an SQL ALTER TABLE example for the above
  syntax.
• For example
• ALTER TABLE empdet
• ADD ENAME char(50)
• This SQL ALTER TABLE example will include a
  column known as ENAME to the EMPLOYEE table.

5

• Add several Columns in table

• Syntax
• For adding multiple columns to the current table,
• the SQL ALTER TABLE syntax is
• ALTER TABLE table_name
• ADD (column_1 column-definition,
• column_2 column-definition,
• column_n column_definition)