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 Senior Principal Product Manager at Oracle for Oracle SQL Developer. My mission is to help you and your company be more efficient with our database tools.

Related Posts

1 Comment

  1. 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