Page 1 of 2 12 LastLast
Results 1 to 15 of 17

Thread: Oracle is...

  1. #1
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Oracle is...

    This may sound totally stupid, but:

    Is Oracle a language (basically) or a database app that is the basis for application front-ends?

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  2. #2
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Brantford, Ontario, Canada
    Posts
    2,391
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oracle is...

    Oracle is a database base upon which many applications are written. Think MS Access... but a WHOLE LOT larger.

    Note: Access can access Oracle tables.
    Christopher Baldrey

  3. #3
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,577
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Oracle is...

    Oracle Corp. is a software comany that now has several databases and applications. Originally, the product called Oracle was a relational database. Then Oracle Corp. built various applications on top of the database. In recent years they have been on an acquisition binge.

    Joe
    Joe

  4. #4
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Oracle is...

    Joe/Chris:

    Oracle "speaks" SQL (as does Access), yes?

    The one thing I DO like about Oracle is that it operate in both a Windows and a linux environment.

    Although the language used for programming may be the same, the actual command steps would differ from Windows to linux, because the underlying engine is different, yes?

    But the structure et al of any database/app built would be similar, wouldn't it? So I would obviously need to be aware of linux syntax etc., but the "IDE" end would be the same, yes?

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  5. #5
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oracle is...

    Hi Chuck

    The syntax of Oracle SQL is slightly different as it varies on the two platforms. I was originally trained in Oracle SQL and I have been able to translate that syntax to the Microsoft version. Like any two platforms there will be a difference in syntaxial grammar but they are quintessentially the same.

    I am not quite sure what you mean by the "IDE being the same" as I would suggest that they are not the same as Oracle databases do not always act with the same constraint types as MS SQL DB's. As for database design, the power is in the table design and constraint setting and key types, the UI equally as important.....So in conclusion, same pudding, very different flavour
    Jerry

  6. #6
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Oracle is...

    Jerry:

    >>
    was originally trained in Oracle SQL and I have been able to translate that syntax to the Microsoft version. Like any two platforms there will be a difference in syntaxial grammar but they are quintessentially the same.
    <<

    I guess what I'm trying to see is, as I start sticking my toe into the linux pond, if what I (try to) learn how to do in Windows will be applicable in linux -- not not identical, but rather let me feel that at least I'm not picking up new book!

    I did some work in SQL years back, and am hoping that it will serve as a base. I am enthusiastic that Oracle works on both platforms, and would like to be able to "flip back and forth" between the two. Since I am just getting started in linux as well, it would be nice to be able to apply what I may learn in each o/s to see how they each perform.

    Chuck
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  7. #7
    Platinum Lounger
    Join Date
    Feb 2002
    Location
    A Magic Forest in Deepest, Darkest Kent
    Posts
    5,681
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Oracle is...

    Do not panic young sir, 'tis like riding a tricycle, <img src=/S/grin.gif border=0 alt=grin width=15 height=15>

    if not

    SELECT book, isbn, syntax

    FROM library

    WHERE syntax ='oracle'

    I have found that broadly when I use Oracle syntax for aliases, Access and MS SQL will "translate", sometime verbosely, but it still sees it.

    Now go off and clean that bike off <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Jerry

  8. #8
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,577
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Oracle is...

    Yes, Oracle speaks SQL. But as Jerry pointed out the devil is in the details. Every database vendor seems to have implemented extensions to SQL. If you stick as closely as possible to vanilla SQL you should be OK

    The underlying engine is somewhat different on each OS platform. The language used for programming may or may not be the same. If you mean SQL, it will be mostly the same.

    Joe
    Joe

  9. #9
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Oracle is...

    <hr>I am enthusiastic that Oracle works on both platforms, and would like to be able to "flip back and forth" between the two.<hr>
    Perhaps I am confused, but isn't Oracle a multi-thousand-dollar large-enterprise database server? I'm not sure how you would be using it, but "flipping back and forth" doesn't really seem very likely.

  10. #10
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Oracle is...

    Jefferson:

    I can't possibly say you're confused... 'cause I am.

    This is just the type of thing I cannot seem to get info on.

    There is a *free* version of Oracle, so you (I) can take a look without too much trouble, As for having to put out thousands, I'm not at all sure.

    Surely I don't need anything complex enough to serve a major corporate environment. I was and am just trying to (maybe) find one program that would allow me to do app development in either linux Familiarity of this type would seem to be a great asset.

    For instance: right now I have someone that has worked in Windows for years, and is looking at switching to linux. So, thinks I, if I was familiar with Oracle, then I would be able to help implement simpler apps as replacements for some of the Windows utilities they now use.

    In addition, there are a few database-type apps that I'm looking into that it would be great to develop in a way that they could work on both platforms.

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  11. #11
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Oracle is...

    Joe:

    >>
    Yes, Oracle speaks SQL. But as Jerry pointed out the devil is in the details. Every database vendor seems to have implemented extensions to SQL. If you stick as closely as possible to vanilla SQL you should be OK.
    <<

    THAT'S true of all products I think. Trying to make themselves unique and all that. The SQL part I think is pretty clear... the next question being using what IDE or development tools could/would I make the best transition?

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  12. #12
    Super Moderator jscher2000's Avatar
    Join Date
    Feb 2001
    Location
    Silicon Valley, USA
    Posts
    23,112
    Thanks
    5
    Thanked 93 Times in 89 Posts

    Re: Oracle is...

    Wow, I missed the news about the free Express Edition. They even included a little application development tool for web-based applications. Plus guides to developing applications on top of the Oracle database in various different languages (such as PHP, which will run on the Apache web server on both Windows and Linux). I'm amazed.

    http://www.oracle.com/technology/products/...e/xe/index.html

    I'm not sure whether it would be useful for replacing Windows utilities, but for database applications, it certainly seems worth investigating.

  13. #13
    Uranium Lounger CWBillow's Avatar
    Join Date
    Jul 2002
    Location
    Las Vegas, NV USA
    Posts
    6,371
    Thanks
    78
    Thanked 12 Times in 11 Posts

    Re: Oracle is...

    Don't say I never did nothin' for ya, Jefferson.

    Regards,
    Chuck Billow
    -------------------------------------------------
    "Good judgment comes from experience, and experience - well, that comes from poor judgment."

    ~ A(lan) A(lexander) Milne (1882-1956)- "House at Pooh Corner"

  14. #14
    Silver Lounger
    Join Date
    Jan 2001
    Location
    Brantford, Ontario, Canada
    Posts
    2,391
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Oracle is...

    Nice find guys... I'll have to check this out as we're an Oracle shop here, and I get to dabble a little with the databases.

    Nothing like trying to break things from the inside <img src=/S/evilgrin.gif border=0 alt=evilgrin width=15 height=15>
    Christopher Baldrey

  15. #15
    Administrator
    Join Date
    Mar 2001
    Location
    St Louis, Missouri, USA
    Posts
    23,577
    Thanks
    5
    Thanked 1,057 Times in 926 Posts

    Re: Oracle is...

    Try using the IDE with the express version of Oracle. And be careful as the SQL part is not always clear. Sometimes vendor extensions are not always labelled as such and can come back and bite you in the butt.

    Joe
    Joe

Page 1 of 2 12 LastLast

Posting Permissions

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