Answer Posted / as
I know a senario in which views are created.
Suppose I have a field in my table which is secure and
should not be visible to everyone. In that case i can
create a view without that field and keep the table acces
(even browse) with a particular set of people.
| Is This Answer Correct ? | 13 Yes | 0 No |
Post New Answer View All Answers
Explain correlated sub-queries.
What is the max length of sqlca?
What is the difference between cursor stability and repeatable read isolation levels?
What does db2 stand for?
What is an instance database?
by using cursors , we can access particular records from the table based on some condition, i want to delete those selected records, how can we write a query for this in the program?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
What is sqlca’s maximum length?
What is the role of schema in the db2 database?
List down the types of triggers in the db2 database?
What's The Error Code For Unique Index Voilation?
How do I delete a table in database?
What are the various isolation levels possible?
How to get the ddl of a table in db2?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.