SQL Developer Hints and Tips February 17, 2009
Posted by Duncan in SQL.trackback
I’ve put together an overview of Oracle’s SQL Developer product – at least the main features from a PeopleSoft developer’s perspective – plus some productivity tips and configuration tweaks to make it a better user experience.
It’s probably a bit big to be a blog post so I’ve put it on a tab at the top, and at this link:
Comments
Sorry comments are closed for this entry
The PeopleSoft Tipster Blog 
Hey good article. Thanks.
One that I use “all” the time is the TABLE Filter.
Right button click on TABLES
select APPLY FILTER
On the right hand side of the screen, click on the radio button MATCH ANY. ( Match all has not worked for me )
Then enter a table table. For ex: T012%,etc, click on OK and bingo!
Thanks again
Great article..I have been using SQL developer for so long and I did not even realize why I did not do this.Thanks a lot 🙂
Alot of People where I work are using SQL-Developer (it’s free so the client won’t buy Toad), and don’t realise that you can edit the data. Again, use the Connections Tab to access the Tables in a Database. In the main window, once the Table is open, select the Data tab, and from here you can Insert, Delete and Update the data, then either Commit or Rollback as required. It’s worth remembering that in a session, each “Tab” on to the same database uses the same connection, so you can’t run multiple queries simultaneously, but you can edit the data in one, the run a SQL to check the results before committing.