OpenIngres to Oracle

From: Arturo Mijangos <arturo_mijangos_at_hotmail.com>
Date: 2000/07/19
Message-ID: <8l4vfj$g1k$1_at_acs2.byu.edu>#1/1

[Quoted] I have the following query for an OpenIngres database, how can i change it to Oracle
query:

exec sql update class_control_temp t from crs_control c set ge_code = c.ge_area,
grade_rule = c.grade_rule,
course_type = c.course_type
where t.curriculum_id = c.curriculum_id
and t.eff_year_term = c.eff_year_term;

any help will be apreciated

--

---

Arturo A. Mijangos
Advanced Technology Services
Brigham Young University
E-mail: arturo_at_byu.edu
ICQ#: 47114643 Received on Wed Jul 19 2000 - 00:00:00 CEST