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: Yesterday @ 8:20 AM
Points: 2,133, Visits: 3,405
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: Today @ 7:23 AM
Points: 2,224, Visits: 2,656
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: Today @ 7:23 AM
Points: 2,224, Visits: 2,656
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 @ 4:31 AM
Points: 1,386, Visits: 6,238
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