simple sequence question

[rehlen]

Just want to know if an oracle sequence can be alpha-numeric.

[r035198x]

Just want to know if an oracle sequence can be alpha-numeric.

Hi and welcome to TSDN. Since your question is more relevant in the Oracle forum, I will move it there.

[debasisdas]

No

In oracle sequences can be only whole numbers.

Not even decimals.

[chandu031]

Just want to know if an oracle sequence can be alpha-numeric.

Hi rehlen,

Even I had the same opinion that you cant have Alphanumeric sequences. But guess what? I googled a little and found this interesting link:

Alphanumeric sequences?

Here the writer talks about creating alpha numeric sequences using DECODE logic. I found this article very interesting and hope you will find it useful. I am starting to feel nothing is impossible in a database:)

Cheers!