If I have a table like this: CREATE TABLE EXAMPLE ( E_ID BIGINT GENERATED BY DEFAULT AS IDENTITY PRIMARY KEY );
How do I add a record to it, getting an automatically assigned ID? For example, in PostgreSQL, I'd write: INSERT INTO EXAMPLE(E_ID) VALUES (DEFAULT); I know such a table doesn't seem very useful, but still... Thanks!