473,320 Members | 1,930 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,320 software developers and data experts.

simple sequence question

1
Just want to know if an oracle sequence can be alpha-numeric.
May 29 '07 #1
3 2643
r035198x
13,262 8TB
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.
May 29 '07 #2
debasisdas
8,127 Expert 4TB
No

In oracle sequences can be only whole numbers.

Not even decimals.
May 30 '07 #3
chandu031
78 Expert
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!
May 30 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

2
by: Neal D. Becker | last post by:
What is an efficient way to find the first element in a sequence meeting some condition? For example, the first number > x in a list of numbers.
4
by: Daniel Frey | last post by:
Hello, Maybe you know howto. I want to have an element which takes a subelement. Depending on an attribute within this subelement, a second subelement may have different attributes allowed: ...
5
by: Eric E | last post by:
Hi, I have a question about sequences. I need a field to have values with no holes in the sequence. However, the values do not need to be in order. My users will draw a number or numbers from...
1
by: Lian Liming | last post by:
Hi all, I want to write a schema for the following example xml file: <Items> <ItemA>hehe</ItemB> <ItemB>haha</ItemB> </Items> So far as my knowledge about xml schema, I can write the...
4
by: Shawnk | last post by:
This post is intended to verify that true value semantics DO NOT EXIST for the Enum class (relative to boolean operations). If this is true then (thus and therefore) you can not design state...
3
by: Eric Lilja | last post by:
Hello, this is an xml-file with a nested DTD. It validates, test-1- with-dtd.xml: <?xml version="1.0" encoding="utf-8"?> <!DOCTYPE persons > <persons> <person name="Eric Lilja" /> </persons>
27
by: Paulo da Silva | last post by:
Hi! I was told in this NG that string is obsolet. I should use str methods. So, how do I join a list of strings delimited by a given char, let's say ','? Old way:
0
by: raysot | last post by:
I am a total nube with XML and am struggling with a simple XML import into SQL 2005. Lots of boring code to follow: (In short though, my basic question is this: What in the world are my tables...
1
by: astrogirl77 | last post by:
I'm new to C++ and am hoping to find help with coding a simple C program, am wanting to obtain code and functioning exe's. I code in an old version of Visual Basic 4.0, I have a simple app that...
2
by: madshov | last post by:
Hi, I'm pretty new to XSLT, so my question might be really simple: How do I get the value og 'subelement Sequence="1"', where 'element Id="NAD01"' is equal to 'MO' in the following XML? ......
0
by: DolphinDB | last post by:
The formulas of 101 quantitative trading alphas used by WorldQuant were presented in the paper 101 Formulaic Alphas. However, some formulas are complex, leading to challenges in calculation. Take...
0
by: DolphinDB | last post by:
Tired of spending countless mintues downsampling your data? Look no further! In this article, you’ll learn how to efficiently downsample 6.48 billion high-frequency records to 61 million...
0
by: ryjfgjl | last post by:
ExcelToDatabase: batch import excel into database automatically...
0
by: Vimpel783 | last post by:
Hello! Guys, I found this code on the Internet, but I need to modify it a little. It works well, the problem is this: Data is sent from only one cell, in this case B5, but it is necessary that data...
0
by: ArrayDB | last post by:
The error message I've encountered is; ERROR:root:Error generating model response: exception: access violation writing 0x0000000000005140, which seems to be indicative of an access violation...
1
by: PapaRatzi | last post by:
Hello, I am teaching myself MS Access forms design and Visual Basic. I've created a table to capture a list of Top 30 singles and forms to capture new entries. The final step is a form (unbound)...
0
by: CloudSolutions | last post by:
Introduction: For many beginners and individual users, requiring a credit card and email registration may pose a barrier when starting to use cloud servers. However, some cloud server providers now...
0
by: Defcon1945 | last post by:
I'm trying to learn Python using Pycharm but import shutil doesn't work
0
by: Shællîpôpï 09 | last post by:
If u are using a keypad phone, how do u turn on JavaScript, to access features like WhatsApp, Facebook, Instagram....

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.