Tom,

The class I took at my previous job called it "PL/SQL" <g>.

It's nice to have those books around!

>Oracle has its own extension of SQL called SQL/PL (PL = procedure
>language). As far as I know, you can only use standard SQL when
>utilizing VFP and Oracle via SQL Passthru.
>
>You will find that Oralce SQL is not very compliant to the SQL-92
>standard. This kind of surprised me. To see what I mean, compare
>and contrast a LEFT OUTER JOIN between SQL Server and Fox versus
>Oracle's (+) command.
>
>A good book on Oracle for your purposes would be "Oracle SQL
>High-Performance Tunning" by Guy Harrison. Check it out from
>Amazon.com or better yet buybooks.com (always cheaper).
>
>T.O.A.D. VI is a very good product to use when working with
>Oracle. The boys from Redmond would be doing themselves a favor
>by looking into the features of this tool. TOAD does things like
>emulating a BROWSE window (pretty neat considering Oracle is an
>SQL backend) from its Object browser. Lots of other things that
>make this approximately $200 product well worth it.
>
>You can get TOAD from www.quests.com.
>
>>>Paul,
>>>
>>>I connect to an ORACLE database (read-only) and the only "gotcha" I ran into was formatting of dates. If I were doing a specific query on a date, I would need to use '... WHERE TheDate = "Jan-10-1999"'
>>>
>>>The alternative is to say dMyDate = {01/10/1999} and then say '... WHERE TheDate = dMyDate' and let Fox convert for you.
>>>
>>>I am developing an application in Foxpro that will need to be used with Oracle as the back end in the future and was looking for information on the subject. If anyone knows of websites, usefull books or applications that would help, I would appreciate the input.
>>>
>>>Thanks,
>>>
>>>Paul
>>
>>I do a lot of work with VFP 6.0 connected to an Oracle 7.3 database. When you're using ODBC into Oracle, your SQL statement has to be written using Oracle's "flavor" of SQL. Dates in Oracle are recorded and stored as numbers. Try this whenever you need to use a date in a WHERE clause (or just about anywhere else): TO_DATE('06/11/1998','MM/DD/YYYY')
>>
>>To help us get up and running in Oracle, we bought a product called TOAD. There is a demo version but I don't have the URL here at home. It is a nice graphical interface for PL/SQL programming in Oracle. I had the company buy me a copy of PL/SQL Knowledge Base from the folks at http:\\www.revealnet.com\. They've got a demo version that you might want to look at. Their full version is rather pricey but it has done me more good than going to classes.
>>
>>If I can be of any help, let me know.
>>
>>Gregg