Answer: Depending on your release a
sequence many or may not be associated directly with your
table column. For example, in all releases of Oracle,
as sequence is associated with a table column only at insert
time. As we see below, the table does not "know" that
a sequence has been defined for the column, the developer
must know the sequence name and use it at table rows insert
time:
Tip! In
order to loosely associate a sequence with a table column
you can make the sequence the same name as the table and
data column name, suffixed with "_seq". For example, a
sequence on a customer table's cust_id_column could be "customer_cust_id_seq".
That way, you can find the sequences for the table column in
the dba_sequences view.
In Oracle 12c and beyond, you can associate a sequence
directly with a table: In this example, we associate
the sequence with the table, directly in the create table
statement.