Answer Posted / ab
View do not contain data.
when u query view it featches the data from the underlaying
table on which view is created.
v$ views are created in X$ base tables
| Is This Answer Correct ? | 4 Yes | 0 No |
Post New Answer View All Answers
I just want to maintain data like an employee can belongs to 3 or more departments . We can resolve this by using composite key but it avoids normalization rules. So Can anyone tell me how can I maintain data.
What happens to the current transaction if a ddl statement is executed?
State and explain about oracle instance?
how to use select statement as formal parameter in procedure specification?(someone said that using string) ex:-procedure(a in number,select ename from emp ) i am asking syntax like this?
What is the quickest way to fetch the data from a table?
How is it different from a normal table?
What is a server parameter file in oracle?
what are actual and formal parameters?
Explain an exception?
What is a schema in oracle?
How would you begin to troubleshoot an ORA-3113 error?
Explain the difference between a procedure and a function?
How do we create privileges in oracle?
What is difference between cartesian join and cross join?
can u plz provide me oca sql dumps please i need them