#313 Edit Table Data With Condition

open
nobody
None
5
2012-12-13
2008-11-21
Aby
No

Ability to edit table using SQL Worksheet with it condition, like TOAD feature.
For example:

EDIT user_table WHERE user_name = :userName;

will display table result with matching data and we can modify its data directly on the result.

Discussion

  • 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.

     
  • Aby
    Aby
    2008-11-22

    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.

     
  • Aby
    Aby
    2008-11-22

    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.