CREATE TABLE statement is used to create table objects in database.You can create tables with different column data types.It is possible to add CONSTRAINTS like primary key ,foreign key etc while creating the table or can be added after the table creation
Primary key is a type of constraint used in Oracle tables.A primary key is used to uniquely identify each row in a table.A primary key can consist of one or more fields on a table. When more than one fields are used as a primary key, the key is called a composite key.
Savepoints In SQL Transactions. – Oracle SAVEPOINT.
The intermediate markers within the context of a transaction called savepoints. Savepoints divide a long transaction into smaller parts.