• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 254
  • 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
What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

 
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

Featured Post

Free Tool: SSL Checker

Scans your site and returns information about your SSL implementation and certificate. Helpful for debugging and validating your SSL configuration.

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