Skip to Main Content

SQL Developer

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!

Expand SQL Statement includes generated VPD policy in where clause

Jeffrey KempApr 16 2019 — edited Apr 17 2019

The "Expand SQL Statement" feature can be quite useful to refactor code, e.g. when "select * from..." is used in PL/SQL.

However, it suggests an expansion that includes the where clause generated by a VPD policy, which is not appropriate. Unless the developer takes action to remove this part of the query they will potentially introduce unnecessary (and in some cases, incorrect) code (especially if the VPD policy is dynamic). Example shown:

Capture.PNG

Ideally SQL Developer should generate a SQL expansion that does not include any VPD policy.

Comments
Post Details
Added on Apr 16 2019
6 comments
1,592 views