Search
 
SCRIPT & CODE EXAMPLE
 

SQL

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 
ADD CONTENT
Topic
Content
Source link
Name
9+3 =