Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

which creating TableFunction method is better?

Aketi JyuuzouNov 2 2011 — edited Nov 14 2011
There are 2 method creating TableFunction.
My question is which is better ?:|

I think method1 is better B-)
Because when export/import each schema to other schema method2 causes "ORA-02304: invalid object identifier literal"
448115

But I often see method2 only :-(
http://psoug.org/reference/pipelined.html
http://www.oracle-base.com/articles/9i/PipelinedTableFunctions9i.php
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 12 2011
Added on Nov 2 2011
6 comments
523 views