Oracle sql label column queryKazi

...professional product packaging labels - Prior experience in designing product labels, especially for medical items, is a plus - Ability to deliver high-quality, print-ready designs in a timely manner - Understanding of SFDA regulations for medical product labels is preferred - Experience with medium-sized packaging is important The ideal freelancer for this project should have a strong portfolio of label design work and should be able to demonstrate their understanding of the nuances of designing for medical items. A meticulous attention to detail and the ability to work within given dimensions are crucial. If you have previous experience in designing product labels, especially for the medical industry, please feel free to share your portfolio or relevant work samples. Your ex...

Need to convert text file to a clean page and remove the colums showing passwords.

I'm in need of a highly skilled graphics designer who can create a cohesive set of design assets for my business. The project involves creating a logo, a flyer, and a product label. These designs need to be vibrant, eye-catching, and appeal to an adult audience. Key Requirements: - Experience in logo design, flyer design, and product label creation - Proficiency in creating professional, eye-catching designs - Understanding of color psychology and design principles - Able to work with a bright and bold color scheme - Previous experience in creating designs aimed at adults is a plus Your design work will be critical in helping my business stand out and appeal to our target audience. I'm looking for a designer who can bring a fresh, modern approach to the project, a...

I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?

I'm seeking an experienced Excel guru to help create / identify two specific formulas on my spreadsheet. This project is URGENT. The right excel Guru can probably figure this out in less than an hour. Easy money. The first formula is related to searching a cell for one of four words and populating an adjacent column with a correlating value, based on the word found. The four words to be searched for are "Low", "Medium", "High", and "Not currently a priority". The adjacent cells are to be populated with correlating values 1, 2, 3, and 0 (to generate a Score). The cells are currently blank, and users of the spreadsheet will fill these cells by selecting from a drop-down list (of these 4 words). The objective is to create a formula that co...

I'm in need of an experienced SQL Server data warehouse designer to help with a project of integrating and consolidating data from different sources. Key requirements: - Expertise in SQL Server: You should be able to design, implement and optimize data warehouse solutions on SQL Server. Understanding data warehouse design principles is essential. - Data Integration: You'll need to work with some of our developers / power users to source data and establish automated integration; experience with integrating relational databases and APIs from web services is crucial. - Data Consolidation: You should be able to create a cohesive, consolidated dataset from these different sources applying appropriate design principles. - Medium-sized project: The data needing in...

I need a simple, single-column WordPress site set up with the following requirements: - The site will need to be built from a provided WP demo content folder, including plugins and theme. - The main content will be of a standard, text and image-based nature. - The site design should be a straightforward single column layout. For this project, you would need: - Proficient skills in WordPress - Experience with SCSS - The ability to set up a local site - Familiarity with migrating WordPress sites Please ensure you can work with the provided WP demo content folder as the basis for the site.

...focus is on expenses. Here is what I require: - Just the expenses data extracted from the Excel file and made available for the creation of a pivot table. - You'll need to determine the format of the data in the Expenses column. Your skills and experience: - Advanced knowledge of Microsoft Excel, especially in working with different types of data. - Proven experience in handling financial data, specifically expenses. - Ability to interpret varying formats of data on Excel. - Good problem-solving abilities, given that the specific format of the data in the Expenses column wasn't provided. If interested, please provide a portfolio showcasing your past work relating to Excel and financial data management. Your ability to deliver quality and accurate work will b...

Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.

I need a label template for my natural health supplements, which are bottled in 500ml containers. I have all the necessary details such as the product name, ingredients list, dosage instructions, and my logo, but I require assistance in creating a professional and appealing label. Key Requirements: - Design a label template for 500ml bottles - Include the product name, ingredients list, dosage instructions, and my logo - The label size should be 200mm by 60mm - The design should feature a black background with a gold logo and either gold or white writing - The finished template needs to be in a format I can edit Ideal Skills and Experience: - Previous experience in label design, particularly for health or food products, would be highly advantageous - Pr...

Note: Budget Fix 2000INR and time line 5 Day's I have a project currently in Codeigniter 3, and I'd like it converted to Laravel 10. This pro...will require thorough understanding of both frameworks, and it's crucial that all existing features and functionalities are precisely replicated in the new version. While I don't have specific features to prioritize, I will identify specific elements as the project progresses. Skills and experience required: - Profound knowledge in Codeigniter 3 and Laravel 10 - Expertise in PHP development and SQL databases - Proven experience in similar conversion projects Note: The finalized budget for this project is 2000INR. Please only bid if you can work within this budget. The timeline for project completion can be discussed d...

I've got a PDF file of a label design that I need expertly converted to a CDR format. I require this to repurpose the design, no other editing or resizing needed. The job entails: - Keeping the exact layout and design of the label - Conversion from PDF file to CDR format The label's dimensions remain the same, only a format conversion is required. Ideal freelancer will be proficient in: - Graphic Design - CorelDRAW - PDF Conversion Previous experience with label designs and file conversions will also be beneficial.

I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS

I need an experienced graphic designer to create a label for my mandarin product. The main information to be included is the product name, ingredients, and nutritional information. The primary purpose of the label is to comply with regulatory requirements and to provide accurate information to consumers. I need this project completed as soon as possible. Ideal Skills and Experience: - Proficiency in graphic design software - Understanding of food labeling regulations - Ability to deliver quality work under tight deadlines - Prior experience in creating product labels, particularly for food items, is a plus

I'm seeking a skilled graphic designer to help with the design of my sock Logo. I already have a file for the start of it. Need help with creating a Label for my socks. These images and fonts will also be used in my website. Ideal candidate will have: Experience with logo design. I do need ASAP. I can share examples of sock labels that draw my attention to give you an idea of what I am looking for.

I have wine labels for 3 different wines, each with a front and back label. I need these labels converted to Avery labels in the 95.5 x 65mm R size (8 per sheet). Key requirements: - Conversion of 6 label designs to Avery labels - Expertise in working with InDesign and PDF files - Attention to detail to ensure accurate label placement - Familiarity with Avery label templates This project is for personal use, and I already have all the necessary files. I'm looking for a skilled professional who can complete the task efficiently and accurately. If you're confident in your capabilities, please provide information on your experience with similar projects and an estimated cost for this job.

Please make wordpress site as atteched image. 1 column and respoinsive design.※If possible,bootstrap design. Anything is include dummy text and dummy images. I make inquiry and faq,sitemap page by myself and send you wordpress login details. Required Pages:Top page,fx,crypto-ex page,1 currency detail page Please make within $120(absolute requirement) and delivery within about 2 weeks and give me a progress report every about 4 days. I think only the table part is a little more challenging.

...high-complexity T-SQL stored procedure used for data analysis that I need translated into PySpark code. The procedure involves advanced SQL operations, temporary tables, and dynamic SQL. It currently handles over 10GB of data. - Skills Required: - Strong understanding and experience in PySpark and T-SQL languages - Proficiency in transforming high complexity SQL scripts to PySpark - Experience with large volume data processing - Job Scope: - Understand the functionality of the existing T-SQL stored procedure - Rewrite the procedure to return the same results using PySpark - Test the new script with the provided data set The successful freelancer will assure that the new PySpark script can handle a large volume of data and maintai...

...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...

Our ex...script is encountering issues when importing the exam's section breakdown from a .dat file. Due to this, we are unable to import the breakdown of results per section of the exam into the SQL database. We are seeking a proficient developer who can: - Analyze our existing CGI script and identify the cause of the breakdown import issue. - Provide actionable advice and steps to troubleshoot and resolve the problem. - Ensure the script effectively imports the section breakdown from the .dat file as intended. The ideal candidate for this project should have: - Extensive experience in CGI scripting and SQL database management. - Proficiency in handling and troubleshooting data import/export issues. - Ability to work quickly and efficiently, as we need thi...

I'm looking for AI-generated images to be used as a background on my website. The images sho...pink tape graphic above. Features six mannequin heads, each demonstrating a measurement technique: Circumference: Side view with tape around head above ears. Label below in black. Front to Nape: Side view with tape from forehead to neck's nape. Label below in black. Ear to Ear Across Forehead: Side view with tape across forehead from ear to ear. Label below in black. Ear to Ear Over the Top: Side view with tape over head from ear to ear. Label below in black. Temple to Temple Around Back: Side view with tape around back from one temple to another. Label below in black. Nape of Neck: Back view with tape across the neck's nape. Label below i...

I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

I'm in need of a talented designer to create a label for my chemical and coatings product. The label will be used for product packaging. Key Requirements: - The design should be industrial in style, conveying a sense of reliability and professionalism. - It needs to be suitable for use with chemical and coatings products, so should reflect this in its visuals. Ideal Skills & Experience: - Experience in label design, particularly for industrial or chemical products. - A keen eye for detail and ability to create designs that are both aesthetically pleasing and practical. - Understanding of the importance of conveying the right message through design. This is a great opportunity for a designer looking to add an industrial label design to their portfoli...

...Development: Use HTML, CSS, and JavaScript for the frontend, with frameworks like React or Angular to enhance the user interface. Backend Development: Python with Flask or Django for server-side logic, handling API integrations, and user data management. Machine Learning: Use TensorFlow or PyTorch for building the recommendation engine, and NLTK or similar libraries for sentiment analysis. Data Management: SQL or NoSQL database to store user profiles and their preferences. Version Control: Git for source code management and collaboration. Submission Requirements: Code: Source code with comprehensive comments detailing the functionality of each part of the system. Documentation: A detailed documentation covering the system design, implementation details, and instructions for setti...

I need a knowledgeable freelancer to set up the infrastructure for an OCI data warehouse on Oracle Cloud. This platform will be used for data analysis, reporting, and data storage. The scope of the job will include: - Configuring the Oracle Cloud to host the OCI data warehouse - Ensuring the system can handle storing and managing customer information, sales data, and inventory data A background in cloud computing, notably with Oracle Cloud and data warehouses, will be instrumental to the success of this project. Experience in handling similar types of data is a plus. This job requires someone who understands the nuances of OCI data warehousing and can deliver a reliable, efficient system.

...reporting, complex SQL formation, and more. The primary purpose of the project is to streamline and enhance our data storage capabilities. By integrating new data into our warehouse on a monthly basis, we aim to improve our decision-making and business performance through enhanced data access and analysis. Key responsibilities include: - Reviewing and providing recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex ...

...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...

...Architect/Lead Developer specializing in Netezza and Oracle databases. The ideal candidate will be responsible for designing, implementing, and maintaining database solutions that meet the needs of our organization. This role requires strong technical expertise in both Netezza and Oracle platforms, as well as leadership capabilities to guide a team of developers. Responsibilities  Design and implement efficient database solutions for our organization, leveraging Netezza and Oracle technologies.  Lead a team of developers in the implementation and maintenance of database systems.  Collaborate with other stakeholders to gather requirements and define database architecture to meet business needs.  Optimize database performance through indexing, query optimi...

...-if you mess up, that is OK, but then you must edit the video. (there is no negative to a video with many edits/cuts) If you rehearse it 2X and then record, it takes about 11 minutes. Total time to perform is approximately 35 minutes... So less than 1 hour Here is the google sheet that is a "conceptual guide". For each row, it tells you how many signs are needed for that row (See” count" column).... (many are done with LEFT and RIGHT hand). In some cases signs are moving vs static and it shows you the "States" of the specific sign. Again, this is a conceptual guide but the example video is what you want to use as a reference. https://docs.google.com/spreadsheets/d/14PJe9FmxsQXvaq-Rm7r1MjD0AjMEfFHocKeVYDtQTDg/edit#gid=10251319 More import...

I have to transfer data and tables from oracle to postgres.

I'm seeking a Junior AI Oracle Developer to assist with market trend analysis in the cryptocurrency space. The primary focus for this project is Python. Key Responsibilities: - Utilize Python to create AI-driven models for market trend analysis in the cryptocurrency sector. - Conduct in-depth research and data analysis to inform these models. - Regularly report on market trends based on AI insights. Ideal Candidate: - 1-2 years of experience in AI and Python. - Strong understanding of market analysis and trends, particularly within the cryptocurrency sector. - Prior work with Solidity, TensorFlow, PyTorch, or Keras would be beneficial but not essential. - Ability to adapt and learn quickly in a fast-paced environment. Please be prepared to share examples of your work or por...

Looking for a Senior BDA with experience in. AZURE SQL SERVER. English mandatory. 1d per week helping to improve and maintain our main DBs.

I'm in need of a competent developer who can set up a script in my Airtable app to seamlessly integrate with the Aftership API. The main goal of this integration is to automate the process of generating DHL shipping labels. Key Responsibilities: - Utilizing ...retrieval and distribution as needed. Skills and Experience Required: - Proficiency in JavaScript is a must. - Prior experience working with Airtable scripting and API integrations. - Familiarity with Aftership and Zapier would be beneficial. - Understanding of DHL shipping label generation processes. It's important that the chosen freelancer has excellent communication skills and can deliver a seamless integration that works reliably and efficiently. Useful Link

...experienced course creator to develop a comprehensive video tutorial focused on Microsoft Power Query. Key Features: - User-friendly interface - Capabilities to import data from various sources - Customizable course structure The ideal candidate should have the ability to break down complex concepts and make them easily understandable. The course content should cater to beginners and intermediate level learners. Course Duration: Each video course module should be crafted with the target of a total duration amounting to 3-4 hours. This could be composed of several shorter lessons or modules, for easy consumption and better learning experience. Required Skills: - Strong knowledge of Microsoft Power Query - Proven experience in creating video courses - Excellent communi...

I'm in need of a skilled graphic designer to create product labels for my target audience of adults. The core task: - Conceptualize and design product labels that resonate with the adult demographic, ensuring they are visually appealing and impactful. Desired Skills: - Proven experience in designing product labels for print - A keen understanding of adult consumer behavior and preferences, enabling you to create designs that are both attractive and effective - Proficiency in using graphic design tools and software Budget is negotiable based on your experience and proposed approach. Please share your portfolio of similar work when applying.

I'm in need of a skilled graphic designer to create product labels for my target audience of adults. The core task: - Conceptualize and design product labels that resonate with the adult demographic, ensuring they are visually appealing and impactful. Desired Skills: - Proven experience in designing product labels for print - A keen understanding of adult consumer behavior and preferences, enabling you to create designs that are both attractive and effective - Proficiency in using graphic design tools and software Budget is negotiable based on your experience and proposed approach. Please share your portfolio of similar work when applying.

...developer. To qualify you must be full stack and conde in . , .NET ASP WEB API + MS SQL Details of our current project STACK can be seen here -> Prerequisites: For this optimization task you can bid your normal hourly rate but for the long term project the starting wage will be as stated below. 1) Accept initial hourly rate of U$5.00 2) Accept and start work immediatly 3) Have MINIMUM OF 20+ hours a week for long term ongoing support and development. 4) If you are awarded the project accept IMMEDIATELY 5) Work hours: predominantly 20:00 to 02:00 (UTC -3 Brazil TIME) 6) Be available to work on weekends. Our projects use: GITLAB -> , ag-grid, C#, .NET API, MS SQL 2017 , WooCommerce digital product sales This is for ongoing long term development and we

I am looking for a cloud engineer who can assist with deploying an ASP.NET Web Form application on a Windows Server 2022 on VPS. Key Requirements: - The SQL Server DB and ASP.NET Forms have already been set up on the VPS Windows Server 2022. The main task is to ensure the successful deployment of the ASP.NET Web Form application. Additional Details: - The cloud provider I am currently using is WABYNE. Ideal Skills and Experience: - Proficiency in cloud engineering and deployment processes. - Experience with ASP.NET Web Form applications. - Familiarity with Windows Server 2022 on VPS. - Knowledge of SSL certificate installation, database configuration, and firewall settings is a plus. Please provide your relevant experience, certifications, and portfolio when applying. Your app...

...existing selecting and hiding function. Add the possibility to modify size and side of the lateral windows (Lexicon and Definitions): -The cursor would become a double-arrow when passing on the edge of the window and it could be resized. Showing children-objects without their parent: -Hiding the parent hides the children, but showing a child should only show the parent if the child is a label (suffix '.t' and '.s') Showing the bonus collections in the first pop-up when right clicking a structure in the 3D space -Instead of RMB>Structures>...; these structures would appear directly with the other options (Hide; Isolate;...) Advanced mission (Estimated 200 euros): Create widgets to open the atlas on a particular structure from a link: -A s...

...seeking a skilled full stack developer to help with a web application project that I'm working on. The ideal candidate should be proficient in JavaScript and .NET, with specific experience in Angular and SQL Server. Key Skills and Experience: - Proficiency in JavaScript and .NET. - Strong knowledge of Angular and SQL Server. - Previous experience in developing web applications. - Ability to work collaboratively in a team setting. Responsibilities: - Develop the front-end using Angular. - Design and maintain the back-end of the application using .NET. - Ensure seamless integration of SQL Server for database management. - Conduct thorough testing to guarantee the application's functionality. This is a great opportunity for a skilled full stack developer t...

...and converting it into JSON format. The PDFs, such as the example provided here, vary in format and column structure based on their categories. The solution should not require downloading the PDFs manually. Sample URLs Requirements: - Develop a tool or API endpoint for extracting data from PDF files located at given extracted PDF table data into JSON format. - Handle various PDF formats with different column structures. - Preferred tech stack: PHP (Laravel), Node.js, or Python. - Ensure robust error handling

Fix related issue in the module. Authentication, column view issue. Able to follow to fix one by one and with ftp

...facilitate data literacy within the organization. Continuous Improvement: Stay updated with the latest Power BI features and healthcare industry trends. Continuously seek ways to improve reporting processes and tools. Qualifications: Proven experience as a Power BI Specialist, preferably in the healthcare industry. Strong proficiency in Microsoft Power BI, including DAX and Power Query. Experience with healthcare data and understanding of healthcare metrics and terminology. Excellent analytical and problem-solving skills. Strong communication skills, with the ability to explain complex data concepts to non-technical stakeholders. Experience with data integration from various sources such as EHR systems, practice management software, and patient feedb...

I am seeking a skilled designer to create a label for a brown amber glass bottle with dropper. The label will be used for a pharmaceutical product - read all the requirements before submitting and get inspired by the images provided, let’s see if you can make something better ! Whoever gets awarded will be hired for future branding images of this product. Brand name:Hap Melon Flavor: watermelon __________________________ •Design Requirements: - The design should give a sense of 'deliciousness'. Make it neat, clean, fresh, while playful keep it elegant, reflect a reliable Pharmaceutical grade. •you agree to 100% original, customized design, (revisions until complete satisfaction) > No clipart, no readymade template > client will ow...

...JSON data set that I need to work with in Oracle 12c. It contains nested objects and I need to extract specific values from these objects. select json_query('{ "validationResults": { "errorMessages": [], "status": "PASS" }, "clearanceStatus": "CLEARED", "clearedInvoice": "PD94bWwgdmVyc" }','$.validationResults') as aaa from dual; Key objectives and requirements: - Retrieve data from nested objects: The data set contains nested objects and I need a solution that can delve into these structures and retrieve the desired values. - Aggregation of values: Once the data is extracted, I need it to be aggregated in a specific way. Skills and experience sought: - Pr...

I have an image that I need modified to include the word "awesome" imprinted right at the center. The word should be clearly visible but well integrated into the picture, creating a unique and eye-catching effect. For this project, I also need the iconic 'Parental Advisory' label added to the bottom left corner of the image. Skills and experience needed: - Graphic design expertise, specifically in image manipulation and text integration - Ability to blend text seamlessly with images - Understanding of visual aesthetics and design principles, to ensure the final image is both striking and professional. Please provide samples of similar work in your bid.

...have previous experience monitoring communities, and are not shy about getting applications/leads for the platform/results. Be a part of building the two next big global kpop sites. The ideal candidate is already in the kpop scene/keeps up with kpop. A good knowledge of what makes a good singer / dancer is preferred. Important that you are detail-oriented and a fast learner. If interested please label your application "Kpop VA Needed - [Your Name]" and answer these questions below in numerical order: 1) Are you interested in Kpop? Write a little bit to showcase your knowledge. What online communities are you part of? 2) What makes a good dancer? Good singer? Good performer? 3) Leave your resume and explain your previous background. Highlight any previous background y...

I'm searching for a proficient Go coder to develop a software application tailored for the Linux platform. Key requirements include: - Proficiency in the Go programming language - Proven experience in s...requirements include: - Proficiency in the Go programming language - Proven experience in software development - Keen understanding of the Linux operating system - Network programming - Geneve encapsulation - CoreDNS development Looking for Go programmers with strong networking background to write a DNS handler plugin for CoreDNS which can receive Geneve packet from client, decap the underlying DNS query in UDP or TCP or DoH preform DNS resolution as normal through the built in forward plugin. On the response side the plugin must be able to encap back to Geneve and res...

I'm in need of a creative, colorful label design specifically for my canned goods line. Key requirements: - Prominent space for nutritional information. - Inclusion of our company logo. - A vibrant, colorful style. Ideal candidates will have experience in graphic design, with a proven track record in label or packaging design being a significant plus. Familiarity with the food industry, especially canned goods, would be highly beneficial.