Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Digital Signing of Database Records
- Thread starter jch9
- Start date
You mean giving a record a unique identifier? Use a sequence (in this example for <col_id>):
create sequence <seq_name> increment by 1 start with 1;
when you insert:
insert into <table_name> (<col1>,...,<col_id>)
values (val1,...,<seq_name>.nextval))
If you need to reference the just by nextval created value use <seq_name>.currval.
Stefan
create sequence <seq_name> increment by 1 start with 1;
when you insert:
insert into <table_name> (<col1>,...,<col_id>)
values (val1,...,<seq_name>.nextval))
If you need to reference the just by nextval created value use <seq_name>.currval.
Stefan
- Thread starter
- #3
- Thread starter
- #4
- Status
Similar threads
