RE: Oracle Vs Sybase

From: Grant Allen <Grant.Allen_at_towersoft.com.au>
Date: Wed, 22 Sep 2004 09:01:13 +1000
Message-ID: <DCFC52557FAC7640A8782B13032B81B0373C03@bishopsfinger.towersoft.canberra>

Before confusion spreads too far.

> 1. Sybase is case sensitive (eg) tables EMP ^=3D Emp ^=3D emp; Applies =
to
> Column names too.

This is configurable at the server level. If you want data and system = catalog case insensitivity, it's available. (And while I'm on it, = Oracle 10g's NLS_COMP feature is a god-send!)

> 4. Oracle Single Quote =3D Sybase Double Quote

Nope, SQL 89/92/99 quote standards are followed, including single quote = being its own escape character.

Ciao
Fuzzy
:-)

---

"Everything you think, do, and say
 was in the pill you took today."

• Zager and Evans -- http://www.freelists.org/webpage/oracle-l

Received on Tue Sep 21 2004 - 17:59:46 CDT