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
Pessoal, bom dia! Configuramos os cenários para a versão do xml 3.10 da NFe porem ao criarmos a NFe (saída) o lote foi gerado porem ficou parado no status 2 (Enviado ao PI)  com o erro 38 (Web Service não acessivel) ao clicarmos na descrição do erro [More]
I've used "Moneypad" app to record my financial transaction for over a year and I got an update today. After updating all the icons where misplaced and there were a lot of bugs in the app. The update said "Restore original app icon". S [More]
How to change audio port from output to input port so that i can connect my electric guitar to play along with garageband. I couldn't the option to change it in my system preferences of sound as my mac os x is 10.9.2. So please help me!!!!!!!!!!!! I [More]
I want to calculate the frequency of a sine wave using either all three phases or just one, but I want to know the frequency after 50 msec, I don't want to have to wait for a full period.I have a mathematically sound suggestion but I do not know how [More]
Hi. I have a problem that I think isn't solvable in an elegant way, but I'd like to get confirmation before I do it the dirty way. My application allows the user to save (and load) his work in sessions files. I implemented this by a serializable clas [More]
Ok, so my 3 or 4 year old USR 9108 router went down today-- again. I'm fed up and want a new one. It dies on me once or twice a month. It has decided it doesn't like my powerline adapters lately. and I'm fed right up. I run an internet radio station [More]
I recently find I cannot open PM7 (pmd) files in InDesign CS. I used to be able to do this (they would open as Untitled), but now I just get an error message to the effect that InDesign cannot open this file, either because it does not support the fi [More]
Hi I am trying to add a new essbase server to my Admin Services list. I get the following error message: Error: 1042006: Network error [145]: Unable to connect to [SERVERNAME:1423]. The client timed out waiting to connect to Analytic Services Agent u [More]
Hi all I need a simple working example that shows how to have Java show a .gif image. I have done several searches but everyone over complicates it and makes in not understandable. I just want a super simple way of displaying an image in java. I also [More]
I want screenshots captured on my 96 ppi screen to display clearly in the PDF. But the Acrobat default page resolution display is configured to 110 ppi, not to the system setting of 96 ppi. 1) Why is the Acrobat default display 110 ppi and not 96 ppi [More]