How to format oracle sql query outputงาน

1.พัฒนานะบบ IOT ดึงข้อมูลจาก PLC แล้วนำมาแสดงผลในรูปแบบ Web Site โดยแสดงข้อมูลเป็น Real Time 2.สามารถใช้อุปกรณ์ของของบริษัท (Embedded PC) มี SIM ออก Internet ได้ หรือสามารถใช้อุปกรณ์ที่ผู้พัฒนาถนัด แต่ต้องเป็นอุปกรณ์ที่ทนต่อสภาพการใช้งานในโรงงานครับ (ความร้อนและฝุ่น) 3.สามารถใช้ Server ของบริษัทได้ สามารถเลือกได้ตามความถนัดแบบ Windows / Linux และ Database SQL , MySQL, MogoDB , InfluxDB เลือกได้ตามความถนัดครับ 4.เก็บข้อมูลไว้ดูย้อนหลังได้ 90 วัน

1) ชุดควบคุม ที่รับข้อมูลจากเซ็นเซอร์ 1-6 input แล้ว นำข้อมูลมาประมวลผล และสั่งการ ทั้งแบบ PID และ Relays output 2) จาก 1st stage พัฒนาต่อยอด เป็น IOT on desktop and Mobile.

ทำระบบการเลี้ยงปศุสัตว์ (Livestock Management) นำเสนอเบื้องต้นของ Development Tools: Front-end: Angular JS Language: .Net Core (Web responsive) Database: SQL Server/Azure SQL Database Operation System: Windows Cloud Solution :Hybrid Azure

Thai และ ENG format WAV (PCM,8kHz, 16 bit, Mono, Max size 100MB) ถ่าใด้ครบทุกภาษา ต่อลองราคาใด้คับ

ต้องการสร้างแอพ Xamarin (Cross Platform) เชื่อมต่อฐานข้อมูล Mssql ดึงข้อมูลจาก แสดงข้อมูลจากฐานข้อมูลพร้อมรูบ และ ทำระบบ Login

...เป็นงานระยะยาว ระยะเวลา 6 เดือน – 1 ปี c. การเชื่อมต่อกับระบบเดิม เชื่อมผ่าน MS SQL Server และ REST Api รูปแบบข้อมูล JSON ทั้งหมด d. การแก้ไข ระบบเดิม จะทำโดย programmer คนเดิม ไม่เกี่ยวข้องกับระบบใหม่ e. Source code และสิทธิ์ใน source code ทั้งหมด เป็นของผู้ว่าจ้าง f. ผู้ว่าจ้าง ต้องการเข้าถึง repository ของ source code ด้วย เพื่อประโยชน์ในการ review ป้องกันการสื่อสารผิดพลาด g. Platform NodeJS และ deploy บน Docker หรืออื่นๆ ที่เป็นรูปแบบที่คล้ายกัน h. แยกส่วนแสดงผล (client javascript) และส่วน Api (REST Api อย่างชัดเจน) 2. ระบบเดิม เป็น program บน Windows เป็นภาษา C# .Net framework และ MS SQL server a. เมื่อสั่งซื้อสินค้า จะสร้างข้อมูลการสั่งซื้อใน MS SQL Server และมีใบ PO ออกมา b. เมื่อรับออเดอร์แล้ว จะสร้างข้อมูลใน MS SQL Server และพิมพ์ใบงานส่งให้ฝ่า...

ต้องการ programmer สามารถเขียนคิวรี่ SQL และทำ report ระยะเวลาจ้าง 1 เดือน มานั่งทำงานร่วมกับ Programmer ของบริษํท ที่ทำงานตั้งอยู่ที่ปากซอยเพชรเกษม69 Victoria Garden ติดต่อที่ คุณท็อป [Removed by Freelancer.com Admin]

โปรแกรมสามารถแสกนลายนิ้วมือได้ โดยเชื่อต่อกับ SQL Server เมื่อลงเวลาออกสามารถ auto export file เป็น text ออกมาได้ (ต้องมีการคุยรายละเอียดกันอีกที)

Application ที่องค์กรใช้ มี ระบบ Database ใช้ MS SQL

- พัฒนาโปรแกรมโดยใช้ภาษา ASP.NET C# , Microsoft SQL Server - พัฒนาระบบเป็น web base application โดยมีเพียงส่วนของ UI และ Call Method ผ่าน Web Service - ไม่มีส่วนของ database design ,database create , database retrieve, database update , database delete - Design Web Page เรียบง่าย ใช้งานสะดวก ไม่เน้นลูกเล่น มี Concept , มีรูป ให้ 1. รถยนต์มือสอง 1.1 Download excel file format การกำหนดราคา รถยนต์มือสอง 1.1.1 Download excel file ใน Format ของการกำหนดราคา โดยเลือกเงื่อนไขได้ 2 วิธี 1.1.1.1 เลือกตามยี่ห้อ สามารถเลือกได้มากกว่า 1 ยี่ห้อ 1.1.1.2 เลือกตาม segment เลือกได้ครั้งละ 1 segment 1.1.1.3 ถ้ามีราคาที่เคยกำหนดในระบบให้แสดงด้วย 1.1.2 แสดงรุ่น รุ่นย่อยทั้งหมดตามเงื่อนไขที่...

การทำงานตามคลิปที่ส่งให้ดูครับ เรื่องการออกแบบก็ประมาณนี้ -สามารถสมัครสมาชิกได้ (แยกระหว่าง user และ owner / loginด้วยfacebook ได้) -ทำงานเสร็จสามารถส่งไฟล์ทั้งหมดเช่น sql api apk อื่นๆ เพื่อการพัฒนาต่อไป -เพิ่มร้านค้าและเมนูเองได้ทีหลัง

...เอฟเฟ็คตอนใช้สกิล , ฟันมอนสเตอร์ , เปลี่ยนแปลงอาวุธของตัวละคร 2. ใช้ Unity Network 5 , Javascript , C# ในการเขียน (หากใช้ Tools อื่นก็ลองเสนอมาได้ครับ) 3. สามารถกำหนดจุดเกิดมอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นมอนสเตอร์เหมือนๆกัน 4. กำหนดการดรอปของไอเทมเวลาฆ่ามอนสเตอร์ได้ และผู้เล่นคนอื่นเห็นไอเทมเหมือนๆกัน 5. ระบบ Inventory สามารถดึงข้อมูลไอเท็มของตัวละครแต่ละคนได้ ใช้ database mysql หรือ ms sql ครับ 6. ระบบแชททั่วไป และแชทส่วนตัว 7. ระบบปาร์ตี้ ให้สามารถมองเห็นหลอดเลือดของคนในปาร์ตี้ และตำแหน่งปาร์ตี้ในแผนที่ 8. ทำคู่มืออธิบายวิธีการใช้งานสิ่งที่ทำมาคร่าวๆครับ ใครสนใจเสนอราคาค่าจ้าง และประวัติผลงาน มาด้วยนะครับ

ค่าจ้างตามตกลง Programmer C#.Net MS SQL HTML etc.

Build a Easy website with codeigniter+sql. Built it as easy as you can. สร้างเว็บไซต์ด้วย codeigniter+sql.

I have 5 voice files in Thai that I needed translated in the format given below. I : น้องเคยค้นหาแอคเคาท์ใครในออนไลน์ป่ะ อย่างเฟซบุค Have you ever try to look for someone or search for an account online? Or in Facebook S : เคย Yes I : เหมือนฉันชอบคนนี้ ฉันไปตามล่าหา If I like this person I would look for him/her. S : โอ้ย เอาทุกสเต็ปเลย โพสต์รูปอะไรเซฟมาให้หมด Everything from posting to taking picture. S2 : โมเม้นต์นี้ เคยครับ คือคนที่เราอยากจะรู้จักใช่มั้ยครับคนที่เราแอบชอบนั่นแหละ เราจะคอยส่องเฟซเค้า ไปดู If i like that person i would peek at her Facebook. I : ไปแอดเค้ามั้ย Did you add her? S2 : เป็นเพื่อนกันอยู่แล้ว ก็ดูว่าเค้าลงรูปอะไรมั่ง กดไลค์ให้เค้า นั่งดูภาพเค้าอยู่คนเดียวอะไรอย่างงี้ We are already friend. Most of the time j...

Software and Application OCR Scan or Take Photo of Document OCR TO SQL

รับเขียน ออกแบบ แก้ไข software ทุกประเภท ทั้งงานทั่วไป และ ในโรงงานอุตสาหกรรม ประสบการณ์ใน บริษัท และ โรงงานอุตสาหกรรม มากกว่า 10 ปี -VB -Delphi -MS SQL -Oracle -MS Access -Barcode reader, RFID - อุปกรณ์เชื่อมต่อกับระบบคอมพิวเตอร์ I/O Card, Machine controller และ อื่นๆ เรามีความเป็นมืออาชีพ ทำงานเร็ว คุณภาพเยี่ยม คุ้มค่า คุ้มราคาแน่นอน ติดต่อเรา

I need an experienced VB.net programmer to make modifications to existing source code. The project itself should include feature demonstration forms. Key Responsibilities: - Modify existing source code: The main task will involve working with the existing codebase, making necessary adjustments, and ensuring the software continues to function as expected. - Demonstration forms: The project includes creating feature demonstration forms for the software. Ideal Skills and Experience: - Proficient in VB.net: The candidate should have a strong background in VB.net, with practical experience in modifying and building upon existing code for file IO, object generation and file parsing for data output. - User Interface Development: While the project involves existing ...

I need a skilled Adobe Illustrator professional to convert a logo from PNG to SVG. The aim is to optimize the SVG for web use, ensuring it remains scalable, editable, and suitable for online platforms. Key requirements: - Conversion from PNG to SVG: The logo is currently in PNG format and I need it to be converted to SVG. - Scalability: The resulting SVG should be scalable to any size without losing quality. - Optimization for Web Use: It's vital that the SVG is optimized for web use. This includes ensuring the file size is minimized for fast loading times, and that it retains its quality across various screen sizes and resolutions. Ideal skills and experience for this job include: - Proficiency in Adobe Illustrator: Given t...

I'm a beginner in Oracle Service Bus (OSB) and would like a thorough virtual training session on the topic. I'm looking for a skilled instructor who can guide me through the following areas: - Basic Concepts and Architecture: I need to understand the foundational principles of Oracle Service Bus (OSB). This includes how it works, its key components, and its role in service-oriented architecture. - Service Development and Deployment: I'm interested in learning how to develop services on OSB and deploy them effectively. This includes hands-on exercises and practical examples to reinforce the learning. - Troubleshooting and Optimization: I want to be able to troubleshoot any potential issues that may arise wh...

We are seeking a skilled graphic and logo designer to recreate 5 logo designs based on provided samples and instructions. This project offers an excellent opportunity for designers to showcase their creativity and attention to detail. Responsibilities: Recreate 5 logo designs using the provided JPG files and instructions in a Word document. Follow the given logo concepts, sample designs, and color combinations closely. Make minor adjustments or enhancements as per the specified instructions. Ensure high-quality output and pixel-perfection in the final designs. Requirements: Proficiency in Logo designing Ability to interpret and execute design instructions accurately. Willingness to collaborate and incorporate feedback. Compensation: Fixed bud...

I have a logo in a PDF format that I need converted to a vector format. In your application, please include your experience with similar projects. Please note, I do not require any specific color adjustments. Just a direct conversion from the PDF to a vector format.

...an AI developer to create an AI Resume Creator. The primary focus of this project is to take a normal CV / Resume and format it into our company format. It's quite a simple process, populated some fields, removing personal details and then coping the rest of the text into our format. We would want to be able for the AI to use the template we create and it check it each time to make sure we havent updated anything. We would drop the resume / CV into one folder then it would be added to another folder formatted. Ideal Skills and Experience: - Strong background in AI and Machine Learning - Experience in NLP and chatbot development - Proficiency in creating customizable sections for user-friendly interfaces - Understand...

I need a machine learning model developed in Python. This model should be able to evaluate prospective student applications by comparing them to historical data sets. The goal is to classify and sort the new applicants efficiently. Key Requirements: - Develop a classification-based machine learning model in Python - Understand and work with historical data sets to evaluate new student applications - Deploy the model in a web application format for ease of access Ideal Skills and Experience: - Strong background in machine learning and Python - Previous experience in developing classification models - Ability to understand and work with large data sets - Prior experience with deploying machine learning models in web applications

I have less than 100 scanned pages of text data that need to be entered into a digital format. The scanned documents are clear and the text is legible. I am looking for a detail-oriented professional to help me with this task. Ideal skills and experience for this job include: - Proficiency in data entry - Attention to detail - Familiarity with working with scanned documents - Ability to accurately transcribe text - Time management skills to complete the task in a timely manner If you have experience in similar projects and feel confident in your abilities to complete this job efficiently, I would love to hear from you.

Hello! I read your project details and want to work for you. I can easily do your job because I am Accounting and Excel expert person. I am enthusiastic and passionate about this work. If you want to hire me please accept my proposal. Thank you! Anjali dore

I'm seeking an experienced researcher to investigate retail displays in Wuhan, China. The project will specifically focus on Talens, a famous art supply brand. The research aims to provide insights into the following aspects: - Brands Available in Displays: The core of this project is to identify and analyze the presence and positioning of Talens within the retail space. - Competitor Analysis: While the primary focus is on Talens, it will be valuable to understand how other brands like Nike, Adidas, and Apple are being displayed in the retail outlets. - Customer Behavior: I'm particularly interested in how the retail displays are shaping customer behavior and purchase decisions. Ideal candidates should have a background in visual...

...need to create a set of graphics for PPC ads and social media. We currently use 2 styles of graphics in banners - one darker, where the background is always a photo with an overlay in ECD design, and the other lighter, rather infographic. For implementation, we would like to enter: - Brighter banner for PPC ads - Dark banner for PPC ads with Claim - Banner for promoting video recordings - Introducing the team - They moderate the event - Presentation of another E-shop Tour project - A PR article was published about the conference - Eventee application for networking - We are starting registrations - There will be practical workshops at the conference - Counseling Zone - The conference will be in a week - Conference Tomorrow! - We have over 600 registrations - Who are our ...

I'm in need of a chilling ghost horror story set in a modern era mansion. The story should take place in a way that fits a radio format, so it needs to be engaging and captivating for listeners. Key requirements: - The story should be based on the supernatural horror genre. - The setting should be a grand mansion, filled with dark secrets and ghostly encounters. - The tale should be well-suited for a modern audience. Ideal freelancer for this project should: - Have experience in writing ghost stories, specifically in the horror genre. - Be able to create a gripping and suspenseful plot. - Understand the nuances of writing for radio and can create a story that's engaging when heard.

I have a SQL Server that needs to be accessible over the internet. However, I'm facing connectivity issues, possibly due to closed or blocked ports on my ComCast router model CBR2-T. I need a freelancer to open the necessary ports on the router. The task involves: - Checking the current port status on the router - Identifying the SQL Server port - Opening the port on the router Please bid if you're experienced with network configuration and have dealt with ComCast routers before. Necessary Skills: - Network Configuration - Router Administration - ComCast Router Experience - SQL Server Configuration

As part of enhancing our communication strategy, we're looking for someone experienced with HTML, CSS, and email design to help revamp our current HTML email format. Key Tasks: - Adjust the font styles and sizes to align with our brand's visual identity. - Reorganize the body content for a more seamless and user-friendly reading experience. We believe a professional who understands the balance between aesthetics and functionality will be the most suitable for this job. Please bear in mind that although we are adding or removing data tags, we expect the modifications to not interfere with the existing data tags' functionalities. Your expertise in this area will be a significant advantage.

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.

I'm looking for a freelancer to help me extract financial data and regulatory filings from a tax website. This involves scrapping website using the provided credentials by the client, i am looking for getting the python code as i can run the code myself in the future or integrate it to another system. Key Requirements: - I need approximately 300 data points extracted. - The output for these data points should be organized into a PDF or Word. This project is about creating an automated system to generate instant reports about a company. Only difficulty is the website has drops downs to select the period involved and in those 300 data points actually many come from the same source. Ideal Skills and Experience: - Experience in web scraping (Python) ...

I have an protected password .mpz format that I need to have the program can unlocked and converted into a readable format, preferably Excel or CSV. - The file contains both textual and numerical data, so I need the converted file to maintain this integrity. - I intend to use the data primarily for reporting purposes, so it is essential that the conversion is accurate and all data is preserved. I'm seeking a skilled professional with experience in file format conversion and data handling. The ideal freelancer should be proficient in Excel and adept at handling mixed data formats. This project is crucial and I'm looking for someone who can deliver a high-quality and precise conversion.

...need of a professional web developer to create a platform that serves as an agent management website. The website should have an elegant interface, account logins, and a simple credit system that can be administered by an admin account. Key Features: - Agent Registration and Login: The website should allow agents to create accounts and log in securely. - Profile Management: Agents should be able to edit and manage their profiles. - Commission Tracking: The system should track and calculate commissions for each agent. The specific functionality of the agent registration and login feature is not fully defined yet. The ideal candidate for this project should have experience in building similar systems, understand user account management, and have the ability to...

I'm currently in need ...main task revolves around recreating a memorized photo in colored format. The final output is expected to be as precise and realistic as possible, echoing the exact resemblance of the original photo (a person's face) from memory. Attention to detail, excellent color use, and proficiency in capturing human resemblance are among the key skills sought for this job. The chosen freelancer will have proven experience in composite sketching, preferably with a portfolio demonstrating projects of a similar nature. Efficient communication will also be crucial for this task as I'll need to describe the photo to be recreated. I would like to meet via zoom to complete the sketch as soon as possible. I assume...

I'm looking for a skilled 3D designer who can create high-poly, realistic models of various products for an interactive 3D virtualizer. The key...realistic models of various products for an interactive 3D virtualizer. The key requirements for this project include: - Expertise in 3D modeling: You should have a strong portfolio of high-poly, realistic 3D models, ideally of products. - Understanding of 3D virtualizer: Experience in creating interactive 3D models for web use would be a big plus. - Creativity: The ability to accurately represent products in a high-poly format while keeping the designs engaging and visually appealing. The final deliverables will be high-quality 3D models that can be integrated into a virtualizer, providing users with an immersive, realist...

I'm using Tesseract OCR for processing scanned English documents, but I've been facing issues with incorrect text reco...skilled freelancer who can improve the accuracy of the Tesseract OCR for my specific needs. Key Tasks: - Analyze the current OCR set-up and identify areas for improvement. - Implement enhancements to ensure better recognition of the scanned English documents. - Test the improved system thoroughly to ensure the accuracy of the output. Key Skills and Experience: - Proficient in Tesseract OCR and its customization. - Strong background in OCR technology and its applications. - Experience in improving OCR accuracy, especially with scanned documents. - Familiarity with the English language is a must. - Ability to systematically test and ...

I'm in need of a professional who can perform text editing on a PDF. The changes I require are not too extensive but precise. Key Tasks: - Implement minor text corrections including typos and grammatical errors. - Make neces... The changes I require are not too extensive but precise. Key Tasks: - Implement minor text corrections including typos and grammatical errors. - Make necessary content updates such as paragraphs and headers. It's crucial that the final output remains in a text-based format. The document is currently editable, so the process should be smooth. Ideal Skills: - Proven experience in PDF editing. - Strong command over text editing. - Attention to detail for accurate implementation of changes. If you think you're the right fit fo...

...looking for a talented illustrator to create visuals for my innovative smart headphones. They feature an over-ear design with sound isolation technology, noise cancellation, speech processing, and a unique eye-tracking function. Desired Illustrations: Photorealistic Image: I envision a modern, sleek design with visible sound isolation details. Include four microphones for capturing sound and show the headphones being held or worn to emphasize portability. Eye Tracking Camera Focus: A close-up image showcasing two discreet cameras positioned near the headband, facing inwards towards the eyes. Label them as "Eye Tracking Cameras." Technical Breakdown (Optional): An illustration depicting the internal components, including a central processing chip connected to...

...talented designer to construct an informative presentation slideshow that lasts more than 10 minutes, with the primary objective of educating my audience about a new product/service. This project needs alignment with my brand, which requires working with a white background, and incorporating green elements and black text. Ideal candidates will have: - Proficiency in creating sleek, simple slide designs - Experience in structuring presentations for educational purposes - Ability to effectively mirror brand identity in design elements - Ability to effectively mirror the content of the proposal in a simlpe presetnation with using the right local images and icons The final output should hold the company we're pitching the attention and make complex produ...

I'm in search of a professional to create monthly sales reports in Excel. We need to create several tables starting from the attached files starting from input file 1 1- In input file 1 you need to filter the data in column B and take into consideration only "Order payment" and "Refund". 2- Filter the rows of input file 2 (attached), column D "Product Details" so that the different product details appear only once and report them in the VAT output file so as to have only 2 Product Name columns (in which the "product details of input file column 2" are listed. (example VAT file attached) 3- The app must check that all the lines present in column D "Product details" of the input file 1 are present in ...

I am seeking a talented graphic designer to create a modern and minimalist logo for my small company, The Royal Guardian. The logo must reflect the essence of my services - being professional and reliable. Key Requirements: - Design a modern and minimalist logo for The Royal Guardian - Convey professionalism and reliability in the design - Ensure the logo is unique and not reminiscent of any existing brands - Provide the logo in a high-resolution format for both digital and print use Ideal Skills and Experience: - Proven experience in designing modern and minimalist logos - A strong portfolio of previous work, particularly in branding and identity design - Understanding of brand positioning and the ability to visually communicate brand values - Proficiency with graph...

I'm looking for a freelancer to recolor and enlarge my logo for web use. The current colors are too bright, so I'd like them to be shifted to a darker hue. The job will also involve resizing the logo for optimal web display. Ultimately, I would need the final version of the logo in JPEG format. Ideal skills and experience for this project include: - Graphic design and logo editing - Proficiency with Adobe Illustrator or similar software - Understanding of color theory - Experience with resizing images for web display

...video editor to create a captivating YouTube introduction video to increase the average view duration of my posted content. This video is primarily targeted at young adults and business professionals. - Objective: The aim is to create a video that will hook my viewers, encouraging them to watch more of my posted videos, hence increasing the average view duration. - Video Content: The video will be repurposed from the original recording. - Desired Video Length: The video should be anywhere from 30 seconds to 1 minute long, capturing the audience's interest from the get-go. Ideal Skills: - Experienced with video editing in line with YouTube's format and general style. - Ability to create content that appeals to a mixed au...

I need a meticulous data entry specialist to help me clean and format a large set of digital documents. Key Responsibilities: - Sorting and organizing data effectively. - Removing any duplicates and errors present in the data. The ideal candidate should be familiar with data entry and have a keen eye for detail. Experience in data cleaning and formatting would be a plus. Time management is crucial for this project.

With our upcoming rock concert, we're in need of a skilled live sound engineer to ensure the best audio experience for our audience. - Event Type: Your main focus will be to manage the live sound at a rock concert, ensuring a vibrant, smooth, and balanced output. - Music Genre: Having experience with rock music is critical as you'll be balancing and mixing sounds for such a performance. - Sound Equipment: We've got the basics covered; you will have access to microphones, speakers and mixers at the venue. Your expertise on how to utilize these equipment to create the quintessential rock concert atmosphere will be key. Ideal candidate should have: - experience as live sound engineer, ideally with rock concerts. - comfortable...

I have an Excel sheet that requires data filtering. From One sheet i want the following 1) Deletion of few records with some keywords 2) Make one sheet with unique data 3) No of repeated records. 4) Mobile number format to be changed

I'm in need of a generative artificial intelligence that can analyze given text inputs and provide suggestions based on the analysis. The main purpose of this AI would be for data analysis. Key Requirements: - The AI should be primarily text-based. - It should be able to process and analyze the supplied text. - The output should be suggestions derived from the analysis. Ideal Skills and Experience: - Previous experience in developing generative AI systems. - Proficiency in natural language processing and data analysis. - Strong understanding of machine learning algorithms.