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!

Union vs Union All

Saeed HassanpourJan 14 2016 — edited Jan 16 2016

Dear,

Some years ago, I read the article about "Union and Union all"  that explained

Union is => DISTINCT Q1 WITH DISTINCT(NOT NULL Q2)

Union All  is => Q1 SUM (NOT NULL Q2)

So if you agree about above sentences and spatially these words "NOT NULL", please tell me about your viewpoint.

Regards,

Saeed.

Comments

InoL

If you change anything that is shared, you push it to the subscribers in your development APEX Builder. In your case: when you change the authorization scheme in the master app, push it to the subscribing apps in dev, export all apps (or app components) and import these in the other environments (test and production).
So there is no need to go into APEX Builder in test and production to push these subscriptions. These environments shouldn't have builder access anyway.

Joe R

Inol,
Thank you for replying.
This approach is what I initially described to them (the client). They responded with not wanting to have to deploy all the applications (10 in total) when a change was made to an Authorization Scheme. So I was wondering if there was another approach that could be added to their automated deployment process, like a command line or similar, that could be used?
Thanks,
Joe

InoL
Answer

like a command line or similar
AFAIK: no. APEX Builder pushes the changes to the subscribers. I don't think there is a public API for that.

Marked as Answer by Joe R · Feb 18 2022
Joe R

Inol,
Thank you for confirming there's no other process than to go into the Scheme and Publish the updates.
I'll let them know. Honestly, I also asked how often they would make changes and they said not very often. So they had a concern that "remembering" that the updated Scheme would need to be published. I suggested we can put a comment in the Comments section on all the Schemes created to "remind" them what the process is. Now if they don't see or read it...well.
Thanks,
Joe

1 - 4
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on Feb 13 2016
Added on Jan 14 2016
17 comments
3,744 views