Skip to main content

New answers tagged

1 vote

How to Make Queries on a DATETIME Column Efficient If My Primary Query Pattern is an Hour?

SQL Server and Oracle are different products. SET IDENTITY_INSERT table_name OFF is SQL Server syntax which has no equivalent on Oracle , the most similar might be generated by default as identity ...
Ergest Basha's user avatar
  • 3,945
-1 votes

Can one dictate the order of generated values when adding a new BIGSERIAL column to a table?

Assuming you have an existing key in the table to sort (either a date, existing key, etc), this will add a sequence to the table in order of your choosing: -- Add a primary key. SERIAL works (IDENTITY ...
Stickley's user avatar

Top 50 recent answers are included