Re: Is SQLPLUS implemted using OCI?

A copy of this was sent to szhan_at_calum.csclub.uwaterloo.ca (Philip S Zhan) (if that email address didn't require changing) On 23 Oct 1999 21:03:04 GMT, you wrote:

>
>If SQLPLUS is implemented using OCI, then what you can do in SQLPLUS
>can be done using OCI? I noticed that some of the sql statement can
>be executed in SQLPLUs but OCI is picky on embidded characters.
>
>Phillip

give an example?

SQLPlus is an environment you run queries in. For example, in sqlplus you can:

SQL> select * from emp;

You can put a ';' at the end of the sql statement. If you try that when executing a query in OCI (adding the ';') -- you'll get an error. that is because the ';' is a terminator to the application SQLPlus and it submits only what is in front of it. OCI is an API that expects SQL only -- SQLPlus is an interactive environment that 'gets' the query from you and then runs it. What you type in is not what is submitted as the query exactly.

-- 
See http://osi.oracle.com/~tkyte/ for my columns 'Digging-in to Oracle8i'...
Current article is "Part I of V, Autonomous Transactions" updated June 21'st
 
Thomas Kyte                   tkyte_at_us.oracle.com
Oracle Service Industries     Reston, VA   USA

Opinions are mine and do not necessarily reflect those of Oracle Corporation