DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Function in FROM statement? How?

  1. #1
    Join Date
    Oct 2001
    Posts
    2

    Question

    I listen than subj is supported. How can I write such function?
    It's need for use as this:
    SELECT * FROM MY_FUNC(ARG1, ARG2, ...)

    PLEASE HELP!!!

  2. #2
    Join Date
    Sep 2001
    Location
    Australia
    Posts
    18
    If the function MY_FUNC returns an object table then you can do it.

    Check out the following article from Oracle Magazine. It should give the information that you need....

    http://www.oracle.com/oramag/webcolu...y_dynamic.html

    I hope that helps.

Posting Permissions

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


Click Here to Expand Forum to Full Width