Question : I used to a SQL guy and trying my hands on Oracle front. I am getting dynamic values […]
Tag: sequence
GRANT SELECT ON SEQUENCE succeeds, but to no effect?
Question : I am trying to grant select access to sequences from one user/role to another. There are no errors […]
How do I create a table with a column that uses a sequence?
Question : I have the following CREATE TABLE [MyTable] ( [ID] [bigint] PRIMARY KEY NOT NULL, [Title] [nvarchar](64) NOT NULL […]
Oracle – Sync Sequence nextval using CONNECT – side effects?
Question : DB Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Action After a data migration – from an […]
PostgreSQL SELECT primary key as “serial” or “bigserial”
Question : I’ve meshed together a way to determine what the data_type is as in the data_type you use in […]
Postgres sequence get last usage
Question : I have a database that has both sequenced correlated to table unique ids and “standalone” but having values. […]
Sequences Vs Count for auto-increment
Question : Can some one please tell me the exact difference between the following statements , INSERT INTO table1 VALUES […]
Create sequence based on the value of another column
Question : I have to create sequence numbers based on related user. Like: ╔════════════╦═════════════╦═══════════════════╗ ║ Row Id ║ User Id […]
Reset a sequence every year
Question : Every time a new row is added to the table below, I want the sequence (Import Permit No) […]
Reset all sequences so that they continue after max(id) + 1?
Question : It looks like I messed up a database migration and while all sequences are there, they would start […]