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:[EMAIL PROTECTED] -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Andrey Bronfin INET: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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).
