How to run pl/sql code in mysql

Status
Not open for further replies.

sganesh

Journeyman
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?
 

victor_rambo

हॉर्न ओके प्लीज़
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.
 
OP
sganesh

sganesh

Journeyman
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.
Hmmm,But how to use pl code to output sql,?
could it be still more clear for me to understand?
 
OP
sganesh

sganesh

Journeyman
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?
 

QwertyManiac

Commander in Chief
Something of the sort is present in MySQL 5.0 and upwards (N/A in 4.x). They are known as "Stored Procedures and Triggers" in MySQL. For starters, check this article: *dev.mysql.com/tech-resources/articles/mysql-storedprocedures.html
 
OP
sganesh

sganesh

Journeyman
ok fien,i ve tried procedures and function in MySQL,
But i Guess pl/sql programming found in oracle ,is really missing in MySQL
 

chandru.in

In the zone
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.
 
Status
Not open for further replies.
Top Bottom