Which is the Best Java Web Framework ?

IBM WCS - Promotions - SQL to check the promotion xmls


select * from PX_PROMOTION where rownum < 2 order by PX_PROMOTION_ID Desc;

will return the complete promotion record for last created promotion - 

select XMLPARAM from PX_PROMOTION where rownum < 2 order by PX_PROMOTION_ID Desc;

will return the xml only for the last created promotion


select * from PX_PROMOTION where PX_PROMOTION_ID=1234;

will return the promotion record for a respective promotion Id. 


 
Subscribe to Java News and Posts. Get latest updates and posts on Java from Buggybread.com
Enter your email address:
Delivered by FeedBurner
comments powered by Disqus




×

Try our new Java Interview Questions Search Tool.

There are more than 1000 questions with practice tests.

It's updated daily and It's Awesome.


×

Try our new Java Practice Test tool.

There are more than 200 questions and expanding quickly. It's updated daily and It's Awesome.