October 26, 2010 at 10:19 am
I've been googling and searching this site, so I'm pretty sure there is no "easy" answer to my question, but I'll ask anyway.
I speak "SQL Server". My co-workers speak a different language called "Oracle". To help in support for both groups, I'm trying to locate a command cross-reference - something like what is the Oracle equivalent for such commands like sp_help, sp_configure, sp_helpdb, sp_who2.
I found a useful link on differences for SQL statements - ie inserts, deletes, using sub-queries, but nothing for command cross-references. (See link - http://www.nocoug.org/download/2004-05/BegSQL.ppt )
Does anyone have a command cross-reference link that may be of use to me?
Thanks,
Cindy
October 26, 2010 at 10:25 am
i have these saved in my snippets, and the list is really incomplete:
--Oracle sp_help equivilent:
DESCRIBE tablename;
DESC tablename;
--Oracle sp_who equivilent
select osuser, machine, program, status from v$session;
--Oracle kill connection equivilent
select 'ALTER SYSTEM KILL SESSION '''||SID||','||SERIAL#||''';' AS KILL_STATEMENT,osuser, machine, program, status from v$session where PROGRAM <> 'ORACLE.EXE';
--oracle sp_helptext equivilent
SELECT text
FROM user_SOURCE
WHERE name = 'PROCNAME'
ORDER BY line;
Lowell
October 26, 2010 at 2:18 pm
Unfortunatelly there is not such a thing as a SQL Server - Oracle Magic Decoder Ring.
I would suggest to check alter system, alter database, alter session syntax and options.
_____________________________________
Pablo (Paul) Berzukov
Author of Understanding Database Administration available at Amazon and other bookstores.
Disclaimer: Advice is provided to the best of my knowledge but no implicit or explicit warranties are provided. Since the advisor explicitly encourages testing any and all suggestions on a test non-production environment advisor should not held liable or responsible for any actions taken based on the given advice.October 28, 2010 at 6:31 am
Thanks for confirming what I suspected... I guess I'll be creating my own document. Thanks, Lowell, for helping with a starting point for it.
Cindy
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy