Home » SQL & PL/SQL » SQL & PL/SQL » Storing Alphanumeric values
Storing Alphanumeric values [message #190693] Thu, 31 August 2006 15:53 Go to next message
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 Go to previous message
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
Previous Topic: Archiving of Table data
Next Topic: Bulk Collect & Pipelined Table Function - Confusion Building
Goto Forum:
  


Current Time: Fri Dec 02 12:42:22 CST 2016

Total time taken to generate the page: 0.08446 seconds