Oracle SQL Developer 4 table data tab initial filter

Question

Is there a way to setup in Oracle SQL Developer an initial filter for table Data view tab or switch off automatic data load?

I work with a team of analysts whom start analysis by entering that tab and yet keep avoiding manual writing sql. Initial data load last over half minute and pressing cancel on loading dialog with progress bar makes that tab useless.

Just want to make life of these guys bit easier.

Answer 1

The answer is 'no' - filters aren't currently persisted across sessions of SQL Developer.

I would suggest Pravin's answer regarding views OR

Create an APEX front end application for data entry for your business users, it's a perfect use-case for APEX.

There is a request on the feature exchange, check this out.

Answer 2

Why not create a view on these tables with initial filter ? Instead of table team can query these views. You can limit columns also which team needs.