Oracle for the SQL Server Guy - Instances and Databases

  • ta.bu.shi.da.yu (7/2/2009)


    Mazharuddin Ehsan (7/2/2009)


    See some more useful comparisons in the below links:

    Oracle vs. SQL Server

    Be careful - some of the comparisons are not entirely accurate!

    The context here is to understand the working of the two DBMS products in comparison to each other and improve our efficiency in using them; not to debate what is available in one and lacking in other.

    However, it wouild be nice if you could share examples showing how 'CONNECT BY' and 'COMMENT' equivalent features can be implemented in SQL Server.

    I have been an Oracle developer for long and also worked on projects more recently where databases and applications had to be migrated from Oracle to SQL Server and vice versa.

    Sincerely,

    Maz

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]

  • Hi Jagan,

    This is an excellent Article for a SQL DBA to start with ORACLE concepts....

    well done..

    Thank You

    Ram

  • Excellent article. Look forward to a follow up comparing locking and transactions between Oracle and SQL Server. That should inspire some lively discussion.

  • Mike Bishop (7/2/2009)


    Excellent article. Look forward to a follow up comparing locking and transactions between Oracle and SQL Server. That should inspire some lively discussion.

    Oh man... you're not asking for much! lol!

    Random Technical Stuff[/url]

  • Thanks Jagan for a very 'to the point' writeup. Special thanks to Rich for the valuable inputs.

    Maz

    -----------------------------------------------------------[font=Arial Black]Time Is Money[/font][font=Arial Narrow]Calculating the Number of Business Hours Passed since a Point of Time[/url][/font][font=Arial Narrow]Calculating the Number of Business Hours Passed Between Two Points of Time[/font]

  • Hi,

    Looks like it is very useful for beginners in Oracle DB. Fundamentals are explained very clearly .

    Congrats Jagan chetta !!

    Thanks,

    Jithin

Viewing 6 posts - 16 through 20 (of 20 total)

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