SQL Daily (@sqldaily) 's Twitter Profile
SQL Daily

@sqldaily

Daily Oracle SQL tips from the Oracle Developer Advocates for SQL

ID: 3001841930

linkhttp://blogs.oracle.com/sql calendar_today29-01-2015 17:45:15

2,2K Tweet

25,25K Followers

4 Following

SQL Daily (@sqldaily) 's Twitter Profile Photo
SQL Daily
@sqldaily

3 months ago

Define identity columns with col INT GENERATED AS IDENTITY This autogenerates numbers for col GENERATED ALWAYS => you can't insert your own values GENERATED BY DEFAULT => the database will assign values if you don't provide one Each table can only have one identity column

Define identity columns with col INT GENERATED AS IDENTITY This autogenerates numbers for col GENERATED ALWAYS => you can't insert your own values GENERATED BY DEFAULT => the database will assign values if you don't provide one Each table can only have one identity column