Search and Replace in Oracle SQL Developer Data Modeler

thatjeffsmith SQL Developer 1 Comment

Tell Others About This Story:

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!)

  5. Hit the ‘Search’ button.
  6. Review the results, save as a report, or change up the properties across the search results…
  7. 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

    Tell Others About This Story:

Comments 1

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

Leave a Reply

Your email address will not be published. Required fields are marked *