Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Moving to the "dark side"

Author  Topic 

spthomas
Starting Member

14 Posts

Posted - 2011-07-01 : 16:19:54
I'm changing jobs, and the new employer uses mostly Oracle, not SQL Server. I know virtually nothing about Oracle. I assume the SQL is similar, but I don't even know how to log on! Does anyone have a reference or ideas where I can go to get up to speed on Oracle pretty quickly? I'm not a DBA, just an architect, so I don't need internals, just how to log on, SQL references (And differences from SQL Server), etc.

Thanks,

Steve

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-07-01 : 16:26:27
You should probably ask your question on a site that specializes in Oracle. At SQLTeam, we specialize in SQL Server.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

spthomas
Starting Member

14 Posts

Posted - 2011-07-03 : 18:18:47
While I know that this is a SQL Server site, I was betting I wasn't the only one who gets bounced back and forth from platform to platform, and what I'm looking for is someone who knows both SQL Server and Oracle. But I will hunt down an Oracle site.
Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2011-07-04 : 11:05:09
Try at www.orafaq.com

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page

Transact Charlie
Master Smack Fu Yak Hacker

3451 Posts

Posted - 2011-07-04 : 11:19:29
I believe (don't quote me) that 2005 brought SQL SERVER and oracle a lot closer in terms of features? Windowing functions etc existed in oracle allready and I think the syntax is broadly similar.

If your employer employed you knowing that you don't have a lot of experience of oracle they'll probably be fine with you getting the hang of the ropes

As long as you didn't claim to be an oracle expert? :)

Charlie
===============================================================
Msg 3903, Level 16, State 1, Line 1736
The ROLLBACK TRANSACTION request has no corresponding BEGIN TRANSACTION
Go to Top of Page
   

- Advertisement -