Re: HELP with embedded SQL (pro*C)

From: Mike Marolda <mmarolda_at_netcom.com>
Date: Thu, 20 Jan 1994 14:38:40 GMT
Message-ID: <mmaroldaCJxnCH.3yq_at_netcom.com>


In article <1994Jan18.065749.28528_at_frodo.cc.flinders.edu.au>, Matthew J Carr <carr_at_ist.flinders.edu.au> wrote:
>I was just wondering if it is possible to use views in embedded SQL.I have looked through the oracle pro*C user's guide and nothing is mentioned about views in there.
>
>What I want to do is query two tables to get the day and time of a given tutorial( in the tut_booking table) and the starting time from another(tutorial table)
>
> EXEC SQL create view time_ckeck as
> select distinct t_day,t_time,start_date
> from tut_booking,tutorial
> where stud_id = reg_num
> and tut_booking.tcode = tutorial.tcode; -- join condition
>
 ...
>
>All help will be appreciated.
>
> Matthew Carr.

It's been awhile since I hacked at Pro*C but shouldn't an "execute immediate" be in there somewhere (EXEC SQL EXECUTE IMMEDIATE...)

Mike Marolda

-- 
Mike Marolda
mmarolda_at_netcom.com
Allen, Texas
Received on Thu Jan 20 1994 - 15:38:40 CET

Original text of this message