what is a view?
Answers were Sorted based on User's Feedback
Answer / rad
view is a stored query and does not store any table data.
Is This Answer Correct ? | 2 Yes | 0 No |
Answer / s. senthil kumar
A view is a virtual table. Every view has a Query attached
to it. (The Query is a SELECT statement that identifies the
columns and rows of the table(s) the view uses.)
Is This Answer Correct ? | 1 Yes | 0 No |
Answer / senthil kumar
View is the virtual table. It is DML statement.
Is This Answer Correct ? | 1 Yes | 0 No |
A view is a logical db object which is created for data
security, data hiding etc. In database onle views
defination stored.
Syntax: create or replace view name_vw as select col1,
col2, ......... from table1, table2 where ....;
Types: (1) simple view
(2) complex view
(3) read only view
(4) force view
(5) with check option
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / guest
View is used to viewing the data and not for manipulating
it.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / manjunath k
a view consists of a stored query accessible as a virtual
table composed of the result set of a query.
Is This Answer Correct ? | 0 Yes | 0 No |
Answer / sunil maurya
A view is simply the representation of a SQL statement that
is stored in memory so that it can easily be re-used. For
example, if we frequently issue the following query
SELECT empid FROM emp;
I might well want to make this a view (the reality is that
we would probably never create a view for a statement this
simple but we wanted to use an easy example).
To create a view use the create view command as seen in this
example
CREATE VIEW view_emp
AS
SELECT empid FROM emp;
Is This Answer Correct ? | 0 Yes | 0 No |
10)In an RDBMS, the information content of a table does not depend on the order of the rows and columns. Is this statement Correct? A)Yes B)No C)Depends on the data being stored D)Only for 2-dimensional tables
What is oracle database client?
Hi Guys,I have completed my B.com Commerc in the year 2005 and MBA finance in 2008(Correspondance).And I have 3+yrs exp in Accounting and Finance feild.I have worked for TCS for 1.8yrs as Project manage office as a enduser in oracle ERP module.Currently working as Project Adminstartor for CSC.I have joined in Oracle financial classes and I am through with that subject.So my concern is After learning oracle, am in dilemma that will i be eligible to get job in oracle or not?Please advice or Give me suggestions.To kick start my career as fresher in Oracle
How to find out what privileges a user currently has in oracle?
Is primary key = unique key,not null? If yes,please explain IF No,please explain
Why is oracle database so popular?
Explain the types of exception?
How to define a specific record type?
Can an Integrity Constraint be enforced on a table if some existing table data does not satisfy the constraint ?
What are the different types of record groups in oracle? Explain each of them
What is clusters ?
Difference between the “verify” and “feedback” command?