| Storing Alphanumeric values [message #190693] |
Thu, 31 August 2006 15:53  |
lbabil
Messages: 2
Registered: August 2006
|
Junior Member |
|
|
Hi All,
I have a table called PROVIDER
with collum PROVIDER_CODE VARCHAR2(3)which is also the primary key for the table,
I want to store values like P1, P2 in this collumn.
Unfortunately whether I use the manual insert(run sql) or use the interface to insert rows, the values get stored as 201,221 etc.
Can somebody please help me.
Thanks
|
|
|
|
| Re: Storing Alphanumeric values [message #190694 is a reply to message #190693] |
Thu, 31 August 2006 17:00  |
lbabil
Messages: 2
Registered: August 2006
|
Junior Member |
|
|
|
Alright, Somebody replied to this post on another site.It turned out to be a trigger which changed the values(dont know why and how)but after disabling it the values are getting stored correctly
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
