Ability to edit table using SQL Worksheet with it condition, like TOAD feature.
EDIT user_table WHERE user_name = :userName;
will display table result with matching data and we can modify its data directly on the result.
You can actually do this already in the schema browser - just click on the filter button while on the data tab. Please let us know if that is sufficient for what you need.
Thanks for the very fast reply! Never expected to be that fast!
Yes it works. Is there a trick so that I can save different multiple
filter for same table and run them according to what I need? Opening a new tab may help, but it will definitely clutter the workspace.
Usually in TOAD I save the sql worksheet that contain all EDIT
statement and open them again when needed. Different filter launched
just with executing the required line.
Sorry if I look like comparing TOra with TOAD,
but it just because I really like TOra over TOAD now. It definitely better than SQLDeveloper.
Thanks for this great software and sorry for my bad English.