Khiêm Trần Blogs
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
‹
›
Home
View web version
No comments:
Post a Comment