dcsimg
Login | Register   
RSS Feed
Download our iPhone app
TODAY'S HEADLINES  |   ARTICLE ARCHIVE  |   FORUMS  |   TIP BANK
Browse DevX
Sign up for e-mail newsletters from DevX

By submitting your information, you agree that devx.com may send you DevX offers via email, phone and text message, as well as email offers about other products and services that DevX believes may be of interest to you. DevX will process your information in accordance with the Quinstreet Privacy Policy.


advertisement
 

Oracle Has SQL Server Beat in Stored Procedure Programming : Page 4

Oracle9i and SQL Server 2000 add enhancements to the standard SQL language that enable you to use the database to implement your business rules and processes—SQL Server with Transact-SQL and Oracle with PL/SQL. Find out why the Oracle database engine is better suited for this role.


advertisement

WEBINAR:

On-Demand

Application Security Testing: An Integral Part of DevOps


Oracle Offers the Better Environment
Of course, technology changes and this applies even to something as seemingly mundane and old hat as writing stored procedures. On Oracle's side, PL/SQL continues to be enhanced with each version. You can also now write stored procedures in Java. Microsoft has also announced that in a future version of SQL Server you will be able to create stored procedures in your .NET language of choice. So in a year or so, perhaps SQL Server will have the better environment. But for now, Oracle is the clear winner.


Joe Lax has spent more than 10 years working in various database environments and has been a practicing DBA on all versions of SQL Server from version 4.2 onward. He also is a MCSE and an MCT who recently has started to learn Oracle, which affords him no end of fun. He loves feedback and can be reached at joe.lax@verizon.net.
Comment and Contribute

 

 

 

 

 


(Maximum characters: 1200). You have 1200 characters left.

 

 

Sitemap
Thanks for your registration, follow us on our social networks to keep up-to-date