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;

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"

)

SELECT *

FROM STUDENT;