Post reply

SQL Server to Oracle - Magic Decoder Ring

  • October 26, 2010 at 10:19 am

    #228346

    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

    #1242422

    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

    --help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!

  • October 26, 2010 at 2:18 pm

    #1242543

    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

    #1243486

    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 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply