User Tools

Site Tools


Sidebar

Welcome to DIDO WIKI

dido:public:s_cli:05_contents:01_prt:06_dddl:oracles

5.5 Oracles

Return to DidoDLL

 CREATE oracle OurDido.StudentStatement 
      FROM OurDido.StudentAccount
        TO MyDido.Student
       ( StudentStatementId : Hash,
         StudentId : SELECT genesis  
                       FROM MyDido.Student    STUDENT 
                      WHERE STUDENT.StudentId = $1.,
         AccountId : SELECT genesis  
                       FROM MyDido.StudentAccount ACCOUNT 
                      WHERE ACCOUNT.AccountId = $2.
       )
       AS UNION OF
       ( SELECT CURRENT  
           FROM MyDido.Student         
          WHERE MyDido.Student         = STUDENT.StudentId,
         SELECT CURRENT  
           FROM OurDido.StudentAccount 
          WHERE OurDido.StudentAccount = ACCOUNT.AccountId
       );
dido/public/s_cli/05_contents/01_prt/06_dddl/oracles.txt · Last modified: 2021/06/15 13:28 by nick
Translations of this page: