I need to write script for below sample, the query I need to execute is select m.user_id, m.first_name,m.last_name,m.email_id,m.CREATED_DATE, m.updated_date, v.CREATED_DATE, v.updated_date, listagg(v.vendor_number, ', ') within group (order by v.user_id) as vendornumber from USER_MASTER_INFO m left outer join USER_VENDOR_INFO v on m.user_id = v.user_id --and v.vendor_name in ('st...
Hi there! I'm looking for a project that will open a content-link in a html, after this it will check in a table in the source code how many specific word appear and if it's > 3, the script will back to the first page and click in a specific botton. It should loop at each link (it has several links on the first page, and the procedures must happen
please find the below r...all the submitted students in a table view you should be able to add/remove/update each single record each record should have a hyperlink to view information (reuse the Page 1 code) to show all the details of the selected record. Make sure to have validation checks. Develop this two pages in PHP a -PHP files -SQL DDL file
Hi, I need help with database import and datapump. I need someone who can start urgently. I will share details shortly. Regards
...2010), and place those into a SQL Server table. I would therefore like a powershell script that populates a table with: Username, EmailAddress, PrimaryOrAliasIndicator. The script will be run as a scheduled task once per day. Therefore, it should run without user interaction. It is quite ok to delete the table and re-enter on each occasion, rather than
Need GET and PUT APIs for a cloud db. GET Input: Key Process: Check a db table for the key and find associated column value for the key Output: Value PUT: Input: Key, Value Process: Find row of the ke in db table and replace the column data with 'Value'
This is just quick lookup of values from one table, finding the corresponding value in a second table, and then replacing it for the original value. The only issue is that the original values are part of a single field, so the field needs to be parsed first, the value substituted, and then reassembled.
We need you to export a particular table from a sql_file, which we will provide to you, to a csv file. We are having issues to export the file, since the data contains several signs like commas, semicolons, etc, so we can not define a good separator.
Hello i need to Make integration Between Oracle Rightnow and Avaya (CTI)
...Grab the data on a scheduled basis 2. Be able to download the file in CSV format and save to a folder on a scheduled basis 3. Automatically load it to a target table in a Oracle SQL database This is a test project, and if successful and quality work is done, there are several similar projects that would be awarded and long term work available. The
Hi, We are seeking a designer to help us with matching place cards, table numbers and pix card for our wedding. very simple. There will be 97 people at our wedding. Our theme colors are nude, blush, white, gold. Our floral is greenery, so a little green may be considered. Place Cards: - Must be self standing, fold in the middle - like a tent - White
The project is: Install a Oracle 11g database in a fresh CentOS 7 server (ssh only and database files should be located on home folder) Configure backup in other folder Run a backup in other Oracle 11g running on AWS Restore the backup on the new server Test and simulate 500 users on this system Resuming: install Oracle 11g and migrate a old installation
I am working on Oracle ICS Integration. I have 2 SaaS Cloud Instance and need to migrate data from one instance to another using ERP/Sales cloud adaptor. I have already established the connection and activated the Instance however ICS Instance is not getting triggered when I create an Item in Source Instance (I am using Business event to Trigger Import
Hi, I have oracle database 11gR2 installed on my windows PC. I like help in doing import of dump and doing some important Parametrization . Work requires you to fire import command and solve issue if anything comes. Regards, Sangam