Skip to content

Commit

Permalink
fix one error in ParenthesisGroup0.pls
Browse files Browse the repository at this point in the history
  • Loading branch information
李家奥 authored and 李家奥 committed Apr 21, 2022
1 parent 2667b42 commit 17ff1b7
Showing 1 changed file with 1 addition and 1 deletion.
Original file line number Diff line number Diff line change
Expand Up @@ -3,7 +3,7 @@ CREATE OR REPLACE PROCEDURE EXAMPLE_PROCEDURE IS
CURSOR c_example IS
SELECT a.owner, u.object_name, p.aggregate
FROM (USER_OBJECTS u) INNER JOIN (ALL_OBJECTS a) ON
u.object_name = a.object_name AND u.object_type = a.object_type AND u.object_id = a.object_id)
u.object_name = a.object_name AND u.object_type = a.object_type AND u.object_id = a.object_id
INNER JOIN (ALL_PROCEDURES p) ON
p.owner = a.owner AND p.object_name = a.object_name AND p.object_type = a.object_type
WHERE a.owner = USER;
Expand Down

0 comments on commit 17ff1b7

Please sign in to comment.