Select statement in pl sql blockJobb

Hej Amr S., jag la märke till din profil och skulle vilja erbjuda dig mitt projekt. Vi kan diskutera detaljerna över chatten.

Till en nygrundade företag inom social entrepreneurship behövs det skaffas en SQL databas samt back-end mask till data query och entry, och en mindre front-end sökmask. Detailerad lista på databas-råder och egenskaper såväl som mockups på aller masker finns. Webspace med möjlighet till SQL databas finns. Detta är prototyp-stadien till en större projekt och rätt programmerare kan blir anlitad även till vidare arbeten med databasen, back- och front-end maskarna, samt senare utveckling av sökmask i app-form och enkelt web-shop kopplad till databasen.

Jag behöver en databas (SQL script) som håller reda på Medlemmar och dess Vänner, samt Kontakt/Meddelanden som skickas mellan dem: - Medlemmar (Namn, Mail, Lösen, Mobilnr., inloggningssätt (Facebook, Google, ösen)) - Medlemmars olika relationer till Vänner (mobilnr., mail, namn, adress) - Tabell över kontakter/meddelanden som tagits med Vänner (GUID skapas för varje gång). - Möjligheter för Vänner att logga in med hjälp av GUID för att se meddelanden - Meddelande skall kopplas mellan Medlem och Vänner. - Medlemmarna skall kunna ha en elektronisk plånbok

Project 1av 2(sql fler fields) skickar den andra projektet under dagen Har ändrat pattern1&pattern2 columnerna i databasen till kundnr&country, id till uid, verkar fungera. Sedan har jag ändrat field1&2 till flera columner i results.html. Så här ser columerna ut i databasen. id, kundnr, country, searchstring, tiff, checked, vat_number, company_name, company_adress, invoice_date, invoice_nr, valuta, summa_netto, summa_moms, varukod, varu_underkod, sprak_kod, beskrivning, fakturatyp, skattenummer

Mac PHP Har byggt en första version av en sajt som låter användare logga in och ange/ladda upp data. PHP/Mysql är använt idag. Skulle i dagsläget behöva primärt ett bollplank kring databasstruktur och koden principiellt men även hjälp med faktisk programmering för vidareutveckling av tjänsten. säkerhetsaspekter är också viktiga i nuläget

Söker back end utvecklare med erfarenhet från skräddaranpassade CMS hemsidor. Du bör vara kunnig inom PHP, Web 2.0, XHTML, SQL, Cross-browser optimering. Utvecklingen av hemsidan bör göras med stor anpassning. Då majoriteten av publiceringen görs av redaktörer måste backend vara anpassad för exempelvis skapande av artiklar. Du kan utgå från ett open-source alternativ och vidareutveckla den enligt våra specifikationer. Integrering mellan hemsidan och databas måste göras av dig. Analytics program erfordras. Interaktion görs möjligt med commenting, threads och forum. Erfarenhet från schemaläggning av aktiviteter bör du kunna göra. Caching även. Säke...

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Programmering av ett Iphone och Android telefonapplikation kopplat mot telefonväxel MS SQL och winows server. Funktion och design ingår. Erfarenhet av applikation som contact center, callcenter. Samtalsstryning och design. Lång erfarenhet och stor förståelse krävs.

Today most companies gets flooded by marketing opportunities in various forms; get a new website, advertise in this magazine, optimize your googlepresence, sponsor this or that and many companies are just flushing money down the toilet. Some jump on an offer merely to get rid of the salesperson, others truly believe that it will have a positive effect on sales, 99 % have the same thing in common - they have no clue if it actually produces any result. With some of the sharpest minds in psychology, marketing and finance we have developed a system that reduces waste and guarantees at least a 20 % increase in results. That might not sound like much, but ask any company if they would like to add 20 % on their bottom line with the same kind of expenditure, ...

We're reaching out ...imperative that the person we select for the job has a proven record of producing high quality copy. The content produced will set the standard of our textual communication in terms of bringing out the quality and relevance of the products and ultimately forming the "right touch". Who you are You are motivated to engage our customers with your texts in an innovative and creative way. You make the reader feel involved. You understand and implement texts based on SEO requirements. You transform an already existing text to something unique and fun to read. You focus on the quality of the content, not the number of words. You find it important that your texts do not contain any spelling, grammatical or formattin...

Skapa en header navbar (Röd med vit bold text) med namn devilsuited (center) Och body backround svart. Gå till Youtube besök min Youtube kanal embed mina första tolv heads-up videos. Skapa two-column Layout (ui-grid-a, two columms 50%/50% Corresponds To ui-block-a|b) önskemål om du kan skapa att varannan är two columms 50%/50% där två videos visas bredvid varandra. Om du kan göra dem till 170/120px. Och sedan vill jag ha en annons på 340/240 px som visas 100% nedanför sen two columms 50%/50% tills du kommer upp i de tolv video. (Jag laddar upp banners till dig) Jag vill att när man klickar på en video att den tar upp hela skärmen och att man kan kryssa ner och komma tillbaka till sidan...

...needing admin oversight for every user. 2. Document Upload Section: Users will need to upload PDFs in this area. 3. User Profile Page: This should encompass all required sections, including Name, phone, email, and social media links. 4. Support Team Block: Displaying the Name, Title, and Picture of our team members. 5. 14 Steps Progress Section: Users will click on step one to view remaining steps. Profile Items; User Name Surname / Language / Time Zone / Notifications / Contact Informations / Origin & Destination / Relocation Address / Family Members & Pets Ideal Skills: - Proficiency in front-end and back-end development - Experience with creating user interfaces and admin consoles - Knowledge in handling user data and document upload systems - Ab...

I'm experiencing issues with data modelling in a project involving data sources from Dynamics CRM Dataverse and SQL. The primary goal of this project is to facilitate data analysis. As such, I need assistance with: - Data Integration: Combining data from multiple sources to create a comprehensive dataset for analysis. - Descriptive Analysis: Applying techniques to summarize and interpret the data. The tools being used for this project are Power BI for data analysis. Therefore, experience with Power BI is crucial. Ideal Skills: - Proficient in Power BI - Experience with data integration from Dynamics CRM Dataverse and SQL - Strong skills in descriptive analysis techniques - Data modelling expertise

I'm experiencing an issue with a combobox in my MS Access database. It's directly bound to TableA and supposed to select entries from Column A. When an entry is found, it should concatenate Column A and Column B and insert the result into Column C in TableB. However, my VBA code keeps throwing an 'Entry Not Found' error, even though I have confirmed all entries are in TableA and all formats are correct. Key Tasks: - Troubleshoot the combobox issue - Optimize the AfterUpdate VBA code I need a freelancer with strong skills in MS Access and VBA, who can help fix this issue and ensure the combobox can correctly select entries from TableA. Please note, I am not using any filter criteria on the combobox data.

I need an experienced SEO professional who can help me boost my website's domain authority through effective guest post backlinking. You will have the freedom to select the websites for the guest posts, but I expect high-quality, reputable sites that will genuinely contribute to improving my site's authority.

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

...designer to create a detailed model of a speargun in Plasticity 3D. Key Aspects: - The speargun should feature an anatomical handle. - It must be an inverter roller type, drawing inspiration from Gladiator spearguns, Shadow separguns, and Allemani models. - The trigger should be modeled after the Ermes sub, complete with a reel. Specific Components to Highlight: - Overall body with rubber bands. - The design of the handle. - The trigger mechanism. - The attachment for the reel. Design Requirements: - I need the designer to create the anatomical handle from scratch, as I do not have reference images available. - The design style for the handle should be ergonomic and sleek. Ideal Skills: - Proficiency in Plasticity 3D is essential. - Prior experience in designing...

...these features: 01. It is a web based system with a login. 02. It has 2 entities - admin and people. 03. An admin will always be able to locate a person. 04. The admin can form a group of a few people. 05. If any of those people come nearby, the admin will be notified by sms. 06. In past also, if those people had come nearby, admin will be informed. 07. The admin can define a set of interesting places. 08. If any person visits any such place, the admin will be notified by sms. 09. If any person had visited any such place in the past, the admin will be informed. 10. The admin can see the location history of any person of any period. 11. E.g. the admin can see where a person visited between Jan 2024 and Mar 2024. (Mind you, we are just building a presentation at this moment...

I'm seeking an ex...weight/dimensions. Fee Calculator: Real-time fee calculator, considering: Product cost. Domestic and international shipping fees. Additional fees (handling, consolidation, etc.). Options to select product variations (size, color, etc.). Shipping Options: Multiple international shipping methods with estimated times and costs. Integrated shipment tracking. - Payment Processing: The site should exclusively integrate with Stripe for payment processing. - Responsive Design: The website needs to deliver a consistent and interactive experience on both mobile and desktop devices. Ideal candidates should have rich experience in developing e-commerce platforms or similar projects. Please share your portfolio with examples of similar work and your estimated ...

...nonprofit organizations. The primary purpose of the website is to facilitate donations. Key Features: - A homepage that clearly presents our mission statement and goals. (gallery, articles) - A robust and user-friendly donation function with options for bank cards, paypal, stripe, cryprocurrencies (optional, but preferred) - A recurring donation option - Suggested donation amounts - A feature for sending personalized thank you messages (optional) - A small eCommerce section for T-shirts, and smaller fan articles (optional) Skills and Experience: - Proficiency in web development, specifically for nonprofit organizations - Experience in integrating secure and effective donation systems - Ability to create clear and engaging mission-based content - ...

I need a modification in my PrestaShop 8.2 backoffice. Specifically in the products-tab under combinations. The requirements are as follows: - Implement an alphabetical sorting feature for the list of combinations. - The sorting must be applied to the following attributes: Size, Color, and Material. - Insert a checkbox in the button to select all combinations at once. This feature should work like the current functionality when generating combinations. Please note that the alphabetical order feature is needed only for combinations, not for attributes. Ideal skills and experience for the job: - Proficiency in PrestaShop, particularly version 8.2. - Strong understanding of eCommerce platforms and backoffice management. - Experience in customizing...

I have a web application built in ASP.NET approximately 2–3 years ago that was never finalized. I have the source code and am looking for an experienced developer to further develop and optimize it, especially for mobile devices. Additionally, I want to enhance its functionality by adding new menus, reports, and a simple Business Intelligence (BI) dashboard for data visualization. Key Requirements: Mobile Optimization: Ensure the application is fully responsive and user-friendly on mobile devices. Enhanced Features: Add new menus and allow reports to be previewed in a visually appealing way, integrating data visualization elements like charts and graphs. SQL Integration: I will provide SQL queries for the necessary data. You will integrate th...

...develop portable USDT Flashing Software in Tron network. The requirements are mentioned below, 1) The software can perform flash of the usdt, as well as the flashed usdt should be transferable from/to unlimited wallets with blockchain confirmations is appreciated. Since it is flash btc it must be visible in BTC wallet address for at least 90 days. There will be no transaction fee while sending from "flash s/w" to "btc wallet" as it will be no confirmations. There will be no limitation for daily transfer for usdt It can’t be tracked as fake transaction. Should take normal time to send btc one wallet to another wallet in normal internet connection. 2) These usdt will disappear after 90 days. (Negotiable) Note:- There should be some optio...

...needs review of paperback spine width. Freelancer who designed cover may not have calculated the correct number of pages for spine. Please also check bottom text to see if in “cutting” area. eBook Cover please check bottom text location on cover. I self publish on Amazon KDP, and upload my own files. New book is being formatted right now. It will be finished in a few days. Please quote this project. I will be writing 2-4 books this year. Author Christian Contemporary Fiction and Romance Christian Contemporary Fiction, Life Coach, Relationship Coach, & Freelance Writer. I prefer to work with a Freelancer in the US. I live in Charleston, South Carolina, USA. Skills needed book cover design, graphic design, paperback cover design and eBook cover...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

I am looking for a Python developer who is also proficient in Pine Script, as I need the developer to create two Python functions. The first function is for BOS_CHOCH, and the second is for Order Block. These functions are derived from LuxAlgo's SMC Pine Script code. I will explain the details further in messages. Please bid only if you are familiar with Python, Pine Script, and the basics of Smart Money Concepts..

I need a seasoned Bu...workflows, and functionality for my food delivery web app MVP. The visual designs and pages are already created in Bubble, so your primary focus will be on setting up the backend, workflows, and database logic. Key tasks include: - Implementing User Authentication and Profiles - Setting up Order Tracking and Status Updates - Integrating Payment Processing The app will primarily support customers as the user role. Your responsibilities will also include enabling customers to: - Browse and select meals - Place and manage orders Ideal candidates should have extensive experience in developing with and a strong understanding of creating backend logic and workflows. A background in building food delivery apps or similar projects would be a ...

...receive invites and updates via notifications and calendar integration. Target Users: General users within the organization requiring conference room access. Admin users responsible for managing conference room resources. Technology Stack: Mobile Application: Cross-platform (iOS and Android) using React Native. Back-End Website: .NET Core MVC Razor Pages for admin management. Database: Azure SQL Database for secure data storage. Cloud Deployment: Azure App Service for web deployment and Azure Container Instances for API services. Goals and Objectives: Streamline the process of booking and managing conference rooms. Improve resource utilization and reduce scheduling conflicts. Provide a user-friendly interface with real-time updates and notifications. Ensure secure a...

...from the link: If you can't get the app, just note down the latitudes and longitudes of the location when you're there and get simple pictures. 2- Get the verification forms filled, signed and stamped by the HR or relevant authority of these locations. 3- Get the details of verifier that is their name, designation, Department and Contact. 4- In case of refusal to fill form, take the written refusal statement with stamp or sign as a proof. If they don't give written, ask them that you want to record them saying their reason and take their details like name designation contact etc. If both isn't possible, just take their details like name of person whom you met, their designation, contact, or their visiting card. 5- If locations is not found on given...

Objective of the task: inventory of the entire sheet of the basic map of a fragment of Ursynów, Warsaw, Poland, including all of the elements of land development. Task content: Georeference the base map based on the files in the Ursynów folder () with an accuracy of 10 cm (use a minimum of 44 geodesic crosses). Remember the frame data and coordinate system (2000-PL). Create a file geodatabase to store all object classes. Create layers (feature classes) within the geodatabase and vectorize all of them objects visible on the base map, i.e. buildings, trees, lawns, roads, slopes, stairs, elements buildings, sheds, garages, sandboxes, waste bins, etc. (minimum 15 layers). There can’t be any empty spaces so choose the layers to vectorize wisely. After vectoriz...

...multiplayer mobile game in Unity, and I need a freelancer to create fully functional pages for the game. The pages will include: - A casual-themed company page - A 'warzone-like' background for the login page with Google, Facebook, and Twitter login options - A character creation page where players can customize their appearance, select abilities, and change outfits, with a system in place to prevent name duplication - A home screen with options to play, visit the reward store, invite friends, and engage in global or private chats,and buy store The ideal freelancer should have experience with Unity and Blender, with a strong understanding of game UI design. The background of login page or home page should be unique and whatever character created...

...multiplayer mobile game in Unity, and I need a freelancer to create fully functional pages for the game. The pages will include: - A casual-themed company page - A 'warzone-like' background for the login page with Google, Facebook, and Twitter login options - A character creation page where players can customize their appearance, select abilities, and change outfits, with a system in place to prevent name duplication - A home screen with options to play, visit the reward store, invite friends, and engage in global or private chats,and buy store The ideal freelancer should have experience with Unity and Blender, with a strong understanding of game UI design. The background of login page or home page should be unique and whatever character created...

...& Engineer Job Type: Freelance / Remote Experience: 4+ years in Azure Cloud architecture and implementation Job Description: We are seeking a highly skilled Azure Cloud Solutions Architect & Engineer with comprehensive expertise in Azure infrastructure, security, networking, identity management, automation, and scripting. The role involves designing, implementing, and managing a secure and scalable Azure environment using best practices such as Landing Zones, Management Groups, CI/CD pipelines, and Infrastructure as Code with Terraform. You will be responsible for managing Azure Virtual Desktops (AVD), automating workflows, and ensuring security and high availability across Linux and Windows environments. Additionally, expertise in Azure Security and Azure S...

...featured packages and offers. Highlights of unique selling points (e.g., Holi packages, jungle safaris, etc.). About Us: Information about the company, its values, and mission. Tour Packages Page: Detailed listings of tour packages with itineraries, inclusions, exclusions, and pricing. Filters for users to search based on destination, duration, or cost. Booking System: Option for customers to select packages and make bookings. Integration of Razorpay for secure online payments. Automated email confirmation for successful bookings. Photo Gallery: High-quality images of destinations and previous tours. Testimonials Page: Display of customer feedback and experiences. Contact Us Page: Contact form for inquiries. Display of phone number, email, and office address. Integration wi...

Hi, we need translators for English to Bahasa Indonesian language for a technical document. Pl write if you are natve and experienced. Thank you.

As a Social Anthropology student at a UK university, I am in need of an experienced tutor or specialist to assist me with an essay exploring the concept of the social construction of diseases within the field of Medical Anthropology. Your role will primarily focus on helping me with: - Structuring and organizing the essay - Formulating a compelling introduction and thesis statement - Constructing body paragraphs and arguments - Crafting a concise conclusion and summary I am particularly interested in someone with a strong academic background (Master’s degree or higher) in Social Anthropology, Medical Anthropology, or related disciplines. A solid understanding of UK academic standards is crucial. Experience in academic writing, research methodolog...

Below is an overview of how you can build a **digital signage system**—similar in concept to ScreenCloud—that allows restaurants and other businesses (or your own team) to remotely manage and display content (images, videos, menus, prices, ads) on screens located in various places. We’ll break it down into key components, approaches, and technical considerations. --- ## 1. High-Level System Architecture 1. **Cloud-Based Management Platform (CMS)** - A web-based dashboard (for restaurants, your company’s internal users, etc.) to upload designs, videos, text, and schedule content for specific screens or groups of screens. - A backend server (API) to store and manage all the content, user information, screen configurations, etc. 2. *...

I'm seeking an expert in setting up Google Cloud, AWS EMR, and Apache Airflow. Your responsibilities will include: - Setting up infrastructure: You'll need to build a robust and scalable cloud infrastructure tailored to our needs. - Writing custom scripts: This will involve scripting in Python to meet our specific data handling requirements. - Data processing workflows: You will design and implement efficient data processing workflows using Airflow. Main project is to create views from google bigquery dataset and read it in aws emr using Workload identity federation ,create airflow jobs and then dump it to sql server. Shall be expert in terraform scripting as well Your expertise in these areas will be critical to the success of this pro...

I need a professional resume tailored for a mid-level Data Engineer. The focus should be on SQL skills, particularly query optimization. Experience with ETL processes, data pipeline design, and database management should also be highlighted. Key requirements: - Design and writing experience with tech-oriented resumes - Strong understanding of data engineering roles and skills - Proficient in showcasing mid-level experience convincingly - Excellent command over English and resume-writing conventions

I'm seeking an expert to assist with an examination task that encompasses both SQL queries and ORM diagram creation. Key Requirements: - Proficiency in SQL, particularly with MySQL - Experience in designing and creating ORM diagrams - Capability to work with simple data structures, specifically simple tables Ideal Skills: - Strong understanding of relational database concepts - Excellent problem-solving skills - Ability to work under pressure and meet deadlines

...Helpful," "Recent," or "Highest Rated." Online Ordering & Payment: Users can place orders for delivery or pick-up. Option to add multiple items to the cart, modify order quantities, and select payment methods. Payment gateway integration (e.g., Stripe, PayPal) for secure transactions. Order status tracking (order received, cooking, out for delivery). Push Notifications: Real-time notifications for new restaurant offers, order status, or restaurant promotions. Location & Map Integration: Integration with Google Maps for accurate delivery locations and distance from the restaurant. Restaurant location view in the map interface with directions for user convenience. 2. Admin Panel Features: Dashboard: Admin dashboard to manage all aspects o...

Vänligen Vänligen Registrera dig eller Logga in för att se mer information.

I need a professional, informational infographic created for me to use on Facebook and Instagram. The ideal f...infographic created for me to use on Facebook and Instagram. The ideal freelancer for this project should have: - A strong background in graphic design, particularly in creating infographics - Experience with designing for social media platforms - An understanding of visual communication and information design Brand name is : Dwello Tag line is: Make the move with confidence Graphic should be professional - not cartoon. Infographic needs to cover the following stages of a "seller journey" Seller Journey: 01 Readiness 02 Engage 03 Evaluate 04 Settle add a statement: "Unlock your potential: understanding the journey is the key to success...

I'm looking for a freelancer who can update my Statement of Work Word document template. The chosen candidate will make the document more visually appealing and in line with a creative design style. Key requirements: - Update the template to fit a modern and creative aesthetic. - Follow my specific color scheme, which I will provide. - Incorporate tables and charts into the design. - Create sections for images within the template. - Design custom headers and footers. Ideal skills: - Strong graphic design background. - Proficiency in Microsoft Word. - Experience with creating professional document templates. - Ability to adhere to specific branding guidelines.

I urgently need a professional design for my construction company's capability statement. This document needs to highlight: - Project Management expertise - Adherence to Safety Standards - Commitment to Sustainable Practices The design should be in a professional tone, suitable for the construction industry. Ideal candidates will have experience with capability statements and a strong understanding of the construction sector. Please provide examples of similar work. Time is of the essence.

...​Subscription (view / upgrade / cancel ) ​Business(Business name / Address , City , Postcode, Country , Phone number, website, business type) ​Preferences(Language(EN/ES)/ Privacy) page and subpage content in parentheses ​Program a Vehicle key ​Catalogue (All Keys / Residential Keys / Vehicle Keys & Remotes /Residential Remote / Complementary Products / Machines / Optional and Cutters / Programming Tools) ​FAQ(Top page => Search box-> [Title & Date] =>(click) = article) ​News(News Page [Title & Date] =>(click) = article) Program a Vehicle Key ( 4 search box with select from list or search = (Make,Model,Year,Region) , region will be preselected from the account level ) Only the cars that fit the filters will be displayed. After selecting a resul...

...WordPress website, almost every two minutes. This seems abnormal and I suspect it's a bot issue. I've temporarily deactivated the registration page, but the flow of registrations continues unabated. I need an expert to investigate this issue, block these unwanted registrations, and fix the root of the problem. Key Tasks: - Identify the source of the spam registrations - Implement measures to stop these registrations - Fix the issue so I can safely re-enable the registration page Ideal Qualifications: - Extensive experience with WordPress - Proficient in identifying and mitigating spam/bot issues - Familiarity with security and anti-spam plugins for WordPress - Able to provide long-term solutions to prevent recurrence Your expertise is urgently needed to help ...

...to. 2. User Management • The bot will keep a record of all users who activate it. • Admin Command: /users • Generates an Excel report listing: • Serial Number () • Name • Telegram Username of each user. 3. Prize Distribution • The bot will handle contests where users can win prizes. • Command: /prize • Users will enter a number (admin pre-selects the winning number in advance). • First user to submit the correct number: • Receives a winner message instructing them to contact the admin for prize redemption. • Their win will be announced to all users via a broadcast message. • Late entries: • Users trying after the winner is declared will see a message like: “You&...

We...talented programmer with a solid background in Delphi, Devex, and SQL Server to join our team. If you’re someone who loves coding and has experience building apps and managing databases with these tools, we want to chat! Your role will involve writing code, fine-tuning SQL queries, and ensuring our software works smoothly together. If you’re passionate about what you do and have a track record to back it up, we’d love to hear from you! Key Responsibilities: - Fix bugs as they arise in the existing applications. - Implement feature updates as required. - Improve application performance, with a primary focus on code efficiency. Ideal Skills & Experience: - Proficient in Delphi, Devex and SQL Server. - Experienced in...

...process involving AI tools to create detailed, visually appealing answers. **Responsibilities:** - Find and select 2 questions related to anabolic steroids to answer each day. A great source for these questions is the subreddit "Daily Ask Anything About Anabolic and Androgenic Steroids," but other subreddits are fine as well. - Using the AI prompt provided, generate scientifically accurate answers to the selected questions. - Use AI to create two charts per answer, helping to visually present the information. - Edit the charts with the URL of a specified website using a photo editing tool. - Use a final AI tool to reword the answers, making them fun to read, and format them in a user-friendly way. - Upload the formatted answers and charts to the correspondin...