Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
autogenerated number in a format
Priyank Khare
Sep 14 2012 5:30 AM
1.7k
Reply
hello.
i've a table in which country code and city code exists. there is a hotel code field as well.
i wants to generate autonumber including country and city code.
for example:-
"IND-DEL-0001"
1ST PART IS COUNTRY CODE 2ND PART IS CITY CODE. 3RD PART IS AUTOGENERATED AND STARTING FROM "0001".
please suggest code to achieve this.
thank you.
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
How to pass object of a class to stored procedure(in oracle)?
Assign task