Greatings,
I am running APEX 22.1 and trying to use the Quick SQL feature in SQL Workshop. I can specify the column name , column type and the default value. But even if I specify the data type as number, the default value is still a character:
Quick SQL:
timecards
tc_hours num /nn /default 0 /between 0 and 24
Generated SQL:
-- create tables
create table timecards (
id number generated by default on null as identity
constraint timecards_id_pk primary key,
tc_hours number default '0'
constraint timecards_tc_hours_bet
check (tc_hours between 0 and 24) not null
)
;
How can I set the default value to a number 0 and to the character literal '0'?
Regards,
Andrej