Home » SQL & PL/SQL » SQL & PL/SQL » it is too urgent how to return the primarykey number as string (any version)
it is too urgent how to return the primarykey number as string [message #409533] Tue, 23 June 2009 01:20 Go to next message
ramu_plsql
Messages: 3
Registered: May 2007
Location: bangalore
Junior Member
hi

my problem is
i have a table like Country
primary key is CountryId starts with 1 and increment by 1 using
sequence

when i want to return the value to the front end i don't want to return the CountryId as number ,i want to return this Country Id as String like
Country1
Country2
Country3
..
Re: it is too urgent how to return the primarykey number as string [message #409536 is a reply to message #409533] Tue, 23 June 2009 01:24 Go to previous messageGo to next message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This has been asked many times.
Please search before posting you will save your time and don't waste ours repeating the same answers.
By the way what is the interest of "Country" if it is always "Country" apart from increasing EMC benefit?

Please read OraFAQ Forum Guide.

Regards
Michel
Re: it is too urgent how to return the primarykey number as string [message #409607 is a reply to message #409533] Tue, 23 June 2009 05:19 Go to previous message
ashoka_bl
Messages: 398
Registered: November 2006
Location: Bangalore
Senior Member

With the limited information you have provided and also it is very URGENT for you all that I can say is when you are returning the value from procedure/function concatenate the word "Country" along with your primary key country_id column

Regards,
Ashoka BL
Previous Topic: How to devide a string in to sub strings
Next Topic: BEFORE DDL Trigger
Goto Forum:
  


Current Time: Thu Dec 08 18:06:13 CST 2016

Total time taken to generate the page: 0.13748 seconds