I am new to Oracle DB and I am using Oracle SQL Developer (Ver 3.0.02) to query the DB.
I wanted to explicitly set one column to null?
How do I do that in the SQL Developer GUI?
Previously in MSSQL, clicking CTRL+0 will explicitly set the value to null.
How about Oracle SQL Developer?
Thanks
Best Answer
You'll have to write the SQL DML yourself explicitly. i.e.
Once it has completed you'll need to commit your updates
If you only want to set certain records to NULL use a WHERE clause in your UPDATE statement.
As your original question is pretty vague I hope this covers what you want.