What are the objects in oracle?

Table, Views, Index, Synonym and Sequence are the objects of 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;

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值