Fallstricke Kapitel 10

Veröffentlicht: von

Create Sequence: The default „START WITH 1 INCREMENT BY 1“ is the reason why the first given number has the value 2 — Which value has NEXTVAL if an insert statement fails? CREATE TABLE SEQ_TEST ( id NUMBER NOT NULL, description VARCHAR2(25) NOT NULL ); CREATE SEQUENCE SEQ_TEST_ID; SELECT SEQUENCE_NAME, INCREMENT_BY, LAST_NUMBER FROM USER_SEQUENCES WHERE…

Archiv nach Tag: Samstag, Oktober 2, 2010