Interested to Buy Any Domain ? << Click Here >> for more details...
what is different between view and sequence?
- 4 Answers
- 6271 Views
- I also Faced
- E-Mail Answers
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 |
How will you enforce security using stored procedures ?
What are the system resources that can be controlled through Profile ?
What are the dictionary tables used to monitor a database spaces ?
What are the roles and user accounts created automatically with the database ?
What are the use of Roles ?
What is a trace file and how is it created ?
What are the various type of snapshots ?
What are roles ? How can we implement roles ?
What is Statement Auditing ?
How can you enable automatic archiving ?
What are the responsibilities of a Database Administrator ?
What is default tablespace ?
Oracle General 
