About PL/SQL

•

What is DaniWeb IT Discussion Community?

You're currently browsing the MySQL section within the Web Development category of DaniWeb, a massive community of 373,936 software developers, web developers, Internet marketers, and tech gurus who are all enthusiastic about making contacts, networking, and learning from each other. In fact, there are 2,478 IT professionals currently interacting right now! Registration is free, only takes a minute and lets you enjoy all of the interactive features of the site.

Join our community!

Please support our MySQL advertiser:

Thread Tools Display Modes

Views: 488 | Replies: 1

•

Join Date: Apr 2008

Posts: 95

Reputation: veledrom is an unknown quantity at this point

Rep Power: 1

Solved Threads: 0

veledrom

Offline

Junior Poster in Training

About PL/SQL

Apr 21st, 2008

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

•

Join Date: Apr 2008

Posts: 275

Reputation: tesuji is an unknown quantity at this point

Rep Power: 1

Solved Threads: 37

tesuji

Offline

Posting Whiz in Training

Re: About PL/SQL

Apr 21st, 2008

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