Auto Increment Column - Sequence as Default Value in Oracle and mysql

Auto Increment Column  is a quite common requirement in the coding.Here are some of the ways to get that in MySQL and oracle database Auto Increment Column MySQL database The AUTO_INCREMENT attribute can be used to generate a unique identity for new rows Example CREATE TABLE test_lab ( id INT NOT NULL AUTO_INCREMENT, name CHAR(30) […]