Click here to Skip to main content
       

Database

 
QuestionSQL Table Description [modified] PinmemberKevin Marois14-May-12 12:16 
AnswerRe: SQL Table Description Pinmembermark merrens14-May-12 12:31 
GeneralRe: SQL Table Description PinmemberKevin Marois14-May-12 12:33 
QuestionxBase question PinmemberDavidCrow14-May-12 10:05 
AnswerRe: xBase question PinmemberKevin Marois14-May-12 11:40 
QuestionRe: xBase question PinmemberDavidCrow14-May-12 17:22 
AnswerRe: xBase question PinmemberKevin Marois15-May-12 6:35 
QuestionRe: xBase question PinmemberDavidCrow15-May-12 6:55 
AnswerRe: xBase question [modified] PinmemberKevin Marois15-May-12 7:01 
GeneralRe: xBase question PinmemberDavidCrow15-May-12 7:30 
GeneralRe: xBase question PinmemberKevin Marois15-May-12 7:31 
GeneralRe: xBase question PinmemberDavidCrow15-May-12 7:37 
GeneralRe: xBase question PinmemberKevin Marois15-May-12 7:44 
QuestionOracle: Replace single occurrence of a character PinmemberLash2014-May-12 8:21 
Hi all,
 
How do you replace a single occurrence of a character in Oracle?
 
For example, how do I replace a single occurrence of the percent sign with a plus sign:
'my string a%a here' should be 'my string a+a here',
while 'my string a%%a here' should still remain as 'my string a%%a here'.
 
I know it can be done using REGEXP_REPLACE, but I'm not sure of which regular expression to use to make it replace only a single occurrence.
 
Any help will be appreciated.
 
Thanks
AnswerRe: Oracle: Replace single occurrence of a character Pinmemberrana ray15-May-12 0:56 
GeneralLinq to Sql Pinmembersindhuan14-May-12 1:10 
GeneralRe: Linq to Sql [modified] PinmemberKevin Marois14-May-12 11:45 
QuestionDoubt in a piece of code [Transact-SQL database audit]. [modified] PinmembervValkir13-May-12 21:54 
AnswerRe: Doubt in a piece of code [Transact-SQL database audit]. PinmemberMycroft Holmes13-May-12 22:36 
GeneralRe: Doubt in a piece of code [Transact-SQL database audit]. PinmembervValkir13-May-12 22:54 
AnswerRe: Doubt in a piece of code [Transact-SQL database audit]. Pinmemberdjj5514-May-12 4:08 
QuestionOracle Question: Split String into two PinmemberLash2011-May-12 5:57 
AnswerRe: Oracle Question: Split String into two PinmemberJörgen Andersson11-May-12 9:08 
AnswerRe: Oracle Question: Split String into two PinmemberLash2011-May-12 9:33 
GeneralRe: Oracle Question: Split String into two PinmemberJörgen Andersson11-May-12 9:47 
Questiontimestamp Pinmembervijaylumar11-May-12 1:39 
AnswerRe: timestamp PinmemberEddy Vluggen11-May-12 1:42 
QuestionWhat is database SQL query to display the name of the table only in to datagrid? PinmemberLAPEC10-May-12 1:04 
AnswerRe: What is database SQL query to display the name of the table only in to datagrid? PinmemberPIEBALDconsult10-May-12 3:16 
AnswerRe: What is database SQL query to display the name of the table only in to datagrid? Pinmembervvashishta10-May-12 4:17 
GeneralRe: What is database SQL query to display the name of the table only in to datagrid? PinmemberEddy Vluggen10-May-12 7:05 
Questionchoosing a database Pinmemberdavood_b8-May-12 1:19 
AnswerRe: choosing a database PinmemberPIEBALDconsult8-May-12 3:16 
QuestionRe: choosing a database PinmemberEddy Vluggen8-May-12 5:05 
GeneralRe: choosing a database PinmemberPIEBALDconsult8-May-12 18:42 
AnswerRe: choosing a database PinmemberEddy Vluggen8-May-12 5:08 
Questionusing xquery to populate a table variable in sql Pinmemberswjam6-May-12 4:34 
QuestionRead LFD(log ) file SQLserver 2008 Pinmemberjojoba20114-May-12 17:38 
AnswerRe: Read LFD(log ) file SQLserver 2008 PinmemberEddy Vluggen4-May-12 23:11 
QuestionRe: Read LFD(log ) file SQLserver 2008 Pinmemberjojoba20114-May-12 23:19 
AnswerRe: Read LFD(log ) file SQLserver 2008 PinmemberEddy Vluggen4-May-12 23:31 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pinmemberjojoba20115-May-12 20:31 
GeneralRe: Read LFD(log ) file SQLserver 2008 PinmemberMycroft Holmes5-May-12 23:00 
JokeRe: Read LFD(log ) file SQLserver 2008 PinmemberEddy Vluggen6-May-12 6:08 
AnswerRe: Read LFD(log ) file SQLserver 2008 PinmemberEddy Vluggen6-May-12 0:37 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pinmemberjojoba20116-May-12 23:30 
AnswerRe: Read LFD(log ) file SQLserver 2008 PinmemberEddy Vluggen7-May-12 0:30 
GeneralRe: Read LFD(log ) file SQLserver 2008 Pinmemberjojoba20117-May-12 17:37 
GeneralRe: Read LFD(log ) file SQLserver 2008 PinmemberJohnPayton7-May-12 18:10 
GeneralRe: Read LFD(log ) file SQLserver 2008 PinmemberEddy Vluggen8-May-12 0:17 

General General    News News    Suggestion Suggestion    Question Question    Bug Bug    Answer Answer    Joke Joke    Rant Rant    Admin Admin   

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.


Advertise | Privacy | Mobile
Web03 | 2.8.141015.1 | Last Updated 20 Oct 2014
Copyright © CodeProject, 1999-2014
All Rights Reserved. Terms of Service
Layout: fixed | fluid