Section 1.3, "Migrating User Settings from a Previous Release" Section 1.2, "Installing and Starting SQL Developer" Section 1.1, "SQL Developer System Recommendations"
This chapter contains the following major sections: Please read the information in this chapter before you install Oracle SQL Developer. If you plan to use SQL Developer as part of the Oracle Database release 11 installation, see the Oracle Database installation documentation. But I digress.This guide assumes that you plan to download the SQL Developer kit (.zip) file and install it as a freestanding tool. I do it all the time 🙂 And I drive the developers nuts trying to do things with the tools they were never designed to do. Sometimes thinking outside the box actually works!ĭon’t be afraid to tackle a problem from a weird angle, or re-purpose your tools. Working on your HR project and want to look at your employee objects? Do a column search for your column ID/key. You could take advantage of this knowledge and use the Find Database Object panel as a substitute connection tree or schema browser. I bet you use common column names, or codes, throughout your tables.
It will even search through your PL/SQL code!įinding too much? Be sure to toggle off the ‘%’ wildcard check box before doing a search. I know it seems very simple, but I get asked this question a LOT. The search results are listed below and clicking on an object automatically opens it! I simply need to type my search string and the context (in this case I want it to search EVERYTHING), and hit enter. Let’s say I want to find my ‘beer’ objects. It makes finding ‘stuff’ in your database so much easier. It’s a good bit down the screen, so I don’t blame you if you haven’t seen it before. You can access this panel from the ‘ View‘ menu. Hmmm, what’s this ‘ Find Database Object‘ thing over here…sounds like a search mechanism of some sort?
But still, it’d be nice if my favorite database tool could help me out a bit. I was tempted to throw in another Dora the Explorer Map reference here, but I came to my senses.Having trouble finding something? Maybe you’re just getting older? I know I am.
0 kommentar(er)
