Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2003
    Posts
    1

    Unanswered: PL/SQL & Recordsets

    You can use PL/SQL functions in SQL statements and you can return recordsets with PL/SQL. Is there any way to combine the two in the FROM clause of a SQL statement?

    function foo(a in number);

    select *
    from table1, foo(3)
    where table1.field1 = foo.field1

    Thanks.

  2. #2
    Join Date
    Jul 2001
    Location
    Germany
    Posts
    189

    Thumbs up Unnested collection types

    Hello,

    use unnested collection types to create a nested table and a view that accesses the unnested collection types.

    Then you can use the view to access your function.

    If you need more help see the docu or contact me at www.alligatorsql.com

    Hope that helps ?

    Manfred Peter
    (Alligator Company GmbH)
    http://www.alligatorsql.com

Posting Permissions

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