SHARE
TWEET

view

a guest Nov 8th, 2019 77 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1.  CREATE OR REPLACE FORCE VIEW "WORKSHOP2"."APP_STUDENT" ("APPLICATION_ID", "APPLICATION_STATUS", "APPLICATION_TYPEOFSTICKER", "VEHICLE_ID", "VEHICLE_PLATENO", "STUDENT_ID", "STUDENT_NAME", "APPLICATION_DATE", "APPLICATION_ROFR", "APPLICATION_SESSION", "APPLICATION_LETTER", "STUDENT_EMAIL") AS
  2.   SELECT application.application_id,application.application_status, application.application_typeofsticker,vehicle.vehicle_id, vehicle.vehicle_plateno
  3. , student.student_id, student.student_name,application.application_date,application.application_rofr,application.application_session,application.application_letter,student.student_email
  4. from application natural join vehicle natural join student where
  5. applicant_vehicleid= vehicle_id and applicantstudent_id= student_id;
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top