Simple XML, need some help on a path query in Oracle. Need to extract specific values from named pairs. e.g. GreenQuantity=4 <Identifier> <Type>GreenQuantity</Type> <Value>4</Value> </Identifier> See attached test script for full example. Must work on Oracle 11gR2.
We have a gate access control system that we can retrieve usage data in Excel format. Unfortunately, some of the records are at the same station and within a short period of time. I would like to have a way to remove these unwanted records either in Access or in Excel and then import to Access. Within same username any record within ten seconds of the previous date and time would be removed. Wi...
I have a table that has following columns: coin_id, data_item_id, rating, created_at For each coin_id there's multiple rows from different data sources (marked with data_item_id), and rating from that data source.. but there are dozens of them. What I need is find the latest row for each data source (data_item_id) and get that row's rating. The output for example coin_id 32 should be: r...
...help me to make it working. Here is detail: Basically create and use the query string in React.JS. I built a search page using ReactiveSearch I use two components DataSearch and ResultList. It is working fine on http://localhost:9000 I like to pass the query string to it. The query string should be captured it DataSearch component, set the property defaultSelected
...abide by my project... I will only pay $10.00 milestone at end of completion. I will send file or files so you can edit then send back, i upload for tests... All i need a a query to pull the total count number for blocked column or meaning (blocked users).. Right now its showing the count number FROM probid_admin_stats or $data in screenshot that i do-NOT
Dear professional, We are looking for python ninja to develop the Next version of out backups script. The project is an open-source project developed in house. The script is written in python and runs on Linux currently with python 2.7 and 2.6. We want to:" 1- Fix a few issues that the script has. 2- Make it compatible with Windows Servers and Desktop
We need to edit a mysql query used to exract records from 7 related tables, the query already works, we need to add 8 more fields to the result and some interactions.
Need a experienced developer in wordpress with NEXT GALLERY and custom fields, permalink with unic url. task as add categories and tags, and making permalink to unic links
Rewrite 1 article for Sports Betting in the next few hours. Stellar English grammar skills needed. It's that simple. Consider this a test for an ongoing position. I'll create a milestone and release it ASAP once the work is done. Just do a GOOD JOB.
we have a table where we have data saved as per MLM structure. This table has about 50K records and each child have again more child elements. need some one to make query/Stored Procedure etc to fetch record in less than 5 sec.
We are seeking people to deign a database for a hotel that is completely scaleable and easily managed, with a next generation front end flexibility and control. Please see the attached documents to see the database sample and the list of features currently needed. Who ever designs the winning database will receive the reward as well as a exclusive gig
I want an extra header with '' extra information '' next to the heading product description. I use wordpress and woocommerce. it must look the same as the product description.
...be based on one set of columns or points. If there are 3 items, then there would be two graphs overlaid - the first array item would still be the x-axis field names, and the next 2 items would identify two sets of results. In the instance of more than one set of results, the y-axis would need to identify more than 1 set of values in the scale. And