sankardotb

 Profile Answers by sankardotb 

• May 30th, 2006

 

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

rampratap409

 Profile Answers by rampratap409 Questions by rampratap409

• Dec 4th, 2006

 

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

shamkohli

 Profile Answers by shamkohli Questions by shamkohli

• Jun 17th, 2008

 

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.

suganya

• Nov 30th, 2011

 

no....because sequence is used for creating the integer sequence values only at the time of table creation...
but view is a subset of data for the base table.....so cant create the sequence for the view