Re: PL/SQL versus stored procedures

On 13 Oct 2005 22:15:44 -0700, apngss_at_yahoo.com wrote:

>I want to know what's the differences between PL/SQL and stored
>procedures,
>the followings are my analysis, please comment and advise.
>
>1) PL/SQL is Oracle specific, stored procedures are supported in
>Oracle, MS-SQL Server, or other databases.
>
>2) PL/SQL has 2 types: procedures and functions
>
>3) PL/SQL procedure = stored procedure ??
>
>4) Oracle stored procedure and MS-SQL stored procedure have
>different syntax. I think they are slightly different, I could
>find the syntax for Oracle stored procedure, but not MS-SQL stored
>procedure. In other words, can we put MS-SQL stored procedure
>and put in Oracle without any changes?
>
>Please advise. thanks!!

1 PL/SQL is Oracle's language to implement stored procedures, T-SQL is MS language to implement stored procedures. T-SQL is only supported in MS and maybe Sybase. 'Stored procedure' is a *concept*, not a *language*

2 Like any proper procedural language

3 PL/SQL can be used for anonymous blocks : ie code which is not stored, and for procedures/functions/packages which are stored

4 the syntax for T-SQL and Pl/SQL is akin, but dissimilar. T-SQL procedures won't work in Oracle and vice versa, moreover Oracle works completely different, and too many people mistakenly think Oracle is sqlserver sold by a different vendor. It is not, it works completely different.

--
Sybrand Bakker, Senior Oracle DBA