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 Statement Auditing ?
What is Object Auditing ?
What are Roles ?
What is Auditing ?
Differentiate simple and complex, snapshots ?
What is a profile ?
What are the roles and user accounts created automatically with the database ?
What is snapshots ?
What are the use of Roles ?
What are the steps to switch a database's archiving mode between NO ARCHIVELOG and ARCHIVELOG mode ?
What is the use of ANALYZE command ?