SQL - Structured Query Language

WITH ENCRYPTION - VIEW



WITH ENCRYPTION option is used to convert the original text of the CREATE VIEW statement to complicate text format. The following query is used to create view that helps to list out Employee Detail with Department Name by using SQL join concept.

-- Example 58 --

 

USE EBusiness

GO

 

CREATE VIEW EmpDept

WITH ENCRYPTION

AS

SELECT EMP.Emp_Code, EMP.Emp_Name, EMP.Dept_Code, DEPT.Dept_Name FROM EMP, DEPT

WHERE EMP.Dept_Code = DEPT.Dept_Code

GO

 

SELECT * FROM EmpDept


Query Output Screen



* * * * *


Email Your Comment To AUTHOR