Sitemap

Amicuk Programming Answers

Please help me on this!

-0001-11-30   Views:0

Advertisement

Hi, I need to execute the query to find the particular string in the xml data. The query i used is given below. select create_dt from wms_out where xml_data like '%lpad(270,3,0)||lpad(5,2,0)||lpad(63,4,0)%' and trunc(create_dt ) = trunc (sysdate-3) a

Hi,
I need to execute the query to find the particular string in the xml data. The query i used is given below.
select create_dt from wms_out
where xml_data like '%lpad(270,3,0)||lpad(5,2,0)||lpad(63,4,0)%'
and trunc(create_dt ) = trunc (sysdate-3) and msg_type = 'delWtdr' ORDER BY create_dt desc;
The string look like 270050063.
I will get this string as three part like in the query.
I am not getting any output with this query. But if i use xml_data like '%270050063%'. I am getting the output.
I am not sure, whether this query is correct or not.
Thanks

The replay answer
Advertisement
select create_dt from wms_outwhere xml_data like '%lpad(270,3,0)||lpad(5,2,0)||lpad(63,4,0)%'
and trunc(create_dt ) = trunc (sysdate-3) and msg_type = 'delWtdr' ORDER BY create_dt desc;
Your query will search for string "lpad(270,3,0)||lpad(5,2,0)||lpad(63,4,0)" which anyways is not there.
if you want to get any values like 270050063,271150063,272250063...then you can use
'%27__5__63%'
Cheers

Go to See the other 4 answers

Hot
Hello there, I am from Malaysia and i have been having problem with the app store. It says that it cant connect to the app store. Is is possible that its not working in Malaysia? If it is, any solution to make it work or to download apps not from app [More]
I have read many of the threads in regards to DCA issues...but It seems to be suffering a bit of a different issue with it... We did a clean install of groupwise 8 about two years ago, and I didi not even know of the gwdca issues, as everything was r [More]
Hi people, In the transfer postings using MM and SD, we have the following steps: Create the PO type UB Create the delivery document using VL10B Create MIGO and J1B1N using VL02N I would like to know about the information of tab "Value with taxes&quo [More]
Dear all,           I want to consume a bex query into SAP UI5. For that I found this document:-      http://cms.int13h.nl/wordpress/wp-content/uploads/2013/01/How-to-Create-OData-Services-for-Analytic-Queries.pdf      In this document, the first ste [More]
Hi everybody. I'm trying to access the lines (Invoices) of a Incoming Payment. When an Incoming Payment is successfully added by the user I have to get the number (DocNum) of the Invoice(s) that is being payed trough DI so I can use it to reference t [More]
Hi, Has anyone implemented the new MSS scenario (ECC 6.0) on NW 2004S yet? We're trying to implement ADS to show us the trip and travelforms in PDF and have hence followed the ADS config guide for this. We used Basic Authentication and I thought this [More]
I have tried saving a file as .gif in fireworks, but it did not give me a transpartent background. it does in photoshop. why doesnt it do the same here? thanks.You don't want to "Save," you want to "Export." Go to File > Image Previ [More]
Hello, In the attached VI, I would like to extract the first 50 points, then next 50 and so on (from the attached file), and build up an array as shown in the image file.  Any help will be greatly appreciated. Thanks, hiNi. Solved! Go to Solution. At [More]
Hi, I need a query to find if the logging is enabled in application R12. Recently some users have enabled FND logging in Application, though I have disabled the logging but still I want to find out who has enabled he logging. EBS version: 12.1.2 Data [More]
Hi All, Can anybody help me why i am getting this error at the time of subscribe() method. Below is my code..     public static final String CONNECTION_RELAY_URL_SUFFIX = "/ias_relay_server/server/rs_server.dll/SUPFarmMBS";     public static fin [More]