What are the objects in oracle?

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;
What is INDEX_BY_BINARY_INTEGER?
BINARY_INTEGER is a PL/SQL data type defined as a subtype of INTEGER in the STANDARD package and is used for storing signed integers......
What is index and explain its purpose
An index is a pointer to a location of data. The purpose of an index is to make SQL queries run faster.....
What are the guidelines to decide which table s to index?
On rebuilding an Index, the existing index is dropped and a new one is built. This operation can consume a lot of time and resources......
Post your comment