Query to search all packages for table and/or column

by

You can do this:

select *
from user_source
where upper(text) like upper('%SOMETEXT%');

Alternatively, SQL Developer has a built-in report to do this under:

View > Reports > Data Dictionary Reports > PLSQL > Search Source Code

The 11G docs for USER_SOURCE are here

More Related Contents:

  1. Printing the value of a variable in SQL Developer
  2. PL/SQL, how to escape single quote in a string?
  3. Passing an array of data as an input parameter to an Oracle procedure
  4. Oracle Equivalent to MySQL INSERT IGNORE?
  5. null vs empty string in Oracle [duplicate]
  6. Convert comma separated string to array in PL/SQL
  7. UTL_FILE.FOPEN() procedure not accepting path for directory?
  8. Oracle stored procedure with parameters for IN clause
  9. PL/SQL ORA-01422: exact fetch returns more than requested number of rows
  10. NLS_NUMERIC_CHARACTERS setting for decimal
  11. Formatting DATE in oracle
  12. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  13. Oracle: How to find out if there is a transaction pending?
  14. Best practice for pagination in Oracle?
  15. check if “it’s a number” function in Oracle
  16. Sql*plus always returns exit code 0?
  17. ORA-06508: PL/SQL: could not find program unit being called
  18. ORA-12170: TNS:Connect timeout occurred
  19. How to create and use temporary table in oracle stored procedure?
  20. SQL*Plus how to accept text variable from prompt?
  21. How to find difference b/w TIMESTAMP format values in Oracle?
  22. if (select count(column) from table) > 0 then
  23. How to find out when an Oracle table was updated the last time
  24. Using Alias in query resulting in “command not properly ended”
  25. NLS_LANG setting for JDBC thin driver?
  26. How can I describe a table in Oracle without using the DESCRIBE command?
  27. Is it possible to kill a single query in oracle without killing the session?
  28. Difference between LockModeType Jpa
  29. No more data to read from socket
  30. How can I issue a single command from the command line through sql plus?

Leave a Comment