Re: differences between t-sql and pl-sql (SQL Server to ORACLE migration)

daddy cool wrote:

>Hi,
>
>For a SQLServer to ORACLE migration...
>Any information on the differences between T-SQL an PL-SQL is very
>much appreciated.
>Any info on difference between the databases too.
>
>
>Cees
>
>
>

You are focusing on the wedding ceremony and you haven't even become engaged.

Before you spend two minutes worrying about syntactic differences, and they are many and large, you need to become familiar with the huge differences in architecture, concepts, transaction models, and locking. Unless you fully understand and appreciate multi-version concurrency ... you are just wasting your time on even thinking about the languages.

-- 
Daniel Morgan
http://www.outreach.washington.edu/ext/certificates/oad/oad_crs.asp
http://www.outreach.washington.edu/ext/certificates/aoa/aoa_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)