在oracle中查找并替换字符串(Find and Replace a strings in oracle)
我有一个字符串,其中包含如下数据:
'ID,MASTER_ID,DATA_SOURCE_ID,DATA_SOURCE_NAME,CHILD_COUNT,CHILD_COUNT_TEXT,PARENT_OR_CHILD,RECORD_TYPE,FULL_NAME_LNF,FULL_NAME_FNF,FIRST_NAME,LAST_NAME,PREFIX,SUFFIX,MIDDLE,TITLE,NAME_OF_ORGANIZATION,NAME_OF_BUSINESS,TYPE_OF_ENTITY,ADDRESS,CITY,STATE,PROVINCE,POSTAL_CODE,COUNTRY,POSTAL_ADDRESS_TYPE,PHONE_AREA_CODE,PHONE_NUMBER,PHONE_COUNTRY_CODE,PHONE,PHONE_TYPE,EMAIL_ADDRESS,URL,HCP_SPECIALTY,HCP_TYPE,HCP_SUBTYPE,RECIPIENT_STATUS,COVERED_RECIPIENT_FLAG,RELATIONSHIP_TO_CR,LAST_MODIFIED_BY,LAST_MODIFIED_DATE,PRIMARY_LICENSE_STATE_AR,PRIMARY_LICENSE_NUM_AR,DEA_REG_NUM_AR,NPI_NUM_AR,UPIN_AR,TAX_PAYER_ID_AR,PRIMARY_LICENSE_STATE_CR,PRIMARY_LICENSE_NUM_CR,DEA_REG_NUM_CR,NPI_NUM_CR,UPIN_CR,DEA_NUMBER,NPI,UPIN,TIN,TAX_PAYER_ID_CR,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,ATTRIBUTE21,ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,ATTRIBUTE29,ATTRIBUTE30,SOURCE_REGION_CODE,SOURCE_SYSTEM_CODE,REC_INVALID_FLAG,REVISION_FLAG,IS_ACTIVE,PROCESS_STATE,RECIPIENT_CATEGORY01,RECIPIENT_CATEGORY02,RECIPIENT_CATEGORY03,RECIPIENT_CATEGORY04,RECIPIENT_CATEGORY05,RECIPIENT_CATEGORY06,RECIPIENT_CATEGORY07,RECIPIENT_CATEGORY08,RECIPIENT_CATEGORY09,RECIPIENT_CATEGORY10,RECIPIENT_CATEGORY11,RECIPIENT_CATEGORY12,RECIPIENT_CATEGORY13,RECIPIENT_CATEGORY14,RECIPIENT_CATEGORY15,RECIPIENT_CATEGORY16,RECIPIENT_CATEGORY17,RECIPIENT_CATEGORY18,RECIPIENT_CATEGORY19,RECIPIENT_CATEGORY20,RECIPIENT_CATEGORY21,RECIPIENT_CATEGORY22,RECIPIENT_CATEGORY23,RECIPIENT_CATEGORY24,RECIPIENT_CATEGORY25,RECIPIENT_CATEGORY26,RECIPIENT_CATEGORY27,RECIPIENT_CATEGORY28,RECIPIENT_CATEGORY29,RECIPIENT_CATEGORY30,IS_PICKABLE,IS_GOLDEN,PRIMARY_LICENSE_NUM,PRIMARY_LICENSE_EFFECTIVE,PRIMARY_LICENSE_EXPIRES,TERTIARY_LICENSE_EFFECTIVE,TERTIARY_LICENSE_EXPIRES,SECONDARY_LICENSE_EFFECTIVE,SECONDARY_LICENSE_EXPIRES,SECONDARY_LICENSE_NUM,TERTIARY_LICENSE_NUM,ADDRESS2,PHONE_AREA_CODE2,PHONE_NUMBER2,PHONE_COUNTRY_CODE2,PHONE_TYPE2,TERRITORY,PRIMARY_AFFILIATION,PRIMARY_AFFILIATION_STATE,REQUEST_WF_STATE,IS_EDIT_LOCKED,SOURCE_SYSTEM_RECIPIENT_ID,CREATED_BY,CREATION_DATE,APPROVER_COMMENTS,SECONDARY_LICENSE_STATE,PRIMARY_LICENSE_STATE,NPI_DATA,STATE_DATA,DEA_DATA,RPPS,FINESS,SIREN_NUMBER,DPC'
任何人都可以告诉我如何只找到以下值
DATA_SOURCE_ID, LAST_MODIFIED_BY, LAST_MODIFIED_DATE, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30,
然后用以下字符串替换它们
'L.DATA_SOURCE_ID,L.LAST_MODIFIED_BY,L.LAST_MODIFIED_DATE,L.ATTRIBUTE13,L.ATTRIBUTE14,L.ATTRIBUTE15,L.ATTRIBUTE16,L.ATTRIBUTE17,L.ATTRIBUTE18,L.ATTRIBUTE19,L.ATTRIBUTE20,L.ATTRIBUTE21,L.ATTRIBUTE22,L.ATTRIBUTE23,L.ATTRIBUTE24,L.ATTRIBUTE25,L.ATTRIBUTE26,L.ATTRIBUTE27,L.ATTRIBUTE28,L.ATTRIBUTE29,L.ATTRIBUTE30,'
I have a string which contains data as follows:
'ID,MASTER_ID,DATA_SOURCE_ID,DATA_SOURCE_NAME,CHILD_COUNT,CHILD_COUNT_TEXT,PARENT_OR_CHILD,RECORD_TYPE,FULL_NAME_LNF,FULL_NAME_FNF,FIRST_NAME,LAST_NAME,PREFIX,SUFFIX,MIDDLE,TITLE,NAME_OF_ORGANIZATION,NAME_OF_BUSINESS,TYPE_OF_ENTITY,ADDRESS,CITY,STATE,PROVINCE,POSTAL_CODE,COUNTRY,POSTAL_ADDRESS_TYPE,PHONE_AREA_CODE,PHONE_NUMBER,PHONE_COUNTRY_CODE,PHONE,PHONE_TYPE,EMAIL_ADDRESS,URL,HCP_SPECIALTY,HCP_TYPE,HCP_SUBTYPE,RECIPIENT_STATUS,COVERED_RECIPIENT_FLAG,RELATIONSHIP_TO_CR,LAST_MODIFIED_BY,LAST_MODIFIED_DATE,PRIMARY_LICENSE_STATE_AR,PRIMARY_LICENSE_NUM_AR,DEA_REG_NUM_AR,NPI_NUM_AR,UPIN_AR,TAX_PAYER_ID_AR,PRIMARY_LICENSE_STATE_CR,PRIMARY_LICENSE_NUM_CR,DEA_REG_NUM_CR,NPI_NUM_CR,UPIN_CR,DEA_NUMBER,NPI,UPIN,TIN,TAX_PAYER_ID_CR,ATTRIBUTE13,ATTRIBUTE14,ATTRIBUTE15,ATTRIBUTE16,ATTRIBUTE17,ATTRIBUTE18,ATTRIBUTE19,ATTRIBUTE20,ATTRIBUTE21,ATTRIBUTE22,ATTRIBUTE23,ATTRIBUTE24,ATTRIBUTE25,ATTRIBUTE26,ATTRIBUTE27,ATTRIBUTE28,ATTRIBUTE29,ATTRIBUTE30,SOURCE_REGION_CODE,SOURCE_SYSTEM_CODE,REC_INVALID_FLAG,REVISION_FLAG,IS_ACTIVE,PROCESS_STATE,RECIPIENT_CATEGORY01,RECIPIENT_CATEGORY02,RECIPIENT_CATEGORY03,RECIPIENT_CATEGORY04,RECIPIENT_CATEGORY05,RECIPIENT_CATEGORY06,RECIPIENT_CATEGORY07,RECIPIENT_CATEGORY08,RECIPIENT_CATEGORY09,RECIPIENT_CATEGORY10,RECIPIENT_CATEGORY11,RECIPIENT_CATEGORY12,RECIPIENT_CATEGORY13,RECIPIENT_CATEGORY14,RECIPIENT_CATEGORY15,RECIPIENT_CATEGORY16,RECIPIENT_CATEGORY17,RECIPIENT_CATEGORY18,RECIPIENT_CATEGORY19,RECIPIENT_CATEGORY20,RECIPIENT_CATEGORY21,RECIPIENT_CATEGORY22,RECIPIENT_CATEGORY23,RECIPIENT_CATEGORY24,RECIPIENT_CATEGORY25,RECIPIENT_CATEGORY26,RECIPIENT_CATEGORY27,RECIPIENT_CATEGORY28,RECIPIENT_CATEGORY29,RECIPIENT_CATEGORY30,IS_PICKABLE,IS_GOLDEN,PRIMARY_LICENSE_NUM,PRIMARY_LICENSE_EFFECTIVE,PRIMARY_LICENSE_EXPIRES,TERTIARY_LICENSE_EFFECTIVE,TERTIARY_LICENSE_EXPIRES,SECONDARY_LICENSE_EFFECTIVE,SECONDARY_LICENSE_EXPIRES,SECONDARY_LICENSE_NUM,TERTIARY_LICENSE_NUM,ADDRESS2,PHONE_AREA_CODE2,PHONE_NUMBER2,PHONE_COUNTRY_CODE2,PHONE_TYPE2,TERRITORY,PRIMARY_AFFILIATION,PRIMARY_AFFILIATION_STATE,REQUEST_WF_STATE,IS_EDIT_LOCKED,SOURCE_SYSTEM_RECIPIENT_ID,CREATED_BY,CREATION_DATE,APPROVER_COMMENTS,SECONDARY_LICENSE_STATE,PRIMARY_LICENSE_STATE,NPI_DATA,STATE_DATA,DEA_DATA,RPPS,FINESS,SIREN_NUMBER,DPC'
Can anybody tell me how to find only the following values
DATA_SOURCE_ID, LAST_MODIFIED_BY, LAST_MODIFIED_DATE, ATTRIBUTE13, ATTRIBUTE14, ATTRIBUTE15, ATTRIBUTE16, ATTRIBUTE17, ATTRIBUTE18, ATTRIBUTE19, ATTRIBUTE20, ATTRIBUTE21, ATTRIBUTE22, ATTRIBUTE23, ATTRIBUTE24, ATTRIBUTE25, ATTRIBUTE26, ATTRIBUTE27, ATTRIBUTE28, ATTRIBUTE29, ATTRIBUTE30,
And then replace them with following strings
'L.DATA_SOURCE_ID,L.LAST_MODIFIED_BY,L.LAST_MODIFIED_DATE,L.ATTRIBUTE13,L.ATTRIBUTE14,L.ATTRIBUTE15,L.ATTRIBUTE16,L.ATTRIBUTE17,L.ATTRIBUTE18,L.ATTRIBUTE19,L.ATTRIBUTE20,L.ATTRIBUTE21,L.ATTRIBUTE22,L.ATTRIBUTE23,L.ATTRIBUTE24,L.ATTRIBUTE25,L.ATTRIBUTE26,L.ATTRIBUTE27,L.ATTRIBUTE28,L.ATTRIBUTE29,L.ATTRIBUTE30,'
原文:https://stackoverflow.com/questions/33144627
最满意答案
如果使用Result意味着您的方法将阻止。 但不推荐它,因为它会导致死锁。 使用Result属性或Wait()时需要小心。
当您使用异步方法时,我建议您声明异步方法,然后使用await调用该函数。
public async Task Method() { HttpResponseMessage myResponse = await myClient.PostAsync(theUri, theContent); }
如果您不能将该方法声明为异步,则需要使用异步方法。 我建议你使用这个类在同步方法中转换异步方法: 我如何同步运行异步Task <T>方法?
If you use Result means that your method will block. But it isn't recommended because it will cause a deadlock. You need to be careful when you use Result property or Wait().
When you use async method I recommend you que you declare async method and you call the function with await.
public async Task Method() { HttpResponseMessage myResponse = await myClient.PostAsync(theUri, theContent); }
If you can't declare the method as async and you need to use a async method. I recommend you that use this class for convert async method in sync method: How would I run an async Task<T> method synchronously?
相关问答
更多-
这是回答了一些答案, 无法找到如何使用HttpContent以及在这个博客文章 。 总而言之,您不能直接设置HttpContent一个实例,因为它是一个抽象类 。 您需要根据您的需要使用从其派生的类。 最有可能的StringContent ,它允许您在构造函数中设置响应的字符串值,编码和媒体类型。 请参阅: http : //msdn.microsoft.com/en-us/library/system.net.http.stringcontent.aspx This is answered in some ...
-
C#Metro HttpClient未在PostAsync上接收cookie(C# Metro HttpClient not receiving cookie on PostAsync)[2023-12-02]
使用FormUrlEncodedContent而不是StringContent与string.Format 。 您的代码无法正确转义用户名和密码。 HttpContent content = new FormUrlEncodedContent(new[] { new KeyValuePair("username", username), new KeyValuePair ("password", password), ne ... -
你需要await对CreateCellphone的调用,否则什么都不会发生,因为response任务几乎会立即被处理掉。 不确定你是否可以在Xamarin中使你的按钮单击方法async ,但我会尝试这样做: private async void RegisterButtonOnClick(object sender, EventArgs e) //^^^^^ //Add this { //snip await CreateCellphone(_url, cell); ...
-
如何在Windows Phone 8中同步调用异步方法(How to call asynchronous method synchronously in Windows Phone 8)[2021-11-20]
首先避免使用异步void方法,因为你不能轻易等待它的完成。 相反,返回Task ,在async方法内,您不需要做一些特殊的事情来返回Task 。 编译器为您完成所有工作。 您需要等待对HttpClient.PostAsync的调用,这应该足以保持UI响应。 private static async Task CallService(System.Uri uri) { using (HttpClient client = new HttpClient()) { client.D ... -
您不需要await client.PostAsync(webUri, i_formData)因为在调用返回后您不会对结果执行任何操作,您只需返回Task 。 改变这个; public static Task
BasicRequest(MultipartFormDataContent i_formData) { Uri webUri = new Uri("https://www.bing.com"); HttpClient client = new ... -
好吧,我们已经通过GitHub上的DNX团队解决了这个问题。 我正在创建一个线索,说明此链接上的问题。 这就是我所做的: 我在CentOS服务器上运行了一个PHP(NuSOAP)API。 我发送了这个显示PHP头信息的命令。 [root @ su soaptest] #curl -I http://application.com/api/service.php HTTP / 1.1 200 OK日期:星期二,07 Jun 2016 01:21:20 GMT服务器:Apache / 2.4.6(CentOS) ...
-
尝试使用下面的代码可能会有效,首先尝试在Google Rest Client或Post Man上运行此代码 HttpRequestMessage httpRequest = new HttpRequestMessage(); httpRequest.Method = HttpMethod.Post; httpRequest.RequestUri = URL; httpRequest.Content = formC ...
-
如果使用Result意味着您的方法将阻止。 但不推荐它,因为它会导致死锁。 使用Result属性或Wait()时需要小心。 当您使用异步方法时,我建议您声明异步方法,然后使用await调用该函数。 public async Task Method() { HttpResponseMessage myResponse = await myClient.PostAsync(theUri, theContent); } 如果您不能将该方法声明为异步,则需要使用异步方法。 我建议你使用这个类在同步方法中转 ...
-
如何使用C#HttpClient PostAsync显示上传进度(How to display upload progress using C# HttpClient PostAsync)[2022-10-27]
尝试这样的事情: 我遇到了同样的问题。 我通过实现自定义HttpContent修复它。 我使用此对象来跟踪上传进度的百分比,您可以添加事件并收听它。 您应该自定义SerializeToStreamAsync方法。 internal class ProgressableStreamContent : HttpContent { private const int defaultBufferSize = 4096; private Stream content; private int ... -
此行阻止了UI线程: public string GetAuthUrlToken() { return GenerateAuthUrlToken().Result; } await httpClient.PostAsync()之后的代码需要在UI线程中执行,但无法执行,因为被阻止。 所以,替换这个: private void AuthenticateUser() { var authenticator = new Authenticator(); var url = authent ...