K2 BLACKPEARL PRODUCT DOCUMENTATION: USER GUIDE
Oracle Views

Oracle Service - Views

Views support the Select statement and will ONLY return a List Service Object method.


Fig. 1. Oracle Service Object Views methods

Samples of Views scripts

Copy Code   

CREATE OR REPLACE VIEW VW_STUDENT_SELECT

(

   "STUDENT_ID",

   "SALUTATION",

   "FIRST_NAME",

   "LAST_NAME",

   "STREET_ADDRESS",

   "ZIP", "PHONE",

   "EMPLOYER",

   "REGISTRATION_DATE",

   "CREATED_BY",

   "CREATED_DATE",

   "MODIFIED_BY",

   "MODIFIED_DATE"

)

AS

  SELECT *

  FROM STUDENT;

 

 


K2 blackpearl Help 4.6.10 (4.12060.1690.0)