Sql add decimal query oracleJobs

I'm seeking an experienced WooCommerce expert to help with my online store. The project entails adding and configuring 50-100 products, most of which have unique variations. Key Responsibilities: - Product Addition: Adding 50-100 products to the WooCommerce store. - Variation Configuration: Configuring unique product variations, such as size, color, and material. Skills and Experience Required: - Proficiency in WooCommerce: Extensive experience with setting up and configuring products. - Attention to Detail: Need to ensure all products and variations are accurately added. - eCommerce Expertise: Understanding of best practices for online stores and product listings. Please include examples of similar projects you've completed in the past in your bid.

Google big query - for writing sql queries for the complex data

Hi, we require an SQL macro that we need to be able to delete EAN codes that have less than 8 numbers from the import. So EAN codes that have between 1 and 7 digits must be removed from the import. We use a software called StoreManager that uses SQL. The formulas entered in the software look like this IF([CSV_COL(16)]=0 OR[CSV_COL(16)]=‘’ OR[CSV_COL(16)]<0,‘’,[CSV_COL(16)]) Payment and/or Milestone after the problem has been solved.

I have an Android application that I'd like to enhance with a review feature. - The reviews should be submitted on a third-party platform linked from the app. - Ideally, I'd like to incorporate some form of user authentication before reviews are accepted. I'm open to suggestions on how to best handle the authentication process. The overall goal is to encourage genuine and constructive feedback while preventing spam or irrelevant reviews. I'm looking for a developer with experience in Android app development and implementing user engagement features. It's important that the final solution is user-friendly, secure, and seamlessly integrated with the existing app. Your ability to propose and implement a secure and user-friendly authentication process will be a ...

...functionality. Key Responsibilities: - Enhancing the existing dashboard by adding new features and functionalities. - Ensuring that the dashboard has real-time data update and interactive capabilities. Data Sources: - The data sources for this project include databases (SQL, NoSQL) and local files (CSV, Excel). Ideal Candidate: - Proficient in Tableau with a proven track record of developing and enhancing dashboards. - Experience working with real-time data sources and interactive dashboard elements. - Understanding of SQL and/or NoSQL databases. - Familiarity with data visualization best practices. I am looking for a professional who is not only skilled in Tableau but also understands the importance of user experience in data visualization. Please pr...

Are you passionate about programming languages and eager to make your mark in the IT industry? Look no further! We’re hiring talented individuals to join our dynamic team. Position: Software Engineer Domain: Finacle (Banking) Location: Major cities in India and international locations Why Choose Us? Comprehensive end-to-end training in Unix/Linux, JSP, HTML, Core Java, Node JS, Node red, Oracle SQL, and PLSQL. Exciting projects in the banking domain Opportunities for growth and career advancement Terms and Conditions: Commitment: Minimum 3 years with us Training: First month (free accommodation), followed by competitive salary Performance-based increments from the second year onward Global travel opportunities Qualifications: - While we do not have any specific ce...

I'm seeking a seasoned resume writer, with a knack for crafting resumes focused on the IT industry and a comprehensive understanding of executive-level priorities. - Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. ...Your target audience will be, primarily, senior decision-makers in IT recruitment. - Also, the resume must highlight my skills as an Architect. Ideal Candidate: - Proficient in resume building for executives. - Knowledge of the IT industry (java Full Stack development) and architect roles. - Excellent communicator with collaborative editing skills. - MongoD...

I'm looking for a skilled developer to update an existing capacitorjs plugin to version 5 and introduce Android compatibility. I am looking for a Geofence plugin. I have a good starting point with a public plugin, but it needs updating. Here is the source repository: Please reference it, and add updates to it for capacitor version 5, update any of the swift or Objective C code that may be out of date, add corresponding support for Android. Key Requirements: - The main focus of this project is to enhance the plugin's compatibility with various platforms, particularly iOS and Android. - The plugin should be updated to Capacitorjs v5 to ensure it's leveraging the latest features and security patches.. Ideal Skills and Experience: - Proficient

...com/file/LJsytcax2WmStFrLOWBgM6/FitApp?type=design&node-id=3-65&mode=design How it works: - The entire user journey is gamification. - The user chooses a project that has x days (screen 1). Then you must mark the completed days (screen 2) in the app to earn coins. - The coins are on the top bar (Fixed) and starts with 0 coins. - The number of user coins and complete days must be saved in a local sql-lite database. Summary: - Create app with Expo 50 and TypeScript; - The data must be saved in a local database. This project is offline, but there must be online synchronization support with the offline-first approach. Save user coins, projects and days complete; - Number of days on screen 2 must be dynamic, according to what is selected by the user; - Create a service wh...

Seeking a developer with experience in C# and SQL for a predictive artificial intelligence project. Your role will involve developing a model to predict user behavior on a vending machine, utilizing data stored in SQL Server. Proficiency in artificial intelligence is required. Please don't send a bid to later try to increase it. Will be declined.

Stepping Back Through Data I have a table of orders, lets say. I'm trying to find all the "Completed" orders, and then step back through other "Cancelled" orders for the same Customer, that were created within 72 hours. The trick is, I want to keep stepping back until I don't find anymore orders (the 72 hour window will now be based on the last order found). Also, the logic should stop if it finds another "Completed" order for the same customer. I've included a test table and data, as well as an expected output. CREATE TABLE #Order ( OrderID int, CustomerID int, OrderDate datetime, OrderStatus varchar(25) ) INSERT INTO #Order VALUES (1, 1, '02/15/2024 07:00 AM', 'Cancelled') INSERT...

I need a talented SQL developer to create a stored procedure that will automate the process of marking certain items as 'picked up' in our Microsoft SQL Server database. This script should essentially replicate the functionality of our existing Windows application, performing the necessary changes in the database to reflect this status. Key Requirements: - Strong command of SQL and experience in Microsoft SQL Server is essential. - Familiarity with Windows application development is a plus, as this script should mirror the behavior of our existing front-end tool. - Previous experience in creating SQL stored procedures for automating database actions is highly preferred. - Attention to detail and the ability to trace SQL commands accurate...

Requirements: 1. Analyze and understand how the code works 2. Setup environment and run all the microservices and frontends 3. Figure out how to add a channel

...balancing both functionality and aesthetics The final product should be a clean, sleek, and easy-to-navigate website, reflecting the minimalistic style while providing exceptional user experience. My expectation is for a thorough, detailed-oriented professional who can capture my vision and translate it into a fully functional portfolio site. Things to be done Load an API data into on premise SQL server database Client will do some data calcution The new data will be available in the database and needs to be show in website with some base UI. Project involves show some other API data on the website as well Need not have a lot of experience in UI design but need experience showing data into a page. Website would look like this --- Odds data should

I would like to add new features to excalidraw. When importing SVG, I would like to add a function that can accurately recognize SVG's paths and curves and change the color and border color of each object. excalidraw_official site

We are in need of an Oracle Database Administrator (DBA) who can provide coverage from ~8pm to ~4am PDT for one or two weeks starting May 27th, while a current employee is on vacation. Those hours are somewhat flexible. Ideal candidates should have the following skills and experience: - Proficiency in Oracle database administration for versions 11 through 19 - Must be proficient from the Linux command line - there is *no* OEM for these databases - Will respond to emails & alerts for end-clients - Will Investigate any reported problems during that shift - Must be completely fluent in English It is possible there will be nothing to do during the shifts, but if something comes up, rapid response is required. There may also be a need for weekend coverage, and possible futu...

...skilled freelancer who can develop an AI-based search engine tailored towards the customers and employees use for a company. The key features required for this project include: -Natural language processing: Understanding and interpreting human language effectively is crucial. -Relevance ranking: The system should be capable of ranking search results based on their relevance to the search query. -Personalized recommendations: The ultimate goal is to personalize user experience, thus the engine should be capable of generating recommendations based on user behavior and preferences. In terms of data sourcing, the AI engine should primarily draw information from databases. A background in data mining and database management would therefore be advantageous. Proven experien...

...proficient in Websocket and SQL, who can help me with an automation project. Key requirements: - Profound knowledge in Python, including advanced topics and best practices. - Strong understanding of Websocket and SQL. - Experience in automation tasks would be highly beneficial. - Ability to adapt to different mentoring methods, such as video calls, live chat, or in-person sessions. Your tasks: - Mentor me through the automation project, providing guidance and support. - Help me understand and implement Python, Websocket, and SQL concepts effectively. - Adapt to my preferred session mode, whether it be video calls, live chat. Ideal skills and experience: - Proven expertise in Python, particularly in automation applications. - Experience working with Websocket and...

Looking for experienced computer programmers skilled in Python for a web development project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in buil...project. Skills and Experience Required: - Proficiency in Python programming language - Strong knowledge of web development concepts and frameworks - Experience in building and maintaining web applications - Familiarity with front-end and back-end development - Ability to implement responsive design and ensure cross-browser compatibility - Good understanding of database management systems and SQL - Knowledge of version control systems and agile development methodologies Timeline: The project is expected to be completed within ...

I require a skilled freelancer with experience in Amazon Web Services (AWS). We have a an ERP Developed on Laravel which is currently on a On-Premise Windows Server. We would like to move the application to AWS using a windows OS and SQL Server Database. Please guide as to which option would be better. The selected freelancer would have to set up a Windows operating system. Skills and Experience Required: - Proficiency in AWS, - Demonstrated experience deploying Please ensure to include examples of your previous AWS work in your bid. Your ability to efficiently handle tasks in the AWS environment is paramount for this project.

...candidates should have plenty of experience with Flutter Development, as well as a portfolio of past work to demonstrate their expertise. - Proficiency in Flutter development - Experience in developing for both iOS and Android platforms - Ability to work independently with minimal guidance You have to setup and configure both the flutter application (iOS and android) as well as the backend PHP, my SQL, firebase, docker etc. As the client, I did not specify the key features to be prioritized, giving you the flexibility to design the app in a way you find most effective. Similarly, there is no predesignated design requirement for the app, paving the way for creative freedom. Given the lack of specifications, the ideal freelancer should be highly creative and intuitive, capable...

We've developed an MS Access database front end with a SQL Server back end. Now we need to install both of these with government agencies in South America whose IT people only speak Spanish. We provide written installation instructions in English. Our clients can only meet the contractor online for server installations during business hours in American time zones. This is periodic work, installing databases whenever clients request them. At present we have six clients in the queue. The applicant must guide and troubleshoot each installation online in fluent Spanish. The successful applicant will have a record of relevant database work. We're a university-based not-for-profit.

I am looking for an experienced Python developer to create a scraper for Lazada. The ideal candidate must be skilled in web scraping and should reverse engineer API from mobile app because lazada blocks and throws captcha on web website is lazada . The script should work like i enter something in search box and it should scrape all the products from that search query Key Responsibilities: - Extract the following information: product names, prices, descriptions, stock, images, seller information, and product URLs. This list encapsulates the attributes you need to pay the most attention to. - Organizing the scraped data: The data, once scraped, must be organized in a well-structured CSV file. Ideal Skills: - Strong experience with Python. - Proficiency in web scraping tools. -...

I'm seeking an experienced Oracle Apex developer to build a process automation application primarily for my internal team. Key Features: - User authentication to verify and secure user access. - Data input forms to streamline data collection and ensure consistent data entry. - Reporting and analytics functionality for in-depth process analysis and decision-making support. Ideal Skills: - Proficiency in Oracle Apex. - Experience in creating user-focused data input forms. - Capability to develop secure user authentication systems. - Expertise in building reporting and analytics tools. Your mission is to create an Apex application that simplifies our processes, ensuring efficiency and accuracy by easing data management tasks. Your work will directly benefit our internal...

I'm looking for a skilled freelancer who can help me with a PDF layout. Specifically, I want to add a new text block to the existing PDF design. Key Deliverables: - Incorporate a new text block seamlessly into the current layout - Ensure the text is properly aligned, sized, and formatted to match the aesthetic of the original document Ideal Skills and Experience: - Proficiency in working with PDFs and editing tools - Experience in graphic design and layout editing - Attention to detail and ability to match styles accurately Please note: I will provide the text content and the image, and I'm looking for someone who can execute the addition professionally and efficiently. Thank you.

MUST READ FIRST =============== MUST HAVE - Blazor experience of at least 3 years - Latest version of .NET & SQL Server - At least 1 hour of availability between 6:00PM and 11:00PM EST - Your price is the one that you REALLY want to have with 10% +- NOTE - APIs will be provided (you will not develop APIs) - No development will be done on My Computer. - DO NOT APPLY if your fees can exceed 10% or your bid PROJECT I have C# Blazor Web App that works using SQL Server Database & using APIs at the same time. For the functions that use the database, I want to replace them with the APIs 1- Make code debuggable. 2- Error message appear with no details, need to make the error message has Show More to display the details of the error. 3- Load Codes from APIs instead of...

I'm currently in need of a Scottish voice actress who can narrate the voices of a character from my book, "The Oracle", for social media purposes. The main character, Nodiah, is an intense character coming to terms with her identity and her new found freedom. There is a lot of emotion in her lines, and some of the content can be quite intense, though nothing too explicit. Ultimately I just am looking to get a few quotes read from the book! There's a possibility of an audiobook in the future, as well as a sequel! Thanks for looking!

I'm in need of a professional who is skilled in both graphics and Power BI. Let's collaborate to convert raw data into clear, visual and interactive dashboards. Here are the specific needs for this project: Power BI Tasks - Effectively perform Data modeling, Data visualization and dashboard creation using Power BI - Work with various data sources that include Excel Spreadsheets, SQL databases, Online APIs, and Azure Graphics Tasks: -Even though I didn't specify any graphical needs, any creative approach or design skills you can bring to the project to enhance the visual aspect of the data would be appreciated. Ideal Candidate - Proficient in Power BI - Experienced in working with multiple data sources - Has a knack for graphic design - Detail-oriented and data-dri...

...months to 15 months Position open: 2 Data scientists Key Responsibilities: - Perform data analysis and visualisation on trading or stock market data - Use your data science skills to provide valuable insights - Ensure the accuracy and efficiency of your predictive modeling Ideal Skills and Experience: - Proven experience in trading or stock market data analysis - Proficiency in Python, R, and SQL - Strong analytical and problem-solving skills - Prior experience with predictive modeling and algorithm development - Ability to handle a variety of data sizes and formats, as the size of the data may vary If you have previous experience in the trading industry and can confidently handle data analysis and visualisation, this opportunity is perfect for you. Your work will play a vita...

Tengo un Insert que proviene de una tabla que esta consumiendo mucho CPU al momento de ejecutarse, es un SP simple pero requiere de índices o validar que los que ya están creados no estén causando conflicto y aumenten el consumo del CPU

I'm looking for a professional photo editor to implement a realistic addition of a person from one JPEG image into the background of another JPEG image. It's crucial that the person added looks as natural and as originally part of the photo as possible. The location in the background where the person should be added will be specified. Skills and Experience needed: * Expertise in realistic photo editing * Familiarity with JPEG image formats * Ability to follow specific instructions for the placement of the person being added * Proven track record of similar photo editing projects in a portfolio (or provide examples) is a plus

...few countries we need you to replicate for more different countries, each country will consists about 8 google sheet types and some types may have dozen or up to few hundreds google sheets. Then some of the data needs be transferred and stored to SQL and taken from SQL by API also. This is team work, you will be working with bunch of server guys and python guys. So you need to possess these abilities and criteria : 1. Able to make google sheets fast, make editor for the GS fast and send all of the Google sheets ownership to me. 2. Able to work on SQL and API. 3. Able to collaborate as a team. 4. Agile, fast delivery, and responsive 5. Integrity, Honesty, Independently initiative, responsible, straight forward, loyal, modest, discipline, emphatically fair, hard wor...

You have to add Monthly MCQ by pe day in the morning.

...Standardization: Perform equivalences to standardize information received from APIs. 4. Simultaneous Search in Multiple APIs: Activate search across all configured and active APIs with clear indicators of success or error. 5. Results Visualization: Display results in a table viewer for easy comprehension. 6. Temporary Data Storage: Save information in memory and delete it when performing a new query. Technical Requirements: 1. Experience in frontend development with AngularJS to create interactive interfaces. 2. Proficiency in backend development with Java or Python for handling API requests. 3. Ability to implement temporary storage systems in memory or cache for sensitive data. 4. Capability to create files for automatic deployment in Lambda functions, Docker containers, or a...

...Standardization: Perform equivalences to standardize information received from APIs. 4. Simultaneous Search in Multiple APIs: Activate search across all configured and active APIs with clear indicators of success or error. 5. Results Visualization: Display results in a table viewer for easy comprehension. 6. Temporary Data Storage: Save information in memory and delete it when performing a new query. Technical Requirements: 1. Experience in frontend development with AngularJS to create interactive interfaces. 2. Proficiency in backend development with Java or Python for handling API requests. 3. Ability to implement temporary storage systems in memory or cache for sensitive data. 4. Capability to create files for automatic deployment in Lambda functions, Docker containers, or a...

Hi Dmytro, i have a new domain that i would like added to our server ( ) with SSL please. Also, if you have time, update any packages please?

I've run into a problem with my WordPress PWA plugin. Even though I've enabled the "Add To Home Screen" feature, it's not showing up when tested on mobile devices and tablets. The issue seems prevalent on both Android and iOS platforms. The perfect candidate to assist in this project would have: • Expertise in WordPress and PWA plugins • Proficient troubleshooting skills for addressing platform-specific challenges on Android and iOS • Experience in customizing PWA plugin settings to ensure optimal functionality. The goal is a seamless implementation of the "Add To Home Screen" feature across multiple device platforms. Your input and expertise are greatly valued in fixing this issue. Let's make this feature work seam...

...this project should have proven experience in time series forecasting, Python programming, and developing interactive dashboards. A solid grasp of data visualization principles would be a plus. The output should be in a form of a python file with 4 models above and related dynamic visualizations. The text preprocessing is required and can be done in any necessary technologies (HADOOP/SPARK,NOSQL/SQL databases) - screenshots of the bash code are required....

Se debe mantener un sistema hecho en .Net el cual esta vinculado a una base de datos SQL Server de Microsoft. El postulante debe manejar a la perfeccion el idioma Español.

I'm looking for a skilled Oracle APEX developer to create a results and statistics page for a quiz platform. I need the form to reveal the correct answers and individual statistics after it's submitted. Each question's answer must be shown right next to the user's choice so they can easily see what they missed. The ultimate score should be displayed in a format of 'achieved score/out of total score' or 'percentage'. Key features: - Display the correct answers alongside participant's responses - Show the participant's score as 'achieved out of total' - Generate overall quiz statistics A background in Oracle APEX is mandatory and previous experience in quiz, survey, or similar interactive form development will be h...

I'm searching for an expert in Visual Studio 2022, MS SQL, and VB.net, for the main objective of maintaining and updating an existing software application. Key tasks: - Primarily, the project will involve optimizing the application's performance. Skills and experience: - Experience with Visual Studio 2022, MS SQL, and VB.net is a must. - Proven expertise in software optimization. - Knowledge of system maintenance and updating.

I have a 500MB XML file that I need loaded into SQL across approximately 20 tables. I'm in need of a Python script to handle the transformation. The script will need to handle normalization of the data. Key requirements: - Develop a Python script to read the XML file and transform the data into a normalized structure across 20 tables. - You will need to create the SQL tables as part of the normalization process. - Experience with large data transformations and SQL is vital.

I'm seeking a skilled .Net developer to assist in developing a comprehensive retail system that has features such as user authentication and authorization, inventory and product management. Requirements: - Proficiency in C#, .Net, Entity Framework and SQL Server - Ability to develop a retail project from scratch - Strong understanding of user authentication and authorization - Experience in inventory management and product cataloging It's crucial that the chosen freelancer has prior experience in building online retail systems and a strong understanding of the retail business model. The ideal candidate should be able to deliver a secure, efficient and scalable retail project. Any experience with Angular/react/Node would be plus

It is necessary finish a project managemet application made in laravel. The change are: - make some change regard the flow, the links, the design, the ecommerce and report; - It is necessary experience in query, report charts, pivot builder and Business intelligence to change the reports that must have good design, many filter and cross. the charts must have drill down. Please answer only if have experiences in project management software and pivot-query-busienss intellegence. And show my the url of similar job made.

I'm looking for a skilled software engineer. THis task is too large for excel power query, however i want it to operate in a similar fashion. The main purpose of this project is to develop a self-updating database of every racehorse in the state of NSW, Australia, via the website. Key tasks and responsibilities: - Determining the best platform for the software (Web-based/Desktop-based/Mobile application). - Creating a software solution that will automatically update and manage a database of racehorses. Skills and Experience: - Proficiency in at least one high-level programming language i.e., Java, Python, C++ - Experience with automation software - Familiarity with database management - Ability to recommend best software platform based on project requirements. Thanks :

I am in need of a freelance MIS Executive with strong skills in data analysis and database management. Responsibilities: - Conducting detailed data analysis using the provided tools - Proficiently manage and maintain a database Ideal Candidate: - Proficient in Microsoft Excel and SQL Server - Experience in database management and data analysis - Strong analytical skills - Excellent attention to detail This project requires someone who can work independently, has a good eye for detail, and can deliver high-quality results. A background in MIS or similar field would be a big plus.

...completion) Whereby; candidates can create a profile upload their CV, images or link to images and videos recruiters can search CVs with a Boolean type search functionality & save searches. Candidates and recruiters can message each other. Admin can manage the back end. Suggested technical skill set but not a complete one… • Cloud-based server solution • Azure or Single server solution • MS SQL Database (NoSQL document database might be more appropriate?) • OAuth • Payment gateway • .net We suggest design led development process where we sign off the look and feel of the web pages… the back end is for the supplier to advise the best scalable solution for the application. Please send your credentials/ skill sets and cost struct...

...managing user profiles, cataloguing orders, generating recommendations, and facilitating payment systems. 1. Implement a QR code as the entry point for users to access WhatsApp chat. 2. Utilize WhatsApp APIs to initiate chat sessions. 3. Employ Language Model (LM) capable of Hindi, English, and Hinglish for conversational interactions. 4. Integrate LM with backend logic for CRUD operations on a DB (SQL/NoSQL). 5. Store restaurant data including name, menu, pricing, and location details. 6. Capture user profile data such as name, preferences, allergies, and delivery addresses. 7. Manage user records and orders in the backend. 8. Prompt new users to provide necessary details. 9. Facilitate dish selection based on user preferences. 10. Display sorted dish options in sets of four ...

I'm in the process of launching a new social networking app and looking for an experienced Flutter developer to help bring this idea to life. Requirements: - You should be proficient in Flutter development, as the app needs to be compatible with both iOS and Android platforms. - The app is already has the following features; user registration, login and interaction, so your experience with these features is crucial. - I need push notifications and in-app purchases to be added to the app.

...handle real-time data processing and CRM updates based on interactions within the app. Tasks: 1. Advanced Voice and Text Search Integration: • Enhance the app with both voice-to-text and text-to-speech functionalities for seamless user interaction. • Implement AI-driven prompts to help refine and perfect property searches based on user input. 2. MongoDB Integration: • Develop backend logic to query MongoDB effectively with parameters derived from GPT-processed queries. • Ensure real-time data fetching and updating capabilities. 3. CRM Integration: • Automatically populate CRM systems with details from interactions (both text and voice) conducted via the app. • Ensure data consistency and accuracy for effective client management. 4. Testing and Depl...