Sql

Search

plsql find location of procedure

SELECT * 
FROM SYS.DBA_DEPENDENCIES 
WHERE  REFERENCED_NAME = '<NAME_OF_PKG_OR_PROC_FUNC>' AND 
REFERENCED_TYPE IN ('PACKAGE', 'PROCEDURE', 'FUNCTION');

Comment

PREVIOUS	NEXT

Code Example
Sql :: mysql remove tabs from string
Sql :: dump db only triggers mysql
Sql :: create table if not exists
Sql :: mysql even numbers
Sql :: insert into table using openquery
Sql :: reindex mssql table
Sql :: sql server get date of previous sunday
Sql :: how to insert same table data using mysql query
Sql :: h2 auto increment and unique
Sql :: how convert into in in sql query
Sql :: mysql workbench change default value
Sql :: change column in mysql
Sql :: install pymysql in python 3 in windows 7 v2.7.10 codes with pip
Sql :: description query in sql
Sql :: how to fetch data from database without last column
Sql :: oracle swap partition
Sql :: find duplicates in column sql
Sql :: mysql begin statement
Sql :: mysql update LAST_INSERT_ID()
Sql :: update select sql
Sql :: hyphen error in database mysql
Sql :: sql division operator
Sql :: right join
Sql :: sql except query
Sql :: install sql server management studio ubuntu
Sql :: table user postgres
Sql :: create view in oracle sql
Sql :: current month transactions in mysql
Sql :: varchar2 length in oracle
Sql :: rasa mysql connection custom actions example

Search

SQL

plsql find location of procedure

ADD CONTENT