User uses Create option to open Table Editor window and creates a table with a Date column having default value of SYSDATE. The Generate SQL icon is used to generate the Create statement. Created statement encloses SYSDATE word with single quotes and running this Create statement results in the following error: "ORA-01858: a non-numeric character was found where a numeric was expected"
You need to be signed in and under a current maintenance contract to view premium knowledge articles.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center