RE: OT : informix and/or sybase

here are some hints (probably originally from someone on this list) that I found handy coming from Sybase to Oracle. perhaps you'll find it handy going the other direction.

• desc[ribe] == sp_help [tablename]
• show user == select user_name()
• password == sp_password (pre Oracle 8.0; alter user)
• alter table a rename to b OR rename a to b == sp_rename.
• select * from v$session == sp_who
• select * from user_view == sp_helpcode [view_name]
• prompt "text" == print "text" (shows text on the screen)
• oracle error lookup: $ orerr ora ####
• select * from cat == select * from sysobjects

-----Original Message-----
Sent: Wednesday, June 26, 2002 11:24 AM
To: Multiple recipients of list ORACLE-L

Dear gurus !
There is a chance that i'll have to administer informix and/or sybase databases in addition to the Oracle ones. I have no idea whatsoever about these products. i would like to ask those of us who have any experience with these products to point me to any papers / URLs etc. , as a place to start. I know , that i can start with www.sybase.com and/or www.informix.com , and i will definetly do , but i thought may be anyone knows of some better way , may be a paper like "Sybase for Oracle DBAs" or "Informix for Oracle DBAs" . Anyway , i'll be extermely glad to have any inputs . Please send them either directly to me or to the list , and i promise to summarize everything i get and post the summary.
Thanks a lot !

DBAndrey

• 03-9254520
• 058-548133
• mailto:andreyb_at_elrontelesoft.com

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Andrey Bronfin
  INET: andreyb_at_elrontelesoft.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).
-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: STEVE OLLIG
  INET: sollig_at_lifetouch.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).