FAQ for help going from Sybase to Oracle?

From: Kevin M. Haney <khaney_at_netaxs.com>
Date: 1997/02/05
Message-ID: <01bc1318$73f96bc0$9787a4cd@157.121.8.16.N_MIS>#1/1

If there's a FAQ out there that will help me make the transition from Sybase to Oracle, I'd like to hear about it. It's driving me crazy that I can't just connect to an Oracle database and do an sp_who, or select name from sysobjects, or select db_name(). I'm sure there are equivalent commands... I just need a good reference to figure them out.

Is there a "master" database in Oracle? Are there system stored procedures like sybase? How do I use sqlplus from unix (I've played with "sqlplus user/password_at_server"... it doesn't seem as flexible as isql)?, are there equivalent tables like sysdatabases, syslogins, sysobjects, etc, etc.

Any help, such as a book or web page that might have such helpful hints would be appreciated. If there isn't such a thing, maybe I'll compile one and submit it to the Oracle FAQ. Received on Wed Feb 05 1997 - 00:00:00 CST