Ask the Expert

SQL Server vs. Oracle procedures

What are the differences between SQL Server procedures and Oracle procedures?

    Requires Free Membership to View

At a very high level, Oracle and SQL Server stored procedures do the same thing. What differs is how they work. Oracle's procedures are written in a language called PL/SQL. SQL Server's procedures are written in a language called T-SQL. These languages are proprietary to the RDMBS vendor. And there are many differences in these languages, too many to enumerate here. If you are working on both systems, I recommend learning both languages. You will quickly become familiar with the differences between Oracle and SQL Server with respect to stored procedures.

This was first published in January 2008

There are Comments. Add yours.

 
TIP: Want to include a code block in your comment? Use <pre> or <code> tags around the desired text. Ex: <code>insert code</code>

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
Sort by: OldestNewest

Forgot Password?

No problem! Submit your e-mail address below. We'll send you an email containing your password.

Your password has been sent to: