Home » SQL & PL/SQL » SQL & PL/SQL » Conversion
Conversion [message #585265] Thu, 23 May 2013 04:40 Go to next message
DUTTA@TARUN
Messages: 29
Registered: May 2013
Location: INDIA
Junior Member
how i convert 1 to ngrp in sql?


[EDITED by LF: fixed topic title typo; was "conersion"]

[Updated on: Thu, 23 May 2013 04:45] by Moderator

Report message to a moderator

Re: conersion [message #585266 is a reply to message #585265] Thu, 23 May 2013 04:44 Go to previous messageGo to next message
Littlefoot
Messages: 19678
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What is "ngrp"?
Re: Conversion [message #585267 is a reply to message #585265] Thu, 23 May 2013 05:08 Go to previous message
pablolee
Messages: 2655
Registered: May 2007
Location: Scotland
Senior Member
DUTTA@TARUN wrote on Thu, 23 May 2013 10:40
how i convert 1 to ngrp in sql?


SELECT x, REPLACE(x, '1', 'ngrp')
FROM (select '1' x from dual)


Wink

[Updated on: Thu, 23 May 2013 05:08]

Report message to a moderator

Previous Topic: ORA-06550: (2 Merged)
Next Topic: Procedure which converts salary
Goto Forum:
  


Current Time: Mon Oct 20 07:31:36 CDT 2014

Total time taken to generate the page: 0.10040 seconds