| Re: Complex sequence [message #21574] |
Wed, 14 August 2002 09:54 |
scott
Messages: 73
Registered: September 1999
|
Member |
|
|
Weird. I tried that an it's not working for me:
SQL> insert into pad_test (test_id) values (lpad(my_sequence.nextval, 4,'0'));
1 row created.
SQL> select * from pad_test;
TEST_ID TEST_OBJEC
---------- ----------
2 test1
3 test2
3 test2
4 test7
5 test7
4 test9a
5 test6a
6 test3a
7 test67
8 test234
9 test_dsfg
TEST_ID TEST_OBJEC
---------- ----------
10 test_3434
11
12
14 rows selected.
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
