I wanted to convert t-sql code to Pl-sql(oracle 11g). Can any body guide what are the steps to be followed to migrate this code and how ?

And also please suggest some good sites like sql servercentral.com to query pl.sql related question, forum etc.

Regards, Ravi :)

I dont know of any sites that will do it for you (unlike the VB to C# conversion sites). Mostly because there are so many nuances between the 2 languages. Things I would do in SQL Server I would never attempt in PL-SQL and vice versa. Simple things like TRIM that do things in Oracle that does not happen in SQL Server. Return values, variables, scope, packages... the list goes on.

The real question is, is it really necessary to move it? The 2 can coexist.