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!

Query on Partition

simon87Sep 22 2015 — edited Sep 22 2015

Hi, guys


Help me, please.


When we need to do a query on partition, we execute the next statement:

select * from parition_table parition (parition_name)


But, When the query is in a pkg, would it be necessary to go updating the name of the partition in the pkg to retrieve the most current data partition?


Or what other way, to do query on partition, when this is in a pkg.



Thanks a lot


Simón

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 20 2015
Added on Sep 22 2015
7 comments
2,955 views