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?
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.
You cannot use WAMP server for perl. You need XAMPP.
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?
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
ok fien,i ve tried procedures and function in MySQL,
But i Guess pl/sql programming found in oracle ,is really missing in MySQL
Yeah, the full extent of it is not found in MySQL.
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.
