How to run pl/sql code in mysql

Discussion in 'Programming' started by sganesh, Dec 15, 2008.

Thread Status:
Not open for further replies.
  1. sganesh

    sganesh New Member

    Joined:
    Nov 25, 2007
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Chennai
    hi,
    i am using WAMP Server,I am using mysql query browser for create,updating database,
    once i ve studied pl/sql programming in oracle,,
    is it possible to run such code in Mysql Database?
     
  2. victor_rambo

    victor_rambo हॉर्न ओके प्लीज़

    Joined:
    Sep 29, 2007
    Messages:
    1,490
    Likes Received:
    0
    Trophy Points:
    0
    You cannot use PL in MySQL query browser. PL, actually just parses thhe variables and creates the final SQL statement. You have to send this SQL to the MySQL enegine. What you can do is use PL to output the SQL and then copy-paste the SQL in the MySQL browser.
     
  3. OP
    sganesh

    sganesh New Member

    Joined:
    Nov 25, 2007
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Chennai
    Hmmm,But how to use pl code to output sql,?
    could it be still more clear for me to understand?
     
  4. victor_rambo

    victor_rambo हॉर्न ओके प्लीज़

    Joined:
    Sep 29, 2007
    Messages:
    1,490
    Likes Received:
    0
    Trophy Points:
    0
    You cannot use WAMP server for perl. You need XAMPP.
     
  5. OP
    sganesh

    sganesh New Member

    Joined:
    Nov 25, 2007
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Chennai
    No i am not asking about PERL.
    i need info about PL/SQL(SQL PLUS) code that we use in oracle!
    ,The same can be implemented in Mysql or not?
    Didn't u get?
     
  6. QwertyManiac

    QwertyManiac Commander in Chief

    Joined:
    Jul 17, 2005
    Messages:
    6,656
    Likes Received:
    10
    Trophy Points:
    0
  7. OP
    sganesh

    sganesh New Member

    Joined:
    Nov 25, 2007
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Chennai
    ok fien,i ve tried procedures and function in MySQL,
    But i Guess pl/sql programming found in oracle ,is really missing in MySQL
     
  8. QwertyManiac

    QwertyManiac Commander in Chief

    Joined:
    Jul 17, 2005
    Messages:
    6,656
    Likes Received:
    10
    Trophy Points:
    0
    Yeah, the full extent of it is not found in MySQL.
     
  9. chandru.in

    chandru.in CAFEBABE

    Joined:
    Mar 23, 2008
    Messages:
    474
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Bangalore
    pl/sql cannot be found verbatim on any DB server other than Oracle's. PostgreSQL has a similar language called pl/pgSQL. You can have a look at it.
     
  10. OP
    sganesh

    sganesh New Member

    Joined:
    Nov 25, 2007
    Messages:
    113
    Likes Received:
    0
    Trophy Points:
    0
    Location:
    Chennai
    Thanks to above all!!!
     
Thread Status:
Not open for further replies.

Share This Page