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
...used I obtaining the picture from the Cloudinary store. Although your DB must be on a cloud, it could be a managed DB, such as MongoDB, or it could be DB on a DBMS, such as MySQL or SQL Server, that you install on a virtual machine on AWS or some other cloud provider. Use Cloudinary to store images of students. Please note that you can interpret
*************** Don't bid if you can't 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
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.
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.
I need to create a dashboard to display results of Mysql queries in a visually clear and well laid out way. The dashboard will simply display the graphs. The actual queries will be processed in our own pages and dumped in csv format to individual web pages. The dashboard will need to call those web pages to get the data and then process and display
...tuning help on Oracle SQL block. I have written the query myself and it works fine. I just want it to execute more efficiently and hopefully faster. 1. Query is 4500 lines, but it is composed of about 25 shorter and similar blocks. 2. It currently is executed in the scheduler as a stored procedure 3. Query updates tables on one schema, but all using “Merge”
Need to be able to search for USA addresses in DB even if does not have exact name in DB. Example: City name is in DB table is "Saint Paul" User would serach for "[login to view URL]" or "Saint Paul" and will always get the same result.
I have an existing MySQL query that takes about a couple mins to complete. I need to optimize this query (with indexes or some other methods you should know) to return as fast as a another sample MySQL query that does the same, but using different means to query. I will share both MySQL queries and share remote access to a test server with a clo...
My budget is NZ$25. I need you to review my CV and write a cover letter and a query letter, which you can then adapt for 1) a writer/editor position at a museum exhibit design business, 2) a video editing position at a tv station, 3) a data entry position at a software developer business.
Necesito agregar un query en mi model file y pasar la variable al archivo view, de preferencia solamente español para esta pequeña tarea. Me gustaría comenzar una relación de largo plazo comenzando con una tarea muy pequeña para evaluar la forma en que programas. Gracias.
I need some changes to an existing website - Wordpress 1 Bottom Slider Change (Just put the top slider's CSS Adjustment) - Size should be 1800×500 - I will provide the same size PNG image 2 Adding More pages to the Menu (Mock Up and text is ready) 3 Making the Phone Menu *Solutions* responsive (Not Coming Properly on the phone) 4. Bottom Slider should slide like the top slider 5. ...