jump to navigation

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:

https://peoplesofttipster.com/sql-developer/

Advertisements

Comments

1. Pat - February 18, 2009

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

2. Kiran - April 30, 2009

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 🙂

3. Simon Lassam - May 29, 2009

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.


Sorry comments are closed for this entry

%d bloggers like this: