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!

How create editioning view without using sub query

LRKNov 23 2017 — edited Nov 28 2017

Hi Guys,

I have one table with message_ids, status columns. I need to process all new min message_ids (even if the min message_id having more than one) from my table.

So, here my requirement is the I need to create a editioning view (since editioning view not supports subquery) and pull all NEW status min message_id records only with out using MIN function.

Please suggest me on this.

Thanks in advance!

Regards,

Lakshman

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 26 2017

Added on Nov 23 2017

13 comments

816 views