Run stored procedure oracle sql 2005công việc

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...

...trading bot on Solana using Rust preferred or Typescript for the back end, which will be interacting with the Raydium API. The bot should be able to monitor the WSol/New Token pair on Raydium and execute trades based on the detection of the addition of liquidity, as well as sell at specified sell points. The bot will operate on Windows using React or similar for a simple UI. Wallets and custom RPC stored in an ENV file. The UI will be used for Buy and Sell settings config,(gas price+ slippage_ amount of tokens to buy in WSol for buy . Token contract to be pasted and then tx executed until Liquidity Pool is formed and bot attempts to purchase the token. Once token purchased the bot will send the token evenly to up to 5 wallets (configured in the UI) to be auto-sold at pre-set prof...

1. General Information Project Name: Development of a Chrome browser extension for managing the size and positioning of browser windows. Project Goal: To create an extension that allows the user to adjust the size and positionin...project. Documentation on the code and project architecture. A user manual for installation and use of the extension. An archive for installing the extension in the Chrome browser. 6. Guarantees and Support Provide a warranty for a period of 5 to 6 months for fixing any arising errors and maintaining functionality. Technical support and updates during the warranty period. 7. Proposal Submission Procedure Candidates should provide: Their portfolio describing experience with the required technologies. Descriptions of successful cases in the field of web de...

...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'm in need of a Python developer to assist me with web scraping. The data I'm after is sourced from APIs and once extracted, it needs to be stored in a CSV file. Key Requirements: - Proficiency in Python - Experience with web scraping - Knowledge of working with APIs - Ability to store scrapped data in a CSV file Ideal Skills: - Familiarity with popular Python libraries for web scraping, like Beautiful Soup or Scrapy - Understanding of API integration and usage - Strong data handling and manipulation skills It's a straightforward task that needs attention to detail and adherence to best practices in web scraping. If you have the right experience and are keen to assist, I look forward to hearing from you.

...endpoint for JSON data reception Developing a device management page, including adding devices, assigning properties, and linking them to client profiles Creating and managing client and user profiles, including assigning users to clients or groups In essence, the app should allow for the creation of client profiles with customizable fields. JSON data received from devices in alarm states should be stored in Firebase, linked to client profiles via device ID, and trigger alarm notifications on the user's app until acknowledged. To excel in this project, you should possess: Strong proficiency in Firebase and Flutterflow, along with cloud functions Previous experience in building intuitive and responsive mobile applications Attention to detail, particularly in implementing a ...

...can be easily integrated into other websites as a microservice. Additionally, the application will support payment methods for premium features. Requirements: Website / Document Scanning Functionality: * Users should be able to input any website URL or document into the application. * The application should scan the website and extract relevant data for processing. * Extracted data should be stored in a database for future reference. AI Model Integration: * The application should integrate with an AI model capable of answering questions based on the scanned website data. * Preferably, use a free or cost-effective AI API for this purpose. * The AI model should provide accurate responses to user queries based on the scanned website data. Chatbot Integration: * Develop a chatbot...

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...

...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 need a Python expert to scrape tabular data from a series of PDFs and store it in a database. Ideal Skills and Experience: - Proficiency in Python. - Strong experience in web scraping with PDFs. - Familiarity with database management. The PDFs are consistent in format and all contain tables. The scraped data needs to be stored in a database.

I'm in need of an experienced developer who's well-versed in ASP.NET a...well-versed in ASP.NET and VB.NET. The project involves the event pages i need where user can login and acess the event throught calender with specific functionality.. i will share feature to slected one ... Ideal Skills and Experience: - Proficiency in ASP.NET & VB.NET is a must, with a proven track record of projects involving user authentication and database integration. - Strong understanding of SQL Server databases and how to effectively integrate them into a .NET environment. - Experience in implementing user authentication systems that cater to both roles and individual accounts. This project requires a developer who can deliver secure and efficient user authentication and database inte...

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.

...restricted Linux environment. Responsibilities: Develop a program that checks for new versions of an executable stored on GitHub and updates the running executable accordingly. Implement functionality to run the updated executable and perform startup tests to ensure its stability. Design a rollback mechanism to revert to the previous stable version if the new version fails at startup. Incorporate signature verification for each new executable to maintain security and authenticity. Enable the ability for periodic automatic updates and the ability to turn automatic updates off. Expose your program to a REST api so that it can be operated and monitored from a local HTML Run the program as a SYSTEMD service on boot and monitor it's status Preferably use p...

...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...

Looking for a skilled and creative 2D animator to bring my humorous vision to life. As such, the animation should carry a comedic theme. The animation's expected duration is more than 3 minutes. I am looking for someone who: - Has experience or is comfortable with comedy-genre animation - Can create high-quality 2D animations - Can work on a prolonged animation of over 3 minutes - Can bring originality and creativity to the project. Experience in working on big projects is a plus but not a requirement. However, portfolios demonstrating skills in 2d animation, especially in humor-themed undertakings, will be considered preferentially.

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.

looking for Facebook ad account provider old account with no daily spend limit and ready to run ads no need to warm up

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...

Function is done, amend the label that is stored and the value show. Only with ftp

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 looking for a skilled individual who can help me read a file and extract specific data from it. Key Requirements: - Extraction of File names, File sizes, File creation dates, and messages stored in the DB file. - Ability to adapt to extracting all messages or specific ones, depending on my future needs. - Delivery of the extracted data in a Spreadsheet format, preferably Excel or Google Sheets. Ideal Skills and Experience: - Proficiency in reading and interpreting files. - Advanced skills in data extraction, particularly from database files. - Experience in delivering data in a spreadsheet format. - Flexibility to accommodate future changes in the extraction requirements. - Strong communication skills to clarify requirements and deliverables.

I'm looking to streamline our purchasing process through a high-level overview of our procurement policy and procedures. This document will be used by all em...procedures - Ensure it is user-friendly and accessible to all employees - Consider the use of diagrams or simplified processes to aid understanding - The document should be concise, focused on the main processes and steps without getting too detailed Ideal skills and experience for this job include: - Strong understanding of procurement processes and best practices - Experience in policy and procedure development - Ability to simplify complex processes for a wide audience - Excellent communication skills to ensure the document is clear and accessible to all employees - Previous experience with streamlining proce...

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

...site, and have it run every hour to capture new listings. Additionally, I would like duplicates to be automatically eliminated. Key Responsibilities: - Scrape for home addresses - Compile addresses in CSV format - Include the duration each house has been listed - Run the program every hour to capture new listings - Automatically eliminate any duplicate entrie - Run CSV file against another data base that has age and name of owner and contact info. Ideal Skills and Experience: - Experience in web scraping and data extraction - Proficiency in programming languages suitable for web scraping (e.g. Python, Scrapy) - Knowledge of CSV file creation and data handling - Ability to automate processes for regular data updates Please note that the addresses should be st...

...for 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 fai...

I'm looking for an experienced full-stack and OAuth expert to integrate OAuth authentication for Twitter, TikTok into existing React.js applications. You are responsible for implementing a seamless user authentication experience that allows users to connect their social media accounts to our platform. If authentication is successful, the user's social media profile information should be safely stored in the database. For example, when the user presses the "Twitter connection" button, the Twitter user information input field using OAuth appears, and when entered, the information is changed to the "connected Twitter". If you successfully complete this task, I will award you development of all parts of this project. I attached a screenshot Looking forwa...

...of success or error, considering 3 retries if the source rejects the connection. Finally, the information obtained from all sources can be queried from the frontend where the source of information for each record must be clear, and a functionality to visualize this information in a table with filters and sorting, or directly from the backend through a JSON API. When performing a new search, the stored information will be automatically deleted. Main Functionalities: 1. Custom API Parameter Configuration: Set headers, HTTP method, and data interactively. 2. Data Selection for Filtering: Allow filtering data by name, identification number, or both, to standardize information. The equivalent field in the endpoint to be queried should be placed alongside. 3. Data Mapping and Standa...

...of success or error, considering 3 retries if the source rejects the connection. Finally, the information obtained from all sources can be queried from the frontend where the source of information for each record must be clear, and a functionality to visualize this information in a table with filters and sorting, or directly from the backend through a JSON API. When performing a new search, the stored information will be automatically deleted. Main Functionalities: 1. Custom API Parameter Configuration: Set headers, HTTP method, and data interactively. 2. Data Selection for Filtering: Allow filtering data by name, identification number, or both, to standardize information. The equivalent field in the endpoint to be queried should be placed alongside. 3. Data Mapping and Standa...

I need an expert with solid experience with AWS services, particularly Elastic Beanstalk and S3. As part of this project, I require: - Deployment of two applications on Elastic Beanstalk within my existing architecture. - Set up of two S3 buckets intended to store app data and archive data. The data to be stored is expected to be in the medium range (1-10 GB). Therefore, the buckets must be optimized for this scale. Required skills and experiences: - AWS Elastic Beanstalk: It's crucial for you to understand and proficiently manage application deployment within my infrastructure. - AWS S3: You need to have expertise in creating and managing S3 buckets, specifically for storing application data and archiving purposes. The main aim of this project is to develop two S3 buck...

I am seeking a skilled SAP Fiori expert, particularly with experience in the Transactional Fiori app, to aid me in configuring an existing Fiori app on our SAP S/4HANA system. Key Requirements: - Creation of a substitution within Fiori app - The substitution should concatenate invoice reference, reason code, and customer information - Concatenated information should be stored in a text field in residual clearing Ideal Skills: - Proficient in SAP Fiori configuration - Strong understanding of SAP S/4HANA system - Experience with Transactional Fiori apps Your expertise in this area will be highly appreciated, and I look forward to working with a professional who can provide clear guidance and support in this matter.

...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...

...functionalities: - The user tier is 50 and the main focus of the web app is communication. We want to avoid communication with our members through WhatsApp and emails. Communication can be send through the web app to one, a group of members or all members with a specific role. - The different roles are: admin, staff, parent and kid. - Members can be managed in the web app (CRUD). Personal information can be stored by admin or staff, and a part of the information can be read by one or more members (of type parent). A parent can be linked with more than one members of type parent. - Members of type kid can be managed per season (CRUD) (ex. 2024-2025, 2025-2026, …), and a season contains about 34 sessions. Each saterday morning there are two sessions (psychomotor skills and b...

...Capabilities: The form must support file uploads specifically for image and document files. No video file uploads are permitted. - Auto-Response: Configure the form to send an automated reply once a customer fills it out. This reaction should reassure the client that their message has successfully been received. - Database Utility: Arrange for all submitted information through the form to be securely stored in a database. This will streamline tracking and handling of client queries. Details of the DB structure will be provided. - Security Measures: Implement Captcha security to filter out any potential spam or automated entries. - Skills Required: Deep understanding of HTML, CSS, JavaScript, and server-side scripting languages. Familiarity with database management and maint...

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.

...developer who can automate certain calculations in my existing Excel files. The calculations that are currently done manually in Excel need to be automated. This means the Python script you develop will need to accurately and efficiently perform these calculations every time it runs. As for the frequency, the system should run calculations on demand. This way, I can trigger it whenever I need the numbers updated. The calculations are based on the data currently stored in my Excel files. So the script will need to read this data, perform the necessary calculations and update the files with the new results. The ideal candidate should have: - Proficiency in Python - Experience in working with Excel files - Understanding of automation processes - Ability to write clean...

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.

...mediaDevices API to capture images from the device camera (focusing on iPhone users for this initial phase). Upon user interaction, the API will be used to request camera permission and capture an image. The captured image data (base64 encoded string) will be linked to the corresponding garden space object in the Pinia store. The image data will be stored locally within IndexedDB alongside the garden space information. Images should NOT be stored in the user's Photos app on their phone. 7. User Interface Considerations: The developer will utilize the already-designed and developed user-friendly interface for: Entering customer information Adding and managing garden spaces Viewing and editing estimate details The developer will add functionality for: Capturing a...

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

I need help to run an ad for my digital product. I'm looking for a freelancer who can showcase their previous work before I make a final decision. Your responsibilities will include: - Running a digital ad campaign for my product - Providing insights on the ideal platforms for the campaign - Showcasing your previous work in digital product ad campaigns The ideal candidate for this job should have: - Prior experience in running digital ad campaigns - An understanding of the digital product market - The ability to showcase previous work for my review

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 ...

You will get a solid consultation for developing a project from scratch or even an idea. In the Consultation you will receive: 1. Clarity in your thought process✅ 2. Knowledge about the design procedure✅ 3. Answers to your questions which are not letting you sleep✅ 4. Practical approach towards every problem solving✅ 5. Quick Support over call