Home » SQL & PL/SQL » SQL & PL/SQL » Auto Sequence number for specific subinventory transactions
Auto Sequence number for specific subinventory transactions [message #683869] Sat, 27 February 2021 01:21 Go to next message
smk08
Messages: 1
Registered: February 2021
Junior Member
Respected All,
I want to generate a auto sequence number when user perform subinventory transactions for a specific subinventory.
Re: Auto Sequence number for specific subinventory transactions [message #683870 is a reply to message #683869] Sat, 27 February 2021 02:16 Go to previous message
Michel Cadot
Messages: 67817
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Welcome to the forum.
Please read the OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.

Also always post your Oracle version, with 4 decimals (query v$version), as often solution depends on it.

You have to be more specific, your question is not clear.
However it seems a trigger is what you need.

With any SQL or PL/SQL question, please, Post a working Test case: create table (including all constraints) and insert statements along with the result you want with these data then we will be able work with your table and data. Explain with words and sentences the rules that lead to this result.

Previous Topic: call sql server procedure from oracle
Next Topic: remove comments from all_source output
Goto Forum:
  


Current Time: Fri Apr 23 04:19:45 CDT 2021