Hi,

I have a project which requires me to use PL/SQL blocks, PL/SQL cursors, PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers.

I think(not sure) i can create PL/SQL stored procedures, PL/SQL stored functions and PL/SQL triggers in MySQL. Can i create PL/SQL blocks and PL/SQL cursors within MySQL as well? Or it is neccesary for me to use an Oracle database?

I have WampServer with MySQL 5.0.45. Also i have no experience with Oracle.

Thanks

hi,

sure, MySQL now also offers some procedures, functions and triggers (of a kind) but one cannot compare that with Oracle's inimitable functionality nor you can seriously write PL/SQL programs using MySQL. I would suggest you download free Oracle express edition 10g which is also able to perform PL/SQL. Such a thing like Oracle clone is free PostgreSQL (UNIX and MS Windows) what also performs some PL/SQL.

krs,
cliff

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.