Skip to content

Keep calm and talk about Oracle.

Skip to content
  • Home

> 2020 > February

Month: February 2020

Sequential ID column without gap!

Published on: 2020-02-062020-02-06 by Mustafa Comment

Hello, A customer is asking to you generate order numbers one by one and without gap! What an unpleasant request isn’t it? if you are not familiar to databases then you might think that this request is logical but it is not. So your customer asked for this and you decided to develop your code […]

Search for:

Recent Posts

  • PLSQL and Flashback Data Archive Problems.
  • ORA-24244: invalid host or port for access control list (ACL) assignment
  • export import ACL & ORA-24244 error during import
  • Which Column has Changed in Every Row?
  • SQL Macro Part2 column_value = nvl(:param, column_value)

Recent Comments

  • Madhan Subbiah on Goodbye Log Triggers Welcome Flashback Data Archive
  • Mustafa on Goodbye Log Triggers Welcome Flashback Data Archive
  • Mustafa on Frequent and Fast Refresh Materialized Views has a Big Problem!
  • Mustafa on How to Get Your SID? USERENV vs V$MYSTAT!
  • oj on Goodbye Log Triggers Welcome Flashback Data Archive

Archives

  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • June 2018

Categories

  • 11g
  • 12c
  • 18c
  • 19c
  • 20c
  • 21c
  • Administration
  • Compression
  • Development
  • Materialized View
  • Performance
  • Security
  • SQL / PLSQL
  • Uncategorized
  • Undocumented
  • Useful Scripts

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org

Archives

  • January 2021
  • December 2020
  • November 2020
  • October 2020
  • September 2020
  • August 2020
  • July 2020
  • June 2020
  • May 2020
  • April 2020
  • March 2020
  • February 2020
  • January 2020
  • December 2019
  • July 2019
  • June 2019
  • May 2019
  • March 2019
  • February 2019
  • June 2018
© 2021 Mustafa KALAYCI. All rights reserved.