Lesson : 6 Objects and Schema in Oracle

What is Object in Oracle ?

Everything is stored and referred as objects in oracle database, here is the list of few  oracle database objects

•           Tables

•           Views

•           Indexes

•           Synonyms

•           Sequences

•           Procedures

•           Functions

•           Packages

•           Triggers

 

What is Schema ?

A schema is a collection of logical structures of data, or schema objects. A schema is owned by a database user and has the same name as that user. Each user owns a single schema. Schema objects can be created and manipulated with SQL

 

Rules for naming database objects :-

1)      First character must be an alphabet

2)      Maximum 30 characters (or bytes)

3)      Special characters not allowed except  underscore(_) or $

4)      Should not be a oracle reserved word