- 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.
Advertisements