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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment