Alex Rivera | Logout

how to set a null value to a field in a table using oracle sql developer tool?

Asked 2009-09-11T07:57:03.827
11

Oracle SQL Developer allows you to update field values directly to the table without needing to write a sql script. However it doesnt allow you to set a null value for a field? the update script that gets generated is below : UPDATE "TABLE" SET field_required = 'null' WHERE ROWID = 'AAAnnZAAFAAAGMfAAC' AND ORA_ROWSCN = '14465324'

Any idea how to set a null value to a field in the table without writing an update statement ?

Edit
Report

1 Answer

0

Some tools use <ctrl+0> to enter a NULL value.

answered 2009-09-11T08:14:46.817

Your Answer