Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Oracle for SQL Server veterans -- good references? Expand / Collapse
Author
Message
Posted Friday, February 7, 2014 11:17 AM
SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: 2 days ago @ 11:14 AM
Points: 2,041, Visits: 3,494
Hi folks . . .

I'm working a still-relatively-new job (been here since late October) that uses a dual (or is it "duel"? ) database environment: SQL Server and Oracle; that is, it supports both databases.

I'm discovering just how much I have to learn about Oracle; a simple ad hoc query that I could write in five seconds in T-SQL can take me a couple of hours in PL/SQL, simply because I still haven't gotten used to the subtleties of Oracle syntax and the interface.

With that, can anyone recommend a decent reference for someone (namely, ME) who's had plenty of experience in SQL Server, but is just getting his feet wet in Oracle?
Post #1539313
Posted Friday, February 7, 2014 3:33 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 2,397, Visits: 2,936
Perhaps it's not excactly what you are looking for, but I've seen a PPT from Gavin Payne. His last slide mentioned these references/reading materials:

Oracle 2-day DBA Guide (download)
Oracle – A Beginner’s Guide (Oracle Press)
Oracle for SQL Server DBAs (Oracle Press)

I myself liked the first one really well to get me on the way. Unfortunate (or happily ) I have not worked with Oracle in a business environment, so I frgot a lot of what I've learned back then.


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1539421
Posted Friday, February 7, 2014 3:52 PM


SSCrazy

SSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazySSCrazy

Group: General Forum Members
Last Login: Yesterday @ 12:56 PM
Points: 2,397, Visits: 2,936
Found the link to the presentation I mentioned in my previous post:
http://www.sqlbits.com/Sessions/Event7/oracle_for_sql_server_dbas


** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **
Post #1539425
Posted Sunday, February 9, 2014 4:07 PM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Today @ 2:23 AM
Points: 1,395, Visits: 6,614
Start with Oracle concepts. What is an instance, what are controlfiles, redologs, undotablespace, temptablespace, archivelogs.
You might consider Oracle Developer as free query tool
Basic troubleshooting tool for administration: sqlplus, couldn't get Enterprise Manager working most of the time.
Post #1539602
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse