| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
Home -> Community -> Usenet -> comp.databases.theory -> Re: approaches for embedding a data language in a general purpose language
On Oct 9, 4:13 pm, "Aloha Kakuikanu" <aloha.kakuik..._at_yahoo.com> wrote:
> Marshall wrote:
> > Anyone have any opinions, pro or con, about embedded SQL?OK, compare
>
> #sql { INSERT
> INTO person
> VALUES ('999999999', 'Doug Barry');
> };
>
> with
>
> Statement stmt = conn.createStatement();
> stmt.execute("INSERT
> INTO person
> VALUES ('999999999', 'Doug Barry')");
>
> Do you see much difference? I don't.
I don't either. However this example illustrates only statements referencing constant values. My expectation would be that the advantage of embedded SQL would be in the integration of variables between host and embedded language.
Marshall Received on Mon Oct 09 2006 - 22:16:17 CDT
![]() |
![]() |