Re: HELP with embedded SQL (pro*C)
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, TexasReceived on Thu Jan 20 1994 - 15:38:40 CET