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 strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Auto Next Number
Sem I will appreciate if can give me some exampel This is what i want to achive Matter No : 000033 next no 000034 should be generated automatically. If value in the column is null then 00001 should be generated. thank you- mohiz
- Post #3
- Forum: Oracle: All versions
-
Auto Next Number
Here is the code i used to get the desire result. The only problem is if there is null value then it does not generate the next number. declare matter_no number(2); begin select max(to_number(substr(matter_code,1,2))) + 1 into :matter.matter_code from matter where...- mohiz
- Thread
- Replies: 3
- Forum: Oracle: All versions
-
Multipul Tab Pages
how can I create a multi tab pages on a single block envirement when a tab is clicked the related information with the tab should execute just like master detail form. advise will be appreciated- mohiz
- Thread
- Replies: 1
- Forum: Oracle: Enterprise Developer Suite
