CREATE TABLE is not working sql when adding invisible statement

Question

Please help to resolve the CREATE table issue, Missing right parenthesis bug when adding invisible statement, please check the below code and advise me.

create table can_table(
canno number(6,0) invisible generated by default as identity  
,canname nvarchar2(20)
);

Result

Error starting at line : 34 in command - create table can_table( canno number(6,0) invisible generated by default as identity
,canname nvarchar2(20))

Error report - ORA-00907: missing right parenthesis 00907. 00000 - "missing right parenthesis" *Cause:
*Action:

Answer 1

This works fine in livesql

create table can_table(
canno number(6,0) invisible generated by default as identity  
,canname nvarchar2(20)
);

INSERT into can_table values ('XXX');

SELECT * from can_table;

CANNAME
XXX


SELECT canno, canname from can_table;

CANNO    CANNAME
1    XXX