Re: Simple query not executing on Oracle

ravisk12_at_my-dejanews.com wrote in message <705p51$uk7$1_at_nnrp1.dejanews.com>...
>
>"select * from ':DATABASE1:TABLE'"
>using DbiQExecDirect fails on Oracle, But the same query works fine with
>Paradox.. Could someone explain me the reason for this.

In the beginning there was Codd. And he said "Let there be SQL" and there was. He looked at it and it was a Good Thing (tm).

To cut a long and interesting story short, then came the database vendors and raped and plundered it... :-)

Seriously though, SQL implementations are not the same. Vendors do their own things (no real surprises there). For Oracle, drop the quotes (not necessary) from your SQL and replace DATABASE1 with the name of the schema (i.e.. Oracle user) and use a colon to separate the name of the TABLE with the name of the SCHEMA.

Example:
SELECT * FROM SCOTT.CLIENTS There's a kind of vanilla flavour of SQL. The basic set of ANSI SQL '92 standards - minimum conformance I think they call it. If you stick to that then your stuff should work against most SQL db platforms.

Oracle SQL has the vanilla flavour, but the chocolate and strawberry flavour is much better. Oracle supplies you with a lot of additional (non-standard of course) SQL extensions that are very powerful. Even to the extend that you can implement IF THEN ELSE type logic in the SELECT part of the SQL statement. Extremely useful when handling VLDBs or VLTBs where you can not resort to the slow cursor based processing.

enjoy the ice-cream!
Billy Received on Fri Oct 16 1998 - 06:28:42 CDT