Oracle 18c

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.

CREATE TABLE Books 
(
    Id int generated always as identity,
    Title VARCHAR(50) NOT NULL,
    PRIMARY KEY(Id)
);
INSERT INTO Books (Id, Title)
VALUES
(3, 'The Catcher in the Rye');
ORA-32795: cannot insert into a generated always identity column

begin
INSERT INTO Books (Title) VALUES ('Nine Stories');
INSERT INTO Books (Title) VALUES ('The Great Gatsby');
INSERT INTO Books (Title) VALUES ('Tender id the Night');
INSERT INTO Books (Title) VALUES ('Pride and Prejudice');
INSERT INTO Books (Title) VALUES ('Professional ASP.NET 4.5 in C# and VB');
end;
/
1 rows affected

select* from Books;


ID
TITLE


1
Nine Stories

2
The Great Gatsby

3
Tender id the Night

4
Pride and Prejudice

5
Professional ASP.NET 4.5 in C# and VB

ID	TITLE
1	Nine Stories
2	The Great Gatsby
3	Tender id the Night
4	Pride and Prejudice
5	Professional ASP.NET 4.5 in C# and VB