What is the difference between base table and view?
- 7 Answers
- 30307 Views
- I also Faced
- E-Mail Answers
Answer Posted / ankit
base tables have physical table which does havefacility to
select any condition and save but view is part of a base
table but diffrence is in view we can select columns and
rows using conditions in view creating
| Is This Answer Correct ? | 8 Yes | 2 No |
Post New Answer View All Answers
What are the various data types available in db2?
What does a deadlock mean in DB2?
What is difference between rollback and commit?
What is role in db2?
How do you find the maximum value in a column in db2?
have 3 tables table1, table2 and table3 which contains employee information. table1 is master table, table2 contains emp details like emp no and so on, table 3 contains emp salary. so if any emp leave company between 25th - 30th of every month it has to get updated in tables. but it is not getting updated. What is the reason.
can we view the access paths created by dbrm ? how ? thx
What are the prerogatives?
What is universal database?
What is the maximum length of sqlca?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
What action db2 takes when a program aborts in the middle of a transaction?
What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?
What is the difference between bind and rebind in db2?
Describe major components of db2?
