Article Categories
- All Categories
-
Data Structure
-
Networking
-
RDBMS
-
Operating System
-
Java
-
MS Excel
-
iOS
-
HTML
-
CSS
-
Android
-
Python
-
C Programming
-
C++
-
C#
-
MongoDB
-
MySQL
-
Javascript
-
PHP
Selected Reading
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: 2020-02-27T10:31:37+05:30
585 Views
Advertisements