Punithavel

 Profile Answers by Punithavel 

• Mar 3rd, 2009

 

Synonym - Giving alias of the existing database object. The need of synonym is to access the other schema objects easily.. (for Eg.. If you want to access gl_list table from GL schema object, you usually query with GL.gl_list, If we create synonym gl_list_s for GL.gl_list from your schema.. you can directly query gl_list_s..) this is more useful with APPS Schema... All the objects in APPS schema or synonym and views from other schemas.

Sequence - This is also a database object and it is used to generate number and it can used to insert values in the table. Mostly used to enter primary key columns (for eg: supplier id, person id, emp id, etc.,)

Hope you got it