Are there any known dialect differences between Oracl and Sybase, or do I
use the same calls to access both bases? Can anybody help me to sort out the
main differences in the comands (I'm new to Sybase)

"Per E. Tronaas" <m-el-tro (AT) online (DOT) no> wrote

Except for the most of the standard SQL, which is largely ANSI-compliant for
both products, Oracle and Sybase ASE use completely different syntax.
For some links to documents listing syntax for similar operations, see
www.sypron.nl/syblinks.html.

HTH,

Rob
-------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 12.5/12.0/11.5/11.0
and Replication Server 12.5

Author of "Tips, Tricks & Recipes for Sybase ASE" and
"The Complete Sybase ASE Quick Reference Guide"
Online orders accepted at http://www.sypron.nl/shop

mailto:rob (AT) YOUR (DOT) SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., P.O.Box 10695, 2501HR Den Haag, The Netherlands
-------------------------------------------------------------

Per E. Tronaas wrote:

Not only is the syntax different as Rob has indicated the underlying
architecture and types of objects are different. Knowledge of Sybase
is about as useful in Oracle as SELECT * FROM ... and ends shortly
thereafter.

For an excellent book on making the adjustment ... if you find yourself
working with both ... get Tom Kyte's book "Expert one-on-one Oracle" and
read the first three chapters with great care.

--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
damorgan@x.washington.edu
(replace 'x' with a 'u' to reply)