what is different between view and sequence?
Answers were Sorted based on User's Feedback
Answer / fatima hussain
A view is a logical table based on a table or another view.
A view contain no data itself but it is like a window
through which data from tables can be views and changed.
A sequence is a user created database object that can be
shared by multiple user to generate unique integers.
Is This Answer Correct ? | 15 Yes | 1 No |
Answer / pooja
a view is a virtual table based on the result-set of an SQL
statement.
A view contains rows and columns, just like a real table.
The fields in a view are fields from one or more real tables
in the database.
SQL CREATE VIEW Syntax
CREATE VIEW view_name AS
SELECT column_name(s)
FROM table_name
WHERE condition
A sequence is a user created database object that can be
shared by multiple users to generate unique integers.
A sequence:
1.automatically generates unique no
2.is a sharable object
3.is typically used to create a primary key
4.replaces application code
5.speeds up the efficiency of accessing sequence.
Is This Answer Correct ? | 8 Yes | 0 No |
Answer / shailendra kumar
view is the logical stucture of the orginal table. but not
contain data the orginal table. this use the security
perpose.
sequence is the oracle generate number is requred for the
begining no and automaticaly no are dispaly.
Is This Answer Correct ? | 3 Yes | 2 No |
Answer / sunil
view is create table column it contion data of one column
and sequence is oracle generate number
Is This Answer Correct ? | 1 Yes | 1 No |
what is meant by physical order and logical order in clustered index and non clustered index.
What is the use of ANALYZE command ?
What is Object Auditing ?
How can you Enforce Refrencial Integrity in snapshots ?
What are the system resources that can be controlled through Profile ?
What are the minimum parameters should exist in the parameter file (init.ora) ?
What is Auditing ?
How will you enforce security using stored procedures ?
What are the benefits of distributed options in databases ?
What is Tablespace Quota ?
What is default tablespace ?
What is a profile ?