Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / pavan_1981
view is one type of database object which doesnt store any
data but fetches its data from the tables on which the view
is built.views can be of two types.one complex and other
simple.depending on type of te view different perations are
allowed on the views.
advatages:
1.views are secure because we can fetch the data from
different tables and present it to the user with cloumn
alias's so tha user wont know the actual column names or
table names.
2.instead of writing a huge join query which u most
frequently use everytime and executing it, we can create a
view using that query and just say for example "select *
from view".this inturn fetches the data u want from the
tables meeting ur requirements.
3.u can grant privilages to the user on the views instead
of giving privilages on the actual tables.this sometimes
help in security.
these are just few advantages to bgin with.still more exist.
| Is This Answer Correct ? | 19 Yes | 0 No |
Post New Answer View All Answers
What is sharded cluster?
What is index in Oracle?
How to define a data field as not null?
What is set operator oracle?
15. Display the item_cost and then truncate it to the nearest hundred, ten, unit, tenth and hundredth.
types of indexes and the rationale behind choosing a particular index for a situation.
How to define a record variable to store a table row?
How to count groups returned with the group by clause in oracle?
How to define an oracle cursor variable?
What is open database communication (odbc) in oracle?
How to add another datafile to a tablespace?
Select all the employees who were hired in last 2 years and who works in dept where max managers are working.
I am using an Oracle 8i Database my data contains Clob data. I am using toad version 7.6 i am able to get the data in toad but unable to extract the data in excel.when trying to extract the data into the excel the toad error says out of memory. Can any body please help me to extract the data through the same toad version. Thanks in advance
Explain the types of exception?
What is oracle in java?
