I’m a very experienced IT professional but I’m having a hard time using SQL Navigator. In the past I used a program called Toad which I found very easy and intuitive to learn. All I need to do right now in SQL Navigator is to run a SQL script against a table to determine what records have been updated on certain dates. There appears to be no tutorial or help on how to do this simple operation. I cannot even see how to display a table or how to get a script entry window. I’ve hovered over every icon and expanded every menu. Can anyone help? Thanks. I’m using 5.5 and I’m not an Oracle expert.
The shortcuts [F12], to bring up the database navigator and [CTRL-T], to get a code editor should be of great help. From there on, you can work to get to know the (many) other features of SqlNav.
BTW: I feel your pain, having made the Toad->SqlNav conversion myself.
Open a session
-> File Menu -> New File -> SQL script ->write of script
I have exactly the opposite problem…when I have to work with TOAD I’m lost!
Regards and good luck
Hi Gazolba – welcome to SQLNav. I’ve actually had the opposite experience being a long time SQLNav user and trying to figure out Toad so I guess it’s all what you’re used to.
To answer your specific question, assuming you’ve been able to login to a database as the desired user, you should see a window (on the right by default I think) that shows a long list of items like Views, Tables, … . If you’re not seeing that view, try hitting the buttons at the bottom of the list on the right until you find the one with that view. If still not successful you can bring up an alternate view of the same data by hitting the F12 button.
Now, that, hopefully, you have that, expand the table view by clicking the + next to Tables and you should see a list of all tables. Click the desired table name and hit the F3 button or right click and choose browse. This will open a SQL editor window and place and execute a select statement. If you want to now add a where clause to filter the rows, you can simply type at the bottom of the query and hit F9 or the green arrow to execute it.