• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 260
  • Last Modified:

How transferrable are Microsoft SQL development skills to Oracle SQL?

Hi guys

Question for you:  How transferrable are Microsoft SQL development skills to Oracle SQL?

I have six years experience in Microsoft SQL Server, and I'm have a potential client that has a stong need for an Oracle SQL troubleshooter, specifically writing stored procs, views, functions, and creating tables.  These are all things I've done before, but not in Oracle.

Points for advice.

Thanks.
Jim
0
Jim Horn
Asked:
Jim Horn
6 Solutions
 
sdstuberCommented:
there are a few SQL areas that differ significantly   date manipulation and type conversion are fairly common tasks that aren't performed with similar functions.

The main sql components though,  select, insert, update, delete, group by, etc  are all transferable
0
 
exceterCommented:
If you do not use T-SQL commands, then it is easier much.
0
 
sdstuberCommented:
stored procedures/functions will be significantly different as well,   pl/sql and t-sql aren't not similar at all
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
OP_ZaharinCommented:
- i've found this link on difference of sql syntax, joins, view, datatypes, functions and etc between databases which includes oracle and mssql server. you can refer on the difference:
http://troels.arvin.dk/db/rdbms/


- i would also suggest you to install oracle express edition, its a straight forward install and its free. all you need to do is register (free) and sign-in with the oracle site then download. you can use the command prompt 'sqlplus' tool to test the query difference or download a free GUI tool called SQL Developer:
http://www.oracle.com/technetwork/database/express-edition/downloads/index.html
http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html

OP
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
On standard development skills, I don't think it should very difficult since both technology must insure some level of compliance with standard SQL. Appart from that there are probably syntax proprietary differences related to the physical side of things since some concepts are different from one technology to the other.  I would recommend you ask the question in the Oracle section where you will find a higher chance of finding people who had the experience of your project.

Hope this helps...
0
 
Racim BOUDJAKDJIDatabase Architect - Dba - Data ScientistCommented:
For one, I think Oracle has two languages one for administration and one for development while SQL has only TSQL.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Thanks all.

I ended up getting another contract offer for the same jing that is straight SQL BI and DW, so I'll probably go with that.   Mostly to avoid any learning curve with Oracle, but also these guys are going to help me get my Microsoft certifications I've been blowing off for the last six years.

Jim
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now