Schema Browser?

[Ubu]

I've been trying out PL/SQL Developer for a couple of days now and so far, so good. In fact, in many ways I'm very impressed.

I've used Quest Toad a fair amount in the past, and while I don't need most of it's features, it has one called Schema Browser which is tremendously useful for exploring and understanding a database. This is particularly good for me, as I'm an instructor and I like to use it in my classes.

I can see that Developer has a tree of DB objects down the left hand side, and while the drag-n-drop is kind of useful, it falls far short of the full fledged Schema Browser. I'm wondering if this functionality (or something like it) is in there somewhere that I can't find?

Thanks in advance for any suggestions.

 

[byskov]

If you right-click on the objects in the tree you have access to the same information as in toad.

If you go to preferences -> User Interface -> Browser, you can set double click action to "view spec and body" which means that when you double click a table in the tree-view you'll get more or less the same information as in toad.

But if you really want to show your students the database, not only schemas but also tablespaces, sessions, datafiles and what not, then I would recommend that you use the Oracle Enterprise Manager Console.

Good luck!