Answer Posted / 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 |
Post New Answer View All Answers
No New Questions to Answer in this Category !! You can
Post New Questions
Answer Questions in Different Category
