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

Question

Hi, 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 ?

Answer 1

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

Answer 2

Hi Cshah,

there is a setting in tools -> preferences -> Database -> advanced settings that allows you to reset the default display of NULL columns. If you set it to blank that will probably solve your issue.

Answer 3

Do you mean editing in the data tab? Just insert an 'empty' string, which in oracle is equal to null.

Set "Display null value as" to (null) in tools -> preferences -> Database -> advanced settings

create table ff (v VARCHAR2(1));

INSERT INTO FF VALUES ('1');

Select table and select data tab.

This shows

V
=
1

Now double click the value 1 and delete the 1. Commit generates this statement in log:

UPDATE "OSIVOLG"."FF" SET V =  WHERE ROWID = 'AAA+zcAAFAAF9rgAAA' AND ORA_ROWSCN = '77536476584'

Which is syntacticly not a valid SQL statement but data tab now shows.

V
======
(null)

Answer 4

What version are you using? I've got 1.5.4 right now and it works perfectly. Just click the value and hit delete, then commit.