Basics - Can we create sequence to a View??

GeekInterview.com > Interview Questions > Oracle > Basics

Go To First | Previous Question | Next Question

Basics | Question 19 of 49

Can we create sequence to a View??

Total Answers and Comments: 3

Last Update: June 17, 2008 Asked by: rajanipriya

Sponsored Links

Best Rated Answer

—

Submitted by: shamkohli

Sequence is used to generate numbers which can be stored in tables. View does not have data of its own and is generally used to query data. So sequence can not be created to a view.

Above answer was rated as good by the following members:
subajay

May 30, 2006 01:38:20

sankardotb

Member Since: May 2006 Contribution: 1

RE: Can we create sequence to a View??

S. We can create sequence to a view. If the view have writtable permission then the new values are Inserted/Updated/Deleted into TABLE.

Is this answer useful? Yes | No

December 04, 2006 08:12:50

rampratap409

Member Since: September 2006 Contribution: 111

RE: Can we create sequence to a View??

sequence is a independent object . It has no relation with table/view . its matter of use. where is being used because in general sequence is used for generating a sequenceal number ( primary number).

example:

create sequnec my_seq

start with 101

increment by 1

-- and other perameter

it has no direct relation with other objects

Is this answer useful? Yes | No

June 17, 2008 05:09:03

shamkohli

Member Since: June 2008 Contribution: 6

RE: Can we create sequence to a View??

Sequence is used to generate numbers which can be stored in tables. View does not have data of its own and is generally used to query data. So sequence can not be created to a view.

Is this answer useful? Yes | No

1 0

Overall Rating: +1

Go To Top

User Name		Remember Me?
Password

Question Bank