What is a view? Why use it?
Answers were Sorted based on User's Feedback
Answer / aditya
view is used to create another representation of data where
we can protect the important data from public view.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / purushothr
view is a logical table that can be created by one or more
base table
| Is This Answer Correct ? | 1 Yes | 0 No |
Answer / srinivasa yadav
VIEW IS A VIRTUAL MEMEORY SPACE WHICH DOES'NT HOLD ANY DATA.
MAINLY VIEW IS USED TO RESTRICT AUTHORIZATION FOR THE
USERS. SO USER CAN ACCESS ONLY PARTICULAR COLUMNS.
| Is This Answer Correct ? | 0 Yes | 3 No |
How can we retrieve the total number of records in RPG & CLLE?
What is ALTER ?
What is the cobol picture clause of the db2 data types date, time, timestamp?
How can you classify the locks in db2?
Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?
What is a host variable?
What technique is used to retrieve data from more than one table in a single SQL statement?
how to execute qcmdexc in rpgle?plz write code also?
What is ACQUIRE/RELEASE in BIND?
What is a Cartesian product?
What is the maximum length of sqlca?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?