Re: Does Oracle have a prog lang ?

hi,
In article <589jos$o3k_at_news2.cais.com>, carma_at_cais.cais.com (Carma International) writes:
> Sorry for the newbie question but I realize Oracle is
> a 4GL and I need to know if a host language is required

oracle is NOT a 4GL - it is an RDBMS with a programming language (PL/SQL) for manipulating the database at the server side!

and of course you can communicate with the server using ALL the commonly used programming languages. there are two kind of interfaces: OCI (low level) and Pro*C, Pro*Ada, Pro*Cobol, and Pro*Fortran (and maybe pascal?)

> to do if-then, do-loop operations on data sets via
> a cursor ?
> In other words, are there any 3GL features in any of Oracle's tools ?

you can use PL/SQL and external routines (call user exits) from these tools

>
>
> ALso can one application access more than one Oracle database ?
>
> Thanks,
> John Field
HTH
        peter Received on Sat Dec 07 1996 - 00:00:00 CET