Results 1 to 3 of 3

Thread: what are the major difference between MYSQL and ORACLE 9i ?

  1. #1
    Join Date
    Jan 2008
    Posts
    2

    Default what are the major difference between MYSQL and ORACLE 9i ?

     

    currently i am propose shift to work on MYSQL. The Oracle 10g features is applied on the MYSQL? Is it possible ? Please give me the suggestions.
    Powered by Yahoo!

  2. #2
    Join Date
    Jan 2008
    Posts
    1

    Default

    the major difference is by default the mysql database engine (my_isam) doesn't support transaction, use the transaction-safe storage engine (such as InnoDB, or NDB Cluster) that support this features.
    View, trigger, stored procedure is supported on MySQL 5.1.
    One other major diffence: the SQL language that they use.
    I think it can be done but not all 10 g features. You should consider postgreSQL, in my expirience it is more similar to Oracle than MySQL. oh yeah its free!
    Powered by Yahoo!

  3. #3
    Join Date
    Jun 2007
    Posts
    2

    Default

    There are various features exist in oracle 9i, It is completely a object oriented system. Mysql is a open source and only few features were exist compare to oracle.

    Creating procedures and Triggers .

    I hope we cannot able to create (views) in Mysql also the cursor is not exist. It depends upon the table type (MyIsam,Isam).
    Powered by Yahoo! Answers

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •