Pl sql simple cursor jobs
I am currently seeking a skilled Oracle SQL developer who will precisely execute data extraction tasks from our existing database system. Here's what I need: I am trying to extract some set of data from a table and filter the dataset by date. However some of the data value in the column are not date, they are alphanumeric or number and it generates the error below ORA-00932: inconsistent datatypes: expected DATE got NUMBER 00932. 00000 - "inconsistent datatypes: expected %s got %s" *Cause: *Action: Error at Line: 15 Column: 7 I need a script that will allow me to filter the dataset by date and ignore the bad data. Cheers
...and exports efficiently. - **Import/Export Requirements:** - Must support importing data from MySQL to Excel (.xlsx format). - Must support exporting data from Excel (.xlsx format) to MySQL. - The system needs to handle specific tables and columns, which I will specify. - **Ideal Skills and Experience:** - Strong PHP development skills with a focus on data manipulation. - Proficient in SQL with a good understanding of MySQL databases. - Experience with PHPExcel or similar libraries that handle Excel file formats. - Clear understanding of Excel file structures specifically .xlsx. - Knowledge of data management and best practices for import/export functions. - Ability to create user-friendly interfaces for non-technical users. - **Project Objectives:** - The ...
I will provide a Source DB dump and a Target DB schema. The "source" is a half-upgraded CiviCRM DB. The "target" is a valid CiviCRM 5.67 schema. i will give you full data...half-upgraded CiviCRM DB. The "target" is a valid CiviCRM 5.67 schema. i will give you full data. you will run the import into target. then send me the procedure, as in something like this, for example: mariadb -proot -uroot test_civicrm < mariadb -proot -uroot test_civicrm < mariadb -proot -uroot test_civicrm < crmcivnew.data.only.15.Jan.2024.sql so I can do it myself. Then I do it on live site. The project will be done when we can run your procedure successfully on the live server. You agree to finish this job within 72 hours of accepting, or we canc...
More details: What specific tasks do you require the ASP.NET and C# expert to perform? Backend development,Frontend development Which database system are you using for the project? SQL Server Which type of reporting functionality do you need implemented? Ad-hoc querying and reporting
I need an expert who can meticulously troubleshoot and rectify syntax errors in my Access database queries. Ideal Candidate Skills: - Proficiency in Access databases - Strong background in SQL - Experience in troubleshooting and resolving database syntax errors swiftly - Attention to detail and problem-solving abilities Requirements: - Analyze existing Access queries - Identify and fix any syntax errors - Optimize queries to prevent future issues - Communicate any changes made and explain corrections - Provide guidance or best practices for query design to ensure stability This project is perfect for someone who excels in database management and has a keen eye for detail, particularly in identifying and resolving syntax issues. Your contribution will not only solve immediate prob...
This project involves creating a SQL-based webpage with strong focus on data management and visualization. The webpage should entail: 1. User Registration and login: - This webpage will require a user registration and login functionality. Here, the necessity is to record user id and password for effective user management. 2. Data Entry Form: - The webpage should include a comprehensive data entry form. This form should be compatible to accept text fields, numeric fields along with date and time fields, making it diverse for users to enter different types of data. 3. Data Visualization: - The main objective of this project is to allow effective data visualization. Freelancers with sound knowledge on data visualization tools and strategies will be considered preferentia...
Análisis y guardado de cambios producidos en unas tablas y campos determinados de SQL
I need a server expert who can implement MS SQL connection in PHP, enabling my Wordpress site to connect with MS SQL database. The version of MS SQL server being used is not specified; please be prepared to work with any version from 2008 onwards. Key Requirements: - Strong PHP and SQL Server expertise - Experience in integrating Wordpress and MS SQL - Understanding of both shared and dedicated hosting environments - Ability to work without provided server credentials NOTE: Please ensure your proposal covers handling all the mentioned tasks without the server credentials. You may also have to work with both shared and dedicated hosting. Prior experience in similar work is a plus.
I am looking for an intelligent web developer to create my final year project, a blog website. This isn't your run-of-the-mill assignment: I require an expert in HTML, CSS, Python, and SQL who can deliver a streamlined, responsive, and visually appealing blog platform. Key Features: - Social Media Integration: Implement functionality that allows for seamless sharing and engagement across various social networks. Let users share, like and follow the posts directly from the website. Ideal Skills and Experience: - Proficiency in HTML, CSS, Python, and SQL for website development. - Demonstrated experience creating interactive, user-friendly blog websites. - Knowledgeable of current trends in social integration for websites.
I need a professional to install Oracle SQL Developer and Oracle Database 21c on my Windows operating system. The database will primarily be used to handle scientific data, so experience in this area is highly preferable. In addition, basic user Access Control Lists should be implemented as part of our security measures. Key requirements include: - Proficiency in Oracle SQL Developer and Database 21c installation - Experience with handling scientific data - Expertise in implementing Access Control Lists Your bid should account for the full project, from installation through to setting up security measures. Please provide your experience with handling similar projects.
I am looking for a PowerShell expert to assist with a unique project. The objective is to automate the process of importing query results from an SQL database into Excel. Further requirements include: - Applying column filters to the raw data. - Constructing a pivot table with the imported and filtered data. - Finally, embedding a snapshot of the generated pivot table into the body of an email. The freelancer must have a solid understanding of PowerShell programming and SQL databases. They should be proficient at manipulating data with Excel and using email generation modules in PowerShell. Familiarity with SQL query writing is essential since the process revolves around accurate results. An ideal candidate would be someone who is detail-oriented and can determine ap...
...bullets aren't show up/. The theme is Unsen v1.6 theme The tabs were added using this code in Custom Html block. </div> <div id="tab-3" class="tabcontent-cus "> {{ }} </div> <style> .tab-customize { overflow: hidden; border: 1px solid #ccc; background-color: #000000; } .tab-customize button { background-color: inherit; float: left; border: none; outline: none; cursor: pointer; padding: 12px 12px 12px 12 x; transition: 0.3s; font-size: 14px; font-weight: ; } .tab-customize button:hover { background-color: #DA850E; font-size: 16px; } .tab-customize { background-color: #DA850E; font-weight: bold; } .tabcontent-cus { display: none; padding: 6px 12px; border: 1px solid #ccc; border-top: none; } </style...
I need a skilled PHP developer to create a basic software with three screens. It's important that you have experience in CI or Laravel, and can effectively work with a SQL database. The screens must be designed with a focus on: - General UI Development - Including Buttons, Text input fields and Dropdown menus An understanding of User Authentication, Data Visualization and Input form processing would be beneficial. Your expertise in creating user-friendly, efficient software will be valuable in this project.
...our entire system on `WP/Woocommerce platform. Woocommerce will be the center of our project so its essential that the developer be familiar not only with woocommerce but with customizing and creating plugins for woocommerce. Our projects use: GITLAB -> C# , , Shopify digital product sales, mobile phone eSIM sales, 1.5, Bootstrap 3.0, ag-grid, Ionic framework, Font Awesome MS SQL 2017, webAPI MVC, ASP.NET, Kendo Controls, and all work is delivered via Gitlab Key Responsibilities: You will be working under and have the orientation and help of our project manager to do mostly back end work creating new and also improving existing functionalities of our project as well as create and customize a new store using woocommerce. This is for ongoing long term development and we wil...
I'm looking for an experienced Laravel developer to assist with adjustments to my one of website's internal page headers. The exact Laravel dashboard I'm using is unspecified, however, the project implies simple modifications only and no advanced functionalities or complex redesigns will be requested. Key Responsibilities: - Plugging in an option to modify the header on one of the internal pages of my website - Ensuring these modifications are smoothly integrated with the existing dashboard setup - The dashboard has no additional Laravel packages or extensions Ideal Skills: - Proficiency in Laravel and understanding of various Laravel dashboards - Experience with user interface modifications and integration - Proven problem-solving skills to handle potential dashbo...
I need to fix a bug and add few features in my application using DevExpress RichEditControl (WPF Dotnet framework 4.7.2). Project is attached. 1. Fix the following bug with printing DevExpress RichEditControl. : ''ThemedWindow' TargetType does not match type of element 'DXDialogWindow'.' 2. modify the code to create load and save files to an ...merge fields (firstName, lastName, and date_of_birth ) - add footer with Page x of y before printing. 4. Table structure a. TemplateTable template_name varchar template_content *blob* b. DocumentsTable first_name varchar last_name varchar date_of_birth smalldatetime create_date smalldatetime document_content *blob* Skills requred: c# WPF (Dotnet framework 4.7.2) MS SQL SER...
Convert a paper very simple floor plan to dxf and dvg
...brand. The website should attract potential students, promote courses on data analytics, create brand awareness, and facilitate corporate training. Here is my existing website, , which, in my opinion, has the worst website design Design Preferences Color Scheme: Blue and white Style: Crisp and professional Website Structure Homepage About Us Learn Excel Learn Power BI Learn SQL Consulting Services Corporate Training Blog Instructors Student Portal Discussion Forums Student Success Stories Testimonials Required Features Online Courses (LMS) Virtual Classrooms Payment Gateway Login/Registration Certifications Newsletter Signup Live Chat Support Student Discounts or Promotions Surveys for Course Improvement Design Requirements Keen eye for clean and artful web design Superior
Project Requirement Specification: Greenhouse Light Control Software UI Design Project Overview The objective is to design a data table to be integrated into the UI of a software application used by greenhouse growers. This software assists in monitoring and controlling light intensity levels across various zones within a greenhouse. Design Requirements 1. UI Design Alignment: The design of the data table must be consistent with the branding guidelines of VoltServer () and should complement the existing software UI, as shown in the provided screenshot. 2. Table Layout and Content: -Climate Zones (Column 1): The table must include five rows under this column, representing the different zones in the greenhouse: Center, East, North, South, and West. -Data Columns (Columns 2-5): Four additio...
I am seeking a proficient WHM SQL PHP developer with expertise in creating browser-based database management solutions. The work will require deep understanding of: - Database management: The core requirement is to develop an efficient database management system for handling our customer data. - Customer data focus: The project is specifically aligned towards managing customer data, hence any expertise in CRM systems would be a real advantage. - Customer registration: A key feature of the project will be to develop a customer registration system. A developer with a background in WHM SQL PHP, Customer Data Management, and Customer Registration Systems will be perfectly suited to meet this project's needs. Yours should be a solution that is efficient, user-friendly,...
Urgent Logo Needed for "Fire and Safety Services" Business. Business Name :- Shree Fire Safety Services [ NOTE :- PLEASE DO NOT INCLUDE BRAND NAME IN THE LOGO, KEEP LOGO SEPERATED ] - Use only Mentioned Alphabets in the Logo - SF or SFSS. Choose any one between these Two. Brief :- We Provide Fire & Safety Services to the Residents. Create a Eye Catchy Logo for my Business . Please use your own creativity and don't try to copy paste Logos available on Google. If not comfortable using Fire & Safety Elements then you can Proceed without the Elements as well, also a single alphabet will work -Create logo without the Brand name.
...with sending domains, and compose sending segments. Requirements: - Proven experience as a Full-Stack Developer, with expertise in front-end and back-end development. - Proficiency in relevant programming languages and frameworks (e.g., JavaScript, Node.js, React, Python). - Experience working with APIs and integrating third-party services. - Strong knowledge of database management systems (e.g., SQL, MongoDB). - Familiarity with email delivery protocols, SMTP, and ESPs. - Excellent problem-solving skills and ability to work in a fast-paced, collaborative environment. - Strong communication and teamwork skills. If you are a talented Full-Stack Developer with a passion for building email-related applications and possess the necessary skills and qualifications, we would love to hea...
...IMAGES *** *** The Website is there, the data is there and the SQL Table is there *** I'm in need of a proficient C# coder who can create a website scraper for me. The project entails scraping information for data analysis. Specifically, I require the following data to be scraped; - Location - Ticket ID - Section - Row - QTY - Prices Skills and Experience Required: - Proficient in C# - Experience with repetitive site scraping techniques - Ability to handle proxy usage - Familiarity with MS SQL - Prior experience in website scraping for data analysis is a bonus The objective of this task is to collate distinct data that can then be analyzed. Ideally, I would like the data to be presented in a normalized format within the MS SQL table. This requires a hig...
I'm seeking a professional with expertise in data export from AWS RDS to handle a large data volume, more than 1GB, and export it into an SQL format or connect to the SQL server to export - Understanding AWS RDS Environment: To accomplish this task efficiently, working knowledge of Amazon Web Services (AWS) is crucial. - Understanding how to create snapshots and transfer and restore snapshots as well This project requires a proactive professional, capable of handling above-mentioned responsibilities independently but also prepared to communicate promptly regarding progress and any potential issues.
I am looking for a freelancer skilled in HTML/CSS to execute simple projects using Visual Studio Code. Your tasks will include: - Designing basic websites, since I require a novice level understanding of HTML and CSS. - Completing assigned levels on 'FreeCodeCamp' using a provided account. - Adding specific functionality to designed websites as and when required by me. Although I'm predominantly seeking beginners, those with an intermediate or advanced knowledge of HTML/CSS are also considered, as the projects' complexity may increase in the future. Prior experience with Visual Studio Code is ideal but not required. Finally, ability to follow instructions on functional requirements is key.
...any item he/she can give feedback. Admin will be able to see all the feedback in this section which should be approve by admin before it goes live. • NEWS LETTER • It will give you a feature to write the TEXT for newsletter, it will send the content to all users which are registered under NEWSLETTER as well as the normal registered user. Web Technology SR. Technology Options 1 Database Server MY SQL 2 Client Side Environment PHP 3 Application Environment Linux 4 Server OS Platform Centos 6.0 5 Browser Compatibility IE-8 onwards, Latest version of Mozilla, Safari and Google Chrome Project Plan...
Hi All - Please ONLY BID if you can complete within 7 working days of the first milestone. If you do not complete the work in this timeframe you agree that we can reverse the milestone. I need a custom wordpress plugin that links to woocommerce and selected products via an option in the product pages. 1. Option in product pages...Customer can add the url they would like the card they have purchased to link to. - Customer can click update. and at any point change this in the future in their admin. - Customer can see basic clicks / times someone has scanned card - Admin of wordpress can goto special area and search for names of customers and change the links directly. I hope this is clear - I want to make this plugin as simple as possible for the customer and the admin. Many than...
I'm urgently seeking a PHP/web app professional to troubleshoot and fix issues related to my platform. Required Tasks: - Repair application loading issues - Rectify website errors - Restore database connection -allow users to sign up (then store details in database in sql) - users login and allows them to go to user dashboard -users are allowed to comment on blogs (pending approval of post) -admin login which allows them to use the admin featured eg delete users, make inactive and approve pending comments The perfect candidate for this job would be someone capable of: - Debugging PHP and/or web app issues - Implementing secure database connections - Running necessary tests to ensure the functionality before and after the fixes The aim is to have these issues addressed...
I'm looking for a freelancer with extensive Node.JS experience to convert a Java-based des...experience to convert a Java-based desktop application into a web app. Key functionalities of the current app include data entry and storage, file management, and reporting/analytics. - Features to Maintain: The web app must retain database integration functionality, besides that the freelancer will also be required for code review and modification. - Database: Our current desktop application uses SQL Lite. The freelancer must have experience working with this database for a seamless transition. This project requires thorough knowledge of Java and Node.JS, database management, and file handling in a web app environment. Additionally, proficiency in executing code review and refactor...
I am seeking a professional with the requisite skills and experience to install and configure environment of Moodle on a Windows system. The following components are required to work: 1. Apache 2. PHP 3. SQL 4. Moodle - Experience installing and configuring Moodle on a Windows environment. - Knowledge of best practices for securing e-learning platforms. Deliverables: 1. Working Moodle system on in house server accessible on local network
I want to create tables and develop a simple frontend for a MySQL database hosted on a web server. I already have an ER diagram for the database design. The frontend should use PHP, and enable us to add, view and modify entries, as well as run custom SQL queries. Ideal candidates should have: - Strong background in MySQL database systems with php backend - Demonstrated experience in web frontend design and development. Your proposal will be of high interest if it includes similar projects you've successfully executed.
Homepage: . About Us Page: Products/Services Page: Testimonials/Reviews Page: Contact Information: Blog/News Section: FAQ Section: Social Media Links: Responsive Design:
I'm in need of a proficient Python developer to develop a simple Python scrapper. he should know well in api if you can do it now start your bid with NOW
The project consists of relating the data from 6 SQL tables to 3 almost the same screens. I WILL DELIVER THE SOURCE CODE IN WPF (Visual Studio 2019) OF ONE SCREEN DESIGN. The screen that will be sent is already developed in C#/WPF from Visual Studio 2019 .NET 6 framework for Windows 10/ are some minimal changes to make to the design of the screen sent to make the other two screens, such as: changing titles and adding a column in the DataGrid. The tables must be in SQL fully compatible with SQL Server management studio v 18.7.1. I am going to deliver instructions, general details and images of the screens in PowerPoint. Also, images of the SQL tables with their columns fields and descriptions will be sent in the PowerPoint. The deliverable must include the follo...
I'm currently on a quest for seasoned Angular developers who have substantial experience in full stack development. Here's what you'll need to succeed in this role: Key Skills: - Proficient in SQL Server as this is our preferred database. - Highly skilled in .net 8 angular to align with our programming needs. - Fluent in employing the clean architecture approach since it fits our development paradigm. - Mastery in working with Azure Devops, as this is the environment you'll collaborate within. The individual I'm seeking should not only be a senior developer with significant experience but also someone who has a deep understanding of these key skills. This project will challenge you to leverage these capabilities and more, so if you're up for it, I...
I'm in need of a clean, functional PHP page created. This will be a fairly simple static page, with no need for form submission, data display, or file upload capabilities. What I do require is the inclusion of two main components: - **Text and Images:** The page should display a combination of text and images to deliver the information effectively. - **Accordion With FAQs:** The highlight of the page, I want the developer to integrate an accordion on the page. This accordion will be used for the display of FAQs. Design details and FAQ content will be provided after awarding the project. Given the nature of this project, I'm looking for freelancers who possess a strong understanding of PHP, HTML and CSS. Demonstrated experience in creating static pages with interactive ...
I need to get list of product from this links: I need picture, link, catalque number, name
Creating a simple project in Codeigniter or Laravel to manage job offers. Graphics, some free admintemplate (I will supply) Using plugins to save time (something similar to CI-STARTER PANEL for codeigniter) System conditions: Clean and super cool code Login without registration (fixed admin) 2 levels (roles) of admins (Admin > employee) After logging in, some simple Dashboard that we will be able to read from the db Page list of job offers table ID | Position Name | location | Price | creation date Action: modify / delete / update Add job position modals window, save to database —- Some basic settings / password change Add / edit delete user Role setting Some logs of who did what when the bases ... Estimated time 10-20 hours. As a client, I'm looking fo...
I am seeking a highly skilled programmer with a strong background in MySQL and Java to develop a functional desktop applica...this role include: • Developing a desktop application using Java. • Establishing a secure connection to a MySQL server through the client. • Incorporating functionality for efficient query execution within the application. Ideal candidates should be familiar with MySQL database design and management, proficient in Java programming, and experienced in building desktop applications. Knowledge of SQL query execution is crucial. This project requires a detail-oriented person who can deliver a high-quality, efficient, and secure desktop application. Your work will play a significant role in the smooth running of operations, hence precision and s...
I am seeking a...accomplishments as a Senior Business Analyst. - Certifications: The writer should ensure to highlight my specific certifications in the resume. - Industries: I’ve spent a significant amount of my career in the Information Technology sector, which should be reflected. - Skills and Software Proficiency: Emphasizing my skills and software expertise is crucial. I have hands-on experience with JIRA, MS Visio, SQL, and Trello. The ideal candidate for this project will have a keen understanding of Business Analyst roles and be adept at translating this understanding into a compelling resume. Previous experience in resume writing particularly for Business Analyst roles is a major plus. Mastery of portrayal of skills and expertise in a clean, professional format...
I am looking for a skilled developer who can update my application to be compatible with Windows 10 64 bit. The specific updates needed are focused on ensuring the application functions properly on this operating system. Key Requirements: - Proficiency in Visual Basic and SQL - Experience in updating applications to be compatible with Windows 10 64 bit - Strong problem-solving skills to address any bugs or issues that may arise during the update process The ideal candidate will have access to the source code and required databases for the application, as these will be needed for the update. Timeline: The project does not have a specific deadline, but it is expected to take more than two weeks to complete. This will allow for thorough testing and troubleshooting to ensure a seam...
I'm seeking a skilled freelancer to assist with a web scraping project on a specific website and leading up to a number of websites. The specific data fields that need to be extracted will be provided. Ideally, you'll have: - Advanced skills in web scraping and python -- Knowledge of MS SQL Server databases. - A demonstrable understanding of data extraction - A fast turnaround rate as this project is high-priority and needs completing as soon as possible. Experience in extracting both structured and unstructured data would be beneficial, as it's likely our sought-after fields will vary. The end goal is for me to eventually take over the code with your ongoing support and will most likely be a long term relationship. I can provide a full specification when needed....
The project spec will be as follows: 1. A code engineer is needed. An existing C# .net 7 Winforms application which uses an Azure SQL database is nearing completion for SaaS application. 2. The solution uses DevExpress Reports and DevExpress Components as well as GrapeCity Components. 3. The applicant must be proficient in Azure DevOps. 4. Payment will be made on completion of project milestones. 5. The project is nearing the end of a current development evolution, but it is likely there will be more further development in the future.
I need a skilled professional to efficiently remove the background from my JPEG pictures. My images are of simple subjects, with minimal details and clear edges. To be precise: • You should be proficient in using tools like Photoshop and similar image editing software. • The final images should be delivered in a PNG format, with a transparent background. • Considering the simple complexity of my images, the expectation is for high-quality, clean work with distinct edges. Your experience in similar projects will be a definite plus. A keen eye for details and aesthetics is crucial.
Simple flutter app with category & video list for YouTube video streaming on app. Will provide all APIs. Deadline: 4 days Note: Apply only if you can meet deadline.
I am searching for a seasoned PHP developer with advanced skill level to handle frontend and backend development, as well as database management for a gaming project. The responsibilities are: - Frontend Development: Create visually pleas...server-side logic ensuring high performance and responsiveness. - Database Management: Handle and manage data storage solutions for smooth application functioning. Given the nature and complexity of this project, I need someone who has substantial experience in PHP development in the gaming industry. Strong understanding of front-end technologies such as JavaScript, HTML5, CSS3 is a must. Proficiency in SQL/NoSQL databases is also required. The ideal candidate would be someone who is dedicated to craft, writes clean code and can hit the groun...
We are seeking a skilled Full Stack Developer with expertise in .NET and SQL to integrate Amadeus API, Hotel Consolidator API, and Car Rental Consolidator API with our JavaScript-based UI. Project Work Details: Amadeus API Integration: Seamless integration with UI designed in JavaScript. Hotel Consolidator API Integration: Harmonize Hotel Consolidator API with JavaScript UI. Car Rental Consolidator API Integration: Integrate Car Rental Consolidator API with our JavaScript-based UI. Qualifications: Proficient in .NET development. Strong expertise in SQL. Demonstrated experience in JavaScript UI design. Proven track record in API integrations. What You'll Do: Collaborate with cross-functional teams to ensure successful API integrations. Develop and maintain code for ef...
...automatically when the computer is switched on and will continue to run in the background. 3 - The programme should be prevented from being closed by the user as much as possible (only the system administrator can uninstall it) 4 - When the programme is opened, an icon/icon of the programme will appear next to the clock notification on the screen. 5 - The program will save the records it collects to a sql file on Macintosh and then send them to the server via API. 6 - The program will only retrieve the header information of the active window and information about the opened application (it should not save/regard software running in the background or in the icon state). Which information will be received: a - Title / ...