Toad World® Forums

Create Table with Default value Sysdate


#1

Hi,

I Have SQL Navigator 6.2.1 with Oracle 10.2

My Problem:

Create a new table with Navigators Interface

DB Navigator -> Tables -> Right Click -> Create
Tablename test
New Column FirstDate: Type Date Default Sysdate

if I click On “Generate Sql for Changes”

I get the following imho Illegal sql Code:

CREATE TABLE TEST
(
FirstDate DATE DEFAULT ‘sysdate’
)
/

If I Save to Database I get (the expected):
Error: ORA-01858: a non-numeric character was found where a numeric was expected

I fear its a bug in the Navigator. I have it testet with 6.2 and 6.2.1

Bye

Holger

CreateTable.jpeg


#2

Hi Holger,

Thanks for reporting this bug to us. We’re aware of this issue and it will be addressed in the next release.

Gwen