Mostly Making oracle easy, mostly:
Search for:
ThatJeffSmith
In SQL Developer

Search and Replace in Oracle SQL Developer Data Modeler

1 Min Read

This is one of the features I showcased in a webcast yesterday – looking for a particular column definition in your relational model? We make that easy in SQL Developer. And, after you find all of these columns, you can quickly change them, all in one fell swoop.

  1. Ctrl+F in a model to open the search.
  2. Toggle to ‘Advanced.’
  3. Set your search area and criteria.
    4. You can search on just about any property for a column (or table or entity, or anything else for that matter!)
    You can search on just about any property for a column (or table or entity, or anything else for that matter!)
  4. Hit the ‘Search’ button.
  5. Review the results, save as a report, or change up the properties across the search results…

    6. These are the properties that are COMMON across the search result items that you can change.
    These are the properties that are COMMON across the search result items that you can change.

    5 Minute Video Demo

thatjeffsmith
Author

I'm a Distinguished Product Manager at Oracle. My mission is to help you and your company be more efficient with our database tools.

Related Posts

3 Comments

  1. Avatar
    Rivka Reply

    How to find and replace in Database objects?
    I know there is Find database objects, and there is find and replace in the editor
    but is there no way to find and replace a certain ‘abcd’ to ‘efgh’ in all procedures ?

  2. Avatar
    julesdba Reply

    Hi, can I search by entering more than one pattern to search in longer string s? I.e. for example search for “nam def 01” in what is “name_definition_000001”

    Thanks!

Write A Comment