What are the objects in oracle?
Table: An oracle table is used to store data. A table has columns with each column having a unique name and a data type.
Example:CREATE TABLE TABLE_NAME
(
COLUMN1 DATATYPE1,
COLUMN2 DATATYPE2
);
View: A view in oracle is a representation of data. Data here means results of a query that is stored in order to be reused for faster access. The view below creates a view view_std without actually giving any result. When this view is query, oracle executes a query.
Example:CREATE VIEW view_std
AS
SELECT stdid FROM student;
Synonym: A synonym is an alternate name given to an Oracle object like Table, view, stored procedure etc. Example: Create a public synonym (accessible to all users).
Example:Create public synonym suppliers
for app.suppliers;
Sequence: A sequence is used to create a unique series of number usually for a primary key. Example:- The sequence below starts with 1 up to 999 and is incremented by 1. it caches up to 20 values.
Example:CREATE SEQUENCE student_seq
MINVALUE 1
MAXVALUE 999
START WITH 1
INCREMENT BY 1
CACHE 20;
