Replace first Letter in a field Oracle

Posted by Stanley on Stack Overflow See other posts from Stack Overflow or by Stanley
Published on 2012-11-06T16:36:28Z Indexed on 2012/11/06 17:00 UTC
Read the original article Hit count: 171

Filed under:

oracle11g

Hi Guys I have this Table My Original table

I need to replace the First Letter in ACCT_NAME with the First Name of ACCT_SHORT_NAME. Records like the Higliighted(RAFFMAN) should not be changed. I have tried:

select acct_name, ACCT_SHORT_NAME,replace(acct_name, substr(acct_name, 1, 1),      ACCT_SHORT_NAME)
 from tbaadm.gam where schm_type = 'TDA' and rcre_user_id  = 'SYSTEM' and substr(acct_name,2,1) = ' '

I am getting:

Table after select

This means that am Picking the whole value in ACCT_SHORT_NAME. WHat is the best way to do what am trying to do?

Related posts about oracle11g

???? Oracle11g ????????? No.2 - v$database.CURRENT_SCN

as seen on Oracle Blogs - Search for 'Oracle Blogs'
«????Oracle 11g ???????»???????????,?11.2.0.3.0?????: select current_scn from v$database union all select current_scn from v$database; ??????????SCN,??????11.2.0.1.0???????????SCN?????? ??,????11.2.0.1.0????,11.2.0.3.0????X$KCCDI(V$DATABASE?????,??CURRENT_SCN??)??,?????????SCN? … >>> More
Cognos 8.3 and Oracle11g

as seen on Server Fault - Search for 'Server Fault'
When i place ojdbc5.jar in the c8\webapps\p2pd\WEB-INF\lib directory... i receive the error below. And yes the content store is on an oracle 11g RAC database. I am running Oracle11g Client. Cognos version is 8.3 SP4. [Content Manager database connection] 1. [ ERROR ] The database connection failed… >>> More
Cognos 8.3 and Oracle11g

as seen on Server Fault - Search for 'Server Fault'
When i place ojdbc5.jar in the c8\webapps\p2pd\WEB-INF\lib directory... i receive the error below. And yes the content store is on an oracle 11g RAC database. I am running Oracle11g Client. Cognos version is 8.3 SP4. [Content Manager database connection] 1. [ ERROR ] The database connection failed… >>> More
how to display databases in oracle11g using sqlplus

as seen on Stack Overflow - Search for 'Stack Overflow'
in mysql its show databases; but how to show the available databases in oracle. can someone help >>> More
INS-40719 error when Install Oracle RAC?

as seen on Server Fault - Search for 'Server Fault'
I'm tying to (learn how to) install Oracle RAC 11g on CentOS 6 all went OK so far but I get INS-40719 Error message regarding SCAN Name I do not have DNS server and I'm not going to try to use it on this setup I add this line to /etc/hosts 192.168.244.100 rac-cluster then used "rac-cluster" as… >>> More

Developer IT

Replace first Letter in a field Oracle - Developer IT

Replace first Letter in a field Oracle

oracle11g

Related posts about oracle11g

???? Oracle11g ????????? No.2 - v$database.CURRENT_SCN

Cognos 8.3 and Oracle11g

Cognos 8.3 and Oracle11g

how to display databases in oracle11g using sqlplus

INS-40719 error when Install Oracle RAC?

Categories cloud