SitePoint Sponsor

User Tag List

Results 1 to 4 of 4
  1. #1
    _ silver trophy ses5909's Avatar
    Join Date
    Jul 2003
    Location
    NoVa
    Posts
    5,466
    Mentioned
    1 Post(s)
    Tagged
    1 Thread(s)

    how hard is oracle?

    I have experience with SQL Server, MySQL, and PostGres. There has recently been a job posting for a C# developer with an oracle backend. I am wondering how hard it would be to pick up Oracle? I know in the code, it is just a matter of using different connection libraries, etc. But should I have to run oracle reports or use a command line interface, is it a huge difference that I couldn't learn as I go?

    Thanks for any input you can provide.
    Sara

  2. #2
    Also available in Large Si's Avatar
    Join Date
    Sep 2002
    Location
    Walsall, UK
    Posts
    1,911
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I came into a workplace which were working solely on Oracle and I had no experience of it whatsoever. Fortunately, I did have mySQL and SQL Server experience and adapted to the lanugage quite quickly. Saying that though, I only really use it for the Intranet and web connections. I haven't done much with the reports and application building - thats another department (thankfully).
    Si
    Are you a Photoshop Jedi Master? Prove it!

    Is funky house your bag? You'll love this!

    Voice
    , eyes, ears, body and hands.


  3. #3
    SQL Consultant gold trophysilver trophybronze trophy
    r937's Avatar
    Join Date
    Jul 2002
    Location
    Toronto, Canada
    Posts
    39,273
    Mentioned
    60 Post(s)
    Tagged
    3 Thread(s)
    oracle sql is a substantially different from other sql products -- like, it's about seven times more complex

    for example, have a look at the syntax for CREATE TABLE --
    http://www.csee.umbc.edu/help/oracle.../ch4g.htm#9623

    writing efficient oracle queries is a lot harder than in other sql products

    you have to know way more database internals
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL
    "giving out my real stuffs"

  4. #4
    SitePoint Addict phpster's Avatar
    Join Date
    Feb 2005
    Location
    Toronto, Canada
    Posts
    374
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)
    I have to agree with r937. Oracle is a complex beast, and to get really good at it, you need to understand more than just the surface elements of sql and db design.

    One good way to get to know Oracle is to download it and install it locally(Note: its huge). Oracle is free for testing and development, but pricey when taken 'live'. Its a great, though complex, DBMS.

    There are a variety of good books and other sources on the net, include OTN which is Oracle support documentation and forums. Looking around on ebay and other places, you might also find and want to get the Oracle Course Materials for the DBAs as a reference guide.
    phpster

    I wish my computer would do what I want it to.
    Not what I tell it to do...


Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •