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
I am still on Aperture 2 but want to upgrade to Aperture 3. Current Aperture lib has grown to over 40GB. My laptop is starting to get generally slower and I feel that I have a lot of HDD fragmentation that I have not resolved yet. My internal HDD is [More]
JDBC Outbound adapter in XI 2.0 connected to SQL Server.  I've coded my mapping to format the XSL mapping properly but the Adapter appears to not be able to find the Stored Procedure.  Error message returned is "Invalid Object spStoredProcedureName&q [More]
After updating to iOS v5, my iphone 4S's built-in Photo app stopped working. The Camera takes a photo, but the photo disappears from the camera roll and shows no photos in the photoalbum. My iPhone used to take photos so, I don't believe it is a hard [More]
I'm trying to restore my iphone because my phone is disabled cuz of the password but everytime i restore in DFU mode in couple of minutes it says error 9006 any walkthroughttp://support.apple.com/kb/ts3694#9006 Configure your security software Check [More]
hello, I found an Implementation of ThreadPool in the java.sun.com,but it didn't have the minimum,maximum no. of threads implemented in the code. Could you help me find out an implementation of Thread Pool,that keeps track of minimum no. of threads,m [More]
Hi, I'm getting the error while deploying win store application in debug mode. I checked the space - it is not the issue. Is is possible to check/clean the disk space associated with the user account? Is this a problem? If yes, how to clean it? Thank [More]
I use the Java client API, no workbench processes. All PDF operations, like assembly, reader extensions, form data integration and extraction, require a running Livecycle server. Is there any option to add a Java jar to my project with the service im [More]
I changed the personal Domain Name in iWeb 08 and realized it was entered incorrectly. I've removed the name form the list and my pages and blog still show up at the wrong address. It's been 12 hours. Does anyone know how long it takes or if another [More]
Any issues with changing the name of the harddrive aliases that display on the desktop?You can name the volumes anything you want. Thus I have one drive with a single partition named "TigerBU" and a second drive with two partitions, named " [More]
How do you fix a R6025 pure virtual function call error?  When I try to search for music, iTunes freezes & returns this message.For general advice see Troubleshooting issues with iTunes for Windows updates. The steps in the second box are a guide to [More]