Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2004
    Posts
    205

    Unanswered: Equivalent for a Oracle query

    I need to know the SQL Server equivalent for the below Oracle query :

    select t.* from table(cast(c1.table1 as create_type_of_table))

    The above query will be used in PL/SQLs in ORACLE.

    What is the SQL Server equivalent for the above query ?

  2. #2
    Join Date
    Nov 2002
    Location
    Jersey
    Posts
    10,322
    I've NEVER seen that syntax in Oracle...what version?

    AND What does it do?

    We talking Nested tables? Doesn't look like the synatx though...

    Is it a Function?
    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
    Mar 2004
    Posts
    205
    It comes like this in PL/SQL :
    -----------------------------------------

    [...]
    for c2 in (select t.*
    from table(cast(c1.EXCESSKMCOST as LISTEXCESSKMCOST)) t)
    loop
    [...]

Posting Permissions

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