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 preparing my MacBook Pro mid-2010, running Mavericks, for my girlfriend. I created an admin account for her and deleted mine, as well as my old user files. But now, when opening MS 2011 apps (Word, PowerPoint, Excel), while loading the the templ [More]
Hi, First let me explain my Exch 2013 SP1 Multidomain set up. 1. DA as Forest Root domain, having schema master domain role installed. DB as Tree Root domain in above forest  DC as Child domain in Tree root domain. Brought 1 machine in Child domain a [More]
Hi, Everytime I try to open a psd file or create a new file CS5 crashes and closes itself.  There seems to be no rhyme or reason to it.  If I go to the file in windows exlplorer and say "open with" it will open.  However, I still can't create a [More]
Hello, I recently upgraded from WLS 7 to WLS8.1. My code that was using EJBs with transactionAttrbute set to Required has a method that makes calls to 2 databases: one SELECT and another UPDATE. In WLS7.0 I was using a non-XA driver and there was no [More]
please give me free download of OS XMAVERICKS for my macbook loptopTo install Mavericks, you need one of these Macs: iMac (Mid-2007 or later) MacBook (13-inch Aluminum, Late 2008), (13-inch, Early 2009 or later) MacBook Pro (13-inch, Mid-2009 or late [More]
...a random question for anyone that uses adobe light room... when i go to import cannon raw files it imports as colour and then after they 'render preview' they turn black and white... i's so fustrating! no presets are on and i reset the settings... [More]
help me in this An application deveoped in cldc/midp environment,will it run in cdc/personal profile environment Thanks in advanceHi, I would say yes, in Next Generation Java in Nokia platforms ! There's a presentation about Next Generation Java in N [More]
Hello, I am fairly new to Flex and OOP and am confused on how some parts of OOP work. I have a Spark TextInput Component with an id which equals "test". I also have a function that takes "test.text", appends a string to and and puts th [More]
I'm posting this here because there's probably some newbie mistake that I'm making but I don't know what it is.  For those who don't know ser2net lets you connect a serial cable to a device and then other computers on your network can access that dev [More]
As a fun weekend Photoshop project I thought I'd see what it took to write a Photoshop CS6 filter plugin.  So I downloaded the CS6 SDK and opened up the Dissolve sample.  Right away I see errors about not being to open Apple headers like Dialogs.h.  [More]