let say we have a Table of employees having the column EmployeeName, Department:
EmployeeName | Department |
---|---|
John | HR. |
Jenny | Tech. |
I want to have a new column in a view taking EmployeeName as data along with static private-key. Don’t wanna change the table structure, but just to get UUID in select query For eg: select EmployeeName, Department, UUID({private-key},EmployeeName) as UUID from EmployeeTable
View result example:
EmployeeName | Department | UUID. |
---|---|---|
John | HR. | f1cf5eqf0-63c6-11ec-90d6-0242ac120003 |
Jenny | Tech. | z1cf5emk0-63c6-11ec-90d6-0242ac120003 |
is this achievable?