Oracle vs. MS SQL Stored Procedures

[foxdev]

I enjoy working with MS SQL Server 7, and am fairly comfortable in it, including writing decent stored procedures.

One of my clients is desparate for an Oracle 8 developer, and is probably considering asking me to take on Oracle stored procedure development.

From what I've seen thus far of the Oracle SP language and approach, it is substantially different from SQL Server 7 (very different in syntax such as constructs, and different in some key ways in approaching certain tasks).

For those of you with experience in both, how easily do you think a SQL Server developer of slightly below-average intelligence could move into and become productive in Oracle SP development? [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]

 

[crystalized]

Well since you are so &quot;dumb&quot; I would just abandon the idea all together. LOL

Actually the little bit I touched on Oracle at school I found it not that bad. No joins are included so you need to join tables with the where statement. (That is really all I remember).

Sorry I can't be more help. [sig]<p>Crystal<br><a href=mailto:crystals@genesis.sk.ca>crystals@genesis.sk.ca</a><br><a href= > </a><br>--------------------------------------------------<br>
Experience is one thing you can't get for nothing.<br>
-Oscar Wilde<br>
[/sig]

 

[arlynsmith]

As a certified Oracle DBA moving into SQLServer stored procedures I am coming at your problem from the other end. Syntactically there are many differences and the constructs look different. The Oracle training is pricey but I have found it to be worth it - you can easily make up for the cost of the SQL/PLSQL class (five day class) in a few weeks in efficiency. Since Oracle procedures are written in PLSQL it is worthwhile to take the class - alternatively buy the very best book you can find. A small Oracle instance to use for testing is a real help - it can even be personal Oracle running on your workstation or laptop. [sig][/sig]

 

[foxdev]

alternatively buy the very best book you can find

Well, since you opened the topic, can anyone recommend books on specifically Oracle PL/SQL? It should be a book oriented towards someone with a lot of programming and SP experience, but new to Oracle PL/SQL. [sig]<p>Robert Bradley<br><a href=mailto: > </a><br><a href=

http://www.foxdev.com/>FoxDev

- Visual FoxPro Development</a><br> [/sig]