how can user_DEPENDENCIES read from the procedure
- by Moudiz
If I run this query :
SELECT DISTINCT U.REFERENCED_NAME, U.REFERENCED_TYPE
FROM USER_DEPENDENCIES U
where U.name IN('P_CREATE_T')
It will give me :
U.REFERENCED_NAME | U.REFERENCED_TYPE
random_name_table | table
If I drop this table random_name_table :
drop table random_name_table
and I run the dependecie query It will give me this:
U.REFERENCED_NAME | U.REFERENCED_TYPE
BIN$6WfJh8MWWGngQ3ATqMDOpQ==$0 | table
I know the result is related to recycle bin, But what I am asking is there a way that shows the table even if its droped ? I mean shouldnt the depency query read from the procedure and not from the database ? If not is there a query that reads from the procedure and not from database ?
Edit
ok I will make it clear :
my question USER_DEPENDENCIES read from the procedure or the database ?
My second question does the recycle bin always shows ? I mean is there times where the result of the recylebin disapear ?
