Skip to Main Content

SQL Developer for VS Code

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error on deleting/removing Content of NUMBER-Column

Bernd Mainz6 days ago

When trying to delete/remove the content of an column of data type “NUMBER” in table view under the "Data" tab, I got:

UPDATE "TEST" SET "NUMBER_COLUMN" =  WHERE ROWID = 'AAGa4wAAWAADWoPAAA' AND ORA_ROWSCN = 6413527752185
Invalid number format for variable '1'

Expected result:
Set to NULL as in “Oracle SQL Developer”

Comments
Post Details
Added 6 days ago
1 comment
37 views