Thursday, March 12, 2015

Get autoId from sequence in Oracle when insert data

CREATE SEQUENCE <sequence_name> START WITH 1 INCREMENT BY 1;

INSERT INTO Customers (AutoId, CustomerName, Country)
SELECT <sequence_name>.NEXTVAL, SupplierName, Country FROM Suppliers

No comments:

Post a Comment