The update data dialog presents a graphical interface to update data in the table by generating and update query. The following is a snapshow of the update dialog in action :
The update dialog tries to convert the data to the column type to the best of it's ability by using a prepared statement; however for certain data types (eg: date), the user will have to type in the corresponding database function which converts the specified string to adate value (for example toDate('12/12/1999').
The update query dialog can also handle updates to clob/blob columns. If you want to update the data in any of these columns from a file location, you can click on the browse button ('...') and select the appropriate file you want replace the contents of your column. The Update Query will in that case create a prepared statement as shown in the following diagram :
As shown in the following diagram, the binary column of table is being updated by the contents of the file selected by tehr user with the specified condition for all rows whose ID is 25.
Note that the update data dialog can only be used to update columns within a single table. For more complex queries, you should update using the query panel.