Management and Administration > Workspace Management > Management Console > SmartObject Services > SmartObject Services > The K2 Oracle Service > Oracle Views | Send feedback |
Views support the Select statement and will ONLY return a List Service Object method.
Fig. 1. Oracle Service Object Views methods
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; |