Query to search all packages for table and/or column

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

Related Contents:

  1. How to uninstall / completely remove Oracle 11g (client)?
  2. Determining location of relevant tnsnames.ora file
  3. Printing the value of a variable in SQL Developer
  4. What is the difference between varchar and varchar2 in Oracle?
  5. ORA-28040: No matching authentication protocol exception
  6. How to get records randomly from the oracle database?
  7. PL/SQL – Use “List” Variable in Where In Clause
  8. TNS-12505: TNS:listener does not currently know of SID given in connect descriptor
  9. Oracle Equivalent to MySQL INSERT IGNORE?
  10. ORA-00054: resource busy and acquire with NOWAIT specified or timeout expired
  11. null vs empty string in Oracle [duplicate]
  12. Oracle Search all tables all columns for string [duplicate]
  13. Convert timestamp datatype into unix timestamp Oracle
  14. When or Why to use a “SET DEFINE OFF” in Oracle Database
  15. Oracle trigger after insert or delete
  16. How do I calculate tables size in Oracle
  17. UTL_FILE.FOPEN() procedure not accepting path for directory?
  18. Oracle stored procedure with parameters for IN clause
  19. error: ORA-65096: invalid common user or role name in oracle
  20. How to avoid variable substitution in Oracle SQL Developer
  21. Convert comma separated string to array in PL/SQL
  22. Error : ORA-01704: string literal too long
  23. How do you get nicely formatted results from an Oracle procedure that returns a reference cursor?
  24. What is the minimal setup required to deploy a .NET application with Oracle client 11?
  25. Sql*plus always returns exit code 0?
  26. check if “it’s a number” function in Oracle
  27. Auto Increment for Oracle
  28. Dynamically pivoting a table Oracle
  29. Spool Command: Do not output SQL statement to file
  30. Convert epoch to date in sqlplus / Oracle
  31. Oracle’s default date format is YYYY-MM-DD, WHY?
  32. URL string format for connecting to Oracle database with JDBC
  33. NLS_LANG setting for JDBC thin driver?
  34. How to return a resultset / cursor from a Oracle PL/SQL anonymous block that executes Dynamic SQL?
  35. How to use a table type in a SELECT FROM statement?
  36. Speed up to_sql() when writing Pandas DataFrame to Oracle database using SqlAlchemy and cx_Oracle
  37. How do I turn off Oracle password expiration?
  38. Default Schema in Oracle Connection URL
  39. ORACLE IIF Statement
  40. How can I describe a table in Oracle without using the DESCRIBE command?
  41. how to replace multiple strings together in Oracle
  42. HIbernate issue with Oracle Trigger for generating id from a sequence
  43. Reading clob line by line with pl\sql
  44. Spring boot Hibernate error “Access to DialectResolutionInfo cannot be null when ‘hibernate.dialect’ not set” when working with multiple data sources
  45. Trigger to enforce M-M relationship
  46. How to generate a GUID in Oracle?
  47. Functions vs procedures in Oracle
  48. How can I issue a single command from the command line through sql plus?
  49. ORA-01830: date format picture ends before converting entire input string / Select sum where date query
  50. error: ORA-65096: invalid common user or role name in Oracle database

Leave a Comment