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!

Table Editor, Data Type: DATE, Default: SYSDATE. ORA-01858: A non-numeric character was found instead of a numeric character.

DataProcessing29 hours ago

v25.4, Windows 11.
Using Table Editor for new or edit.
For a DATE column, Enter the Default: SYSDATE - without quotes
When APPLY button is clicked an exception occurs. The default value is wrapped in quotes as shown.

Comments
Post Details
Added 29 hours ago
1 comment
21 views