Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
Understanding a database view in SAP HANA database
Consider the following example −
Example
| Id | Empl. Name | Empl.user | Empl.password | Joining Date |
| 1 | Employee 1 | Emp1 | Emp1Pwd | 9/11/2016 |
| 2 | Employee 2 | Emp2 | Emp2Pwd | 16/08/2015 |
| 3 | Employee 3 | Emp3 | Emp3Pwd | 15/09/2016 |
| 4 | Employee 4 | Emp4 | Emp4Pwd | 3/07/2014 |
| 5 | Employee 5 | Emp5 | Emp5Pwd | 10/09/2012 |
| 6 | Employee 6 | Emp6 | Emp6Pwd | 1/10/2013 |
Consider a scenario when a developer needs to analyze some data of Employee Table with the above fields. Using database view, an administrator can create a virtual table which only contains information about Employee Id, Employee name, and date of joining and give permission to developer to use that view.
Updated on: 27-Feb-2020
342 Views
Advertisements