Create view in SQL server for Binary duplicate check : Sqlserver

 

create   view vw_duplicate_face as

Select Photo, COUNT(EmployeeCode) as aa,

  min (EmployeeCode) AS EmployeeCode_min ,

  max (EmployeeCode) AS EmployeeCode_max

  from 

(

select [EmployeeCode], 

                     cast(cast([HDCPInfo] as varbinary(max)) 

                      as varchar(max)) 

  as Photo

from   [HWATT].[dbo].[KQZ_Employee]

)a

Group By Photo

Having COUNT(EmployeeCode)>1

Oraclre 12C: Pluggable Database (PDB) Automatic Startup

Below trigger will be created after SYS login to Container database

CREATE OR REPLACE TRIGGER auto_open_pdb

  AFTER STARTUP ON DATABASE 

BEGIN 

   EXECUTE IMMEDIATE 'ALTER PLUGGABLE DATABASE ALL OPEN'; 

END auto_open_pdb