re: PL/SQL

[Guest_imported]

Question,



If I was to master PL/SQL is there a big difference between the different implementations of SQL language on other databases. UNIX is pretty much the same command line wise on overy system with a few differences. I was wondering if SQL was the same.

 

[carp]

SQL is the the same for a given RDBMS across different platforms. However, there are huge differences in how SQL is implemented from one RDBMS to another.
PL/SQL is not SQL. PL/SQL is Oracle proprietary; it won't be on other databases.

 

[Guest_imported]

I am sorry let me be more descriptive. I am not talking about the database I am referring to the code, language. Syntactically are their major differences between the languages on different RDBMS.

 

[noitall]

ansi sql is standard across db's, however as carp stated, pl/sql is an oracle thing, you'd be better off looking at pro c, conceptsof cursors and fetching embedding sql in perl or c, in my opinion doesn't differ that much betwen databases, with some exceptions of course

 

[carp]

Yes, ANSI SQL is standard across all DBs.
However, many DB vendors CLAIM to be ANSI-standard and yet they are not the same! So while SQL will be similar across DBs (to the point that with just a little brain damage you can go from one to the other), you shouldn't expect it to be exactly the same.

 

[noitall]

quote :"to the point that with just a little brain damage you can go from one to the other"

amen to that!!