Results 1 to 11 of 11

Thread: Types of SQL

  1. #1
    Join Date
    Oct 2003
    Location
    CLEVELAND
    Posts
    10

    Unanswered: Types of SQL

    Can anyone clarify for me which types of SQL are used for which
    applications. i.e.: Transact SQL. MySQL, PL SQL, SQL-Access. And can any
    of these interact.

    Thanks

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    When's the exam?
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  3. #3
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    all those languages can be used for all applications

    the limitation is not which application you want to build, but which commercial database product you have

    if you have microsoft sql server, you'll pretty much be restricted to using transact-sql, if you have oracle, you pretty much have to stick to pl/sql, and so on

    microsoft access can act as a front end for other databases, but then, you're not really using the database part of access for that, you're using the front end part, so it's not really fair to say that the languages interact

    the only time you could safely say the languages interact is if you restrict yourself to core ansi standard statements, and don't use any proprietary functions like sql server's CONVERT(CHAR(10),DATEFLD,120) or mysql's CONCAT_WS('/',domain,folder,page)
    rudy.ca | @rudydotca
    Buy my SitePoint book: Simply SQL

  4. #4
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    ORACLE

    TO_CHAR..TO_DATE

    SELECT * FROM myTable1 a, myTable2 b
    WHERE a.id = b.id (+)

    CONNECT BY

    DB2 OS/390

    CREATE TABLESPACE
    CREATE STOGROUP

    MS ACCESS

    SELECT FIRST(Col1), LAST(Col1)
    (How do they do that btw?)

    SQL Server

    READTEXT
    WRITETEXT
    UPDATTEXT
    TXTPTR
    (painful)
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  5. #5
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    that oracle CONNECT BY is the bomb

    another one i like is sybase's LIST() function, also available in mysql 4.1 as the GROUP_CONCAT() function, to produce a comma-separated list of column values within a group when you use GROUP BY

    hey, i don't mind hijacking a thread, do you?


  6. #6
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    The school bell rang, and he had to get back...

    I wish SQL Server had CONNECT BY....

    What a painful thing dealing with n levels of hierarchies...
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  7. #7
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    yeah, i understand, but the way i handle it, nobody hardly every wants to show (much less knows of a good way to display on a report or screen) more than a few levels at a time, so i just use, say, a 5-way left outer self-join to show the current level plus 4 levels down... then if further depth is desired, the user clicks on one of the lower level links, and this runs the 5-way self join from that id down...

    i have yet to have any application where i absolutely had to code something recursive to n levels...

  8. #8
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Man have I had my share....


    Then add "dimesions" to it...and the roll it up....

    It wasn't called warehousing back then...and they needed to apply updates...

    So if the lowest child had charges, they were rolled up to all the parents for a particular service, for a particular month...

    aaaaaaaaagggggggghhhhhhhhhhhhhhh
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  9. #9
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    ouch, updates up the tree?

    i too started data warehousing before the name actually caught on

    we called them "summary tables"



    i started using sql with a product called QMF with DB2 in 1987

    right from the get go, QMF had this neat command, DRAW

    you would say DRAW TABLENAME and it would pull all the column names out of the directory and format an actual SELECT statement in the query window, so all you had to do was delete columns you didn't want, and add your own WHERE clause, and press F6 to run it...

  10. #10
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    Originally posted by r937
    ouch, updates up the tree?

    i too started data warehousing before the name actually caught on

    we called them "summary tables"



    i started using sql with a product called QMF with DB2 in 1987

    right from the get go, QMF had this neat command, DRAW

    you would say DRAW TABLENAME and it would pull all the column names out of the directory and format an actual SELECT statement in the query window, so all you had to do was delete columns you didn't want, and add your own WHERE clause, and press F6 to run it...
    1987....hmmm was that version 2.3? Cut my teeth there...

    DRAW is cool...just never liked the

    -- tablename

    after the columns, or the way they slammed as much as they could onto every row...

    AND do you know how HARD it is (to this day) to get a developer to do and EXPLAIN?

    And it was even more fun when a developer would do a select in qmf, edit and toggle out to his jcl, submit and come running, screaming that someone was blocking him...

    RES DATA

    ooohhhh


    [SQL Server board community]
    What the hell are they talking about
    [/SQL Server board community]
    Brett
    8-)

    It's a Great Day for America everybody!

    dbforums Yak CorralRadio 'Rita
    dbForums Member List
    I'm Good Once as I ever was

    The physical order of data in a database has no meaning.

  11. #11
    Join Date
    Apr 2002
    Location
    Toronto, Canada
    Posts
    20,002
    Originally posted by Brett Kaiser

    What the hell are they talking about

Posting Permissions

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