Re: OpenIngres to Oracle

From: Michiel Kuperus <cube_at_dds.nl>
Date: 2000/07/21
Message-ID: <0E16861EE7BCD111BE9400805FE6841F112653AD_at_c1s5x001.cor.srvfarm.origin-it.com>#1/1

i'm not sure(newbie), but it should be something like this:

set serveroutput on
create procedure temp is
  cursor c_control is
    select c.ge_area a, c.grade_rule r, c.course_type t     from crs_control c, class_control_temp t

    where  t.curriculum_id = c.curriculum_id
    and    t.eff_year_term = c.eff_year_term
    for update of t.ge_code, t.grade_rule, t.course_type;

begin
  for x in c_control loop
    update class_control_temp
    set ge_code = x.a,

           grade_rule = x.r,
           course_type = x.t

    where current of c_control;
  end loop;
end;

use sqlplus, use 'ed xxx' to copy-paste this, then run it ('_at_xxx'), then 'execute temp'

hope this will help you

greetz,
Michiel

Arturo Mijangos wrote in message <8l4vfj$g1k$1_at_acs2.byu.edu>...
>
>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
Received on Fri Jul 21 2000 - 00:00:00 CEST