Pl sql in oracle jobs

...behaviour and run 'business logic' in the back-end, with total response times between users of ideally less than 5 seconds, though this requirement is flexible. Specific Features: - User login and registration functionality is required for the web app, including account creation. - Users can create projects and invite people with a one-time code/URL - Interactive graphic capabilities: the projects that users collaborate on will be interacted with via a dynamic interface - Ideally the web app will be mobile-friendly, but this is not essential, especially in the early stages. Ideal skills and experience: - Strong experience in web app development, specifically with Javascript - Understanding (and ability to explain/teach) how JS links to Wordpress/HTML, ...

Node JS Hosting on Google Cloud Platform I am looking for a developer who can help me with hosting my existing Node JS application on the Google Cloud Platform...and Experience Required: - Experience with Node JS hosting on the Google Cloud Platform - Strong knowledge of Google Cloud Platform and its services - Familiarity with deploying and managing Node JS applications - Understanding of database management in a Node JS environment, specifically NoSQL databases like MongoDB or Firebase - Knowledge of SQL databases like MySQL or PostgreSQL is a plus - Ability to troubleshoot and resolve any issues related to hosting and deployment on the Google Cloud Platform If you have the expertise and experience in Node JS hosting on the Google Cloud Platform, please feel free ...

...for text data. Uncertainty persists about whether to use SQL database for storage, so your expertise is needed. The ideal candidate will have: - Proven experience with data repository creation. - Comprehensive understanding of data types, particularly text data. - Expertise in helping clients to choose the best database for their needs. In this case, helping me decide whether to go with SQL for text data storage. - Familiarity with various data format structures. While there's a preference for SQL, this is not set in stone. This project will require you to: - Develop a structure uniquely suited to storing text data. - Provide expert advice on the most suitable form of database for this type of data - we are currently considering SQL...

...website development. - Web scraping: Acquire necessary information from different sources to enrich content. Expected Skills & Qualifications - Proficiency and demonstrated experience in CodeIgniter, Python, and SQL. - Good knowledge and experience in data analysis and web scraping. - Ability to design and manage an efficient and secure database system. - Strong front-end and back-end development skills. - Attention to detail, creativity, and a problem-solving mindset. By joining this project, you will bring a novel application to life and provide data-driven insights to guide its development. Your expertise in both back and front-end development will be crucial to ensure a seamless user experience. If you thrive on challenges and on turning visions int...

Enterprise Resource Solution Implementation for Medium Business We are seeking a skilled professional to implement an ERP system for our medium-sized business. The ideal candidate will have experience in ERP system implementation and be knowledgeable in the following areas: - ERP system implementation: The candidate should have a strong understanding of the implementation process and be able to effectively tailor the ERP system to meet our business needs. - Project management: The candidate should have experience in managing ERP implementation projects, ensuring successful delivery within budget and timeline. - Business analysis: The candidate should be able to analyze our current business processes and identify areas where the ERP system can streamline operations an...

I am looking for help to create a local containerized environment (docker-compose) of our existing LAMP website at so can effectively have a local development environment. Containerized components to include are apache, mysql, php, phpmyadmin Website is running on the following version components Apache Version: 2.4.57 ...help to create a local containerized environment (docker-compose) of our existing LAMP website at so can effectively have a local development environment. Containerized components to include are apache, mysql, php, phpmyadmin Website is running on the following version components Apache Version: 2.4.57 PHP Version 5.4.45 MySQL Version 5.5.62 Will provide you with database sql file to import and the app files of the website

Azure MS SQL Having High I/O Utilization. There are two unwanted processes that need to be killed. Conditions: 1. Issue to be resolved on my device remotely. 2. Complete knowledge sharing on successful completion 3. Payment on successful completion of task. Success Criteria 1. I/O Utilization to become normal below avg 20% 2. Removal of two processes Spid:64 & 65.

I'm in need of a Tableau and SQL specialist who can guide me through the creation of a KPI dashboard based on revenue vs target data. While I have intermediate knowledge of the software, specific assistance is required in building a clear, informative visualization of my company's revenues growth rate. This involves not just creating a standard dashboard, but really getting into the depth of what Tableau and SQL can offer. The ability to work collaboratively and communicate complex data in a comprehensible manner is vital. Ideal skills and experiences: - Advanced expertise in Tableau and SQL - Prior experience with sales data visualization - Exceptional skills in interpreting and showcasing KPI data - Proven ability to tea...

I'm in urgent need of a highly-skilled Full Stack Developer experienced in Laravel framework. The successful candidate will be tasked with executing key improvements to my website including: - Front-end and back-end development: We want the entire UI and the server side to be developed and improved, making it more interactive and efficient. - Database integration: This involves storing, retrieving and using data from our server. We require someone proficient in SQL and can comfortably work with large datasets. - API integration is essential. You will connect reusable resources with applications and devices. Knowledge in RESTful API is preferred. Hence, experts in Laravel with the ability to manage front-end and back-end development along wit...

I require an ex...a Federated Learning model into my project. Below are the specific needs: - Machine Learning integration using the Federated Learning model - You'll be expected to train a new model for this task - We'll be providing you with structured data, primarily from Excel spreadsheets and SQL databases The perfect freelancer for this job would ideally hold the following skills: - Proficient in Flutter framework - Experience in Machine Learning (specifically Federated Learning) models, and their integration - Expertise in handling and analysing structured data for the training of machine learning models Your ability to provide assistance, strategies and methods regarding the training and integration process will be highly appreciated. Looki...

I am looking for a freelancer who has strong skills in SQL, Python, and Business Intelligence. The main goal of utilizing Business Intelligence in this project is to improve decision making. The specific tasks that I need help with are query optimization in SQL and data analysis in Python. Ideal skills and experience for this job include: - Strong knowledge and experience in SQL query optimization - Proficiency in Python for data analysis - Familiarity with Business Intelligence concepts and tools - Ability to write complex SQL queries - Attention to detail and ability to extract and transform data efficiently If you have expertise in these areas and are ready to take on this project, please submit your proposa...

...required to: - Implement support for diverse programming languages that include (but are not limited to) Python, C++, C, SQL, and Java. - Incorporate key features such as a code sharing feature and debugging tools, taking account of our drive for a collaborative and user-friendly platform. Ideally, you're an experienced developer versed in the programming languages specified and have a keen eye for design. We value creativity and innovation, thus we’re interested in individuals who can offer fresh perspectives and ideas. Proficiency in web design and user interface, along with a strong understanding of coding compilers, will make you a top candidate for this project. In summary, we're asking for technologically savvy, artistic, and ...

I am looking for a freelancer who can help me integrate my Java code into Oracle Database 11 using PL/SQL. The purpose of this integration is to call the Java code for external API integration. Skills and Experience: - Proficiency in Java Stored Procedures - Strong knowledge of Oracle Database 11 and PL/SQL - Experience with external API integration - Ability to set up the environment for the integration The ideal candidate should be able to assist me in setting up the environment for this integration as well.

...experience in spatial data analysis, asset/facilities management, and 3D visualization. Preferred Skills and Experience: - Strong knowledge and experience in asset/facilities management - Proficiency in spatial data analysis and 3D visualization - Expertise in PostgreSQL database management system - Experience with data integration services Project Requirements: - Assist in managing assets and facilities within the project - Perform spatial data analysis to optimize asset/facilities management - Create 3D visualizations for better understanding and presentation of assets and facilities - Utilize PostgreSQL as the preferred database management system - Integrate data from various sources for seamless asset/facilities management If you have the requir...

Project Title: Custom-built E-commerce Website Development...visibility on search engines Ideal Skills and Experience: - Proficiency in web development languages such as HTML, CSS, and JavaScript - Experience in building custom e-commerce websites with complex functionalities - Knowledge of database management systems and SQL - Familiarity with web security best practices and PCI compliance - Ability to create responsive and mobile-friendly designs - Strong problem-solving and troubleshooting skills If you have prior experience in developing custom e-commerce websites and possess the necessary skills, please submit your proposal along with relevant portfolio examples. I am open to suggestions and would appreciate your input on the best features and functionali...

...the maximum subarray sum in a given array. Implement an algorithm to rotate an array. Write a function to check if a string is a palindrome. Linked Lists: Reverse a singly linked list. Detect a cycle in a linked list. Merge two sorted linked lists. Trees and Graphs: Implement a binary search tree. Conduct a breadth-first search (BFS) or depth-first search (DFS) on a graph. Find the shortest path between two nodes in a graph. Sorting and Searching Algorithms: Implement quicksort or mergesort. Write an algorithm for binary search. Find the kth largest element in an unsorted array. Dynamic Programming: Find the longest increasing subsequence in an array. Compute the minimum path sum in a grid. Solve the 0/1 knapsack problem. Databases and S...

Hi, I am seeking a skilled .NET developer to assist me with an ASP.NET project. This project involves working with existing code and requires someone with experience in ASP.NET. The ideal candidate should have a strong understanding of the ASP.NET framework and be able to work with ADO.NET. The project is expected to be long term and having knowledge of SQL Server. Freelancer and Team both are welcome. Looking forward. Dipak

I am looking for a highly skilled developer with a deep knowledge in backend development and Flutter. Ideal Skills: • Backend Development • Flutter Framework • SQL Database Management Your primary focus will be on the development of the real-time data synchronization feature. The ideal candidate would have significant experience with SQL database technology. This project will involve bringing the concept to life by applying your advanced understanding in both backend development and Flutter. This is an exciting opportunity to work on a dynamic and innovative project where your expert skills in Flutter, backend development, and SQL will be vital. I look forward to partnering with a knowledgeable individual who can see this project...

I am looking for a Oracle Netsuite Advanced Reports Functional expert who can assist customers with creating variety of reports. Must have at least 3 strong years of Netsuite functional and active expertise knowing how to create, updating criteria and filters for both saved search and financial GL reports. Must be very strong with SQL formulas and custom fields. Scripting is a plus to have as some requests to use saved searches may require scripting to handle actions on transaction records. WE HAVE ALOT OF PROJECTS..MUST BE ABLE TO BE AVAILABLE ON SOME WEEKENDS TOO. Ideal Skills and Experience: - Strong knowledge and experience in Netsuite financial reports and Saved Searches - Ability to understand and meet specific requirements for the reports - Familiarity w...

As per Oracle Cloud requirement, for Oracle Integration Cloud we need to: Upgrade the current JDK to JDK 17 on the server that hosts the connectivity agent. Update the env as per the new JDK17 Convert the JKS KeyStore to the PKCS12 KeyStore. Update the OIC agent Config as per the new JDK and keys. Upgrade and test the existing integrations affected by these changes.

I'm in need of an experienced programmer who can guide me to improve my skills in reactJS with redux. Using .Net core with SQL as the preferred database, I'm on an intermediate level of programming and my primary goal is to enhance my skills. Key Features: - Expansive hands-on training sessions focused on real-world applications and examples. Skills and Experience Required: - Expert knowledge of reactJS, redux, and .Net core is essential. - Extensive experience with SQL database. - Experience in creating and implementing educational curriculums or training programs. - Excellent communication and interpersonal skills, needed for effective teaching. - Ability to cater lessons to varying levels of understanding and skills.

...Description: We are looking for an experienced and knowledgeable Oracle HCM Cloud Benefits Module Specialist to join our team. As a specialist in Oracle HCM Cloud Benefits, you will play a crucial role in leading client engagements and effectively managing the implementation of the Benefits module. Responsibilities: • Lead and manage client engagements related to the Oracle HCM Cloud Benefits module, ensuring successful implementation and configuration. • Utilize your expertise in Oracle HCM Cloud Benefits to guide clients and provide effective solutions tailored to their specific needs. • Communicate and collaborate with clients to understand their requirements, and translate them into actionable plans. • Configure an...

...skilled database developer to build a database to track client assets in over 1000 stores. The main purpose of this database is to manage customer data. I am open to suggestions regarding the type of database and preferred platform or technology to use. Ideal skills and experience for this job include: - Database development experience - Proficiency in relational databases and NoSQL databases - Knowledge of Microsoft Access, SQL Server, and other database platforms - Ability to design and implement a database to track client assets in multiple stores - Strong attention to detail and ability to ensure data accuracy - Problem-solving skills to troubleshoot and resolve any database-related issues If you have experience in building databases and are open...

I need a form to save several data. That data needs to be accessed by the date and viewed on the webpage. The data needs to be saved by SQL and access in an Excel local file.

I am looking for a skilled Oracle database designer and SQL expert to help me with my project. The main purpose of the database is to process sales transactions. Requirements: - I have a detailed specification for the database design, so attention to detail is crucial. - The SQL queries are expected to have high complexity, so experience in handling complex queries is necessary. Ideal Skills and Experience: - Strong expertise in Oracle database design and SQL. - Ability to understand and implement detailed specifications. - Experience in handling high complexity SQL queries. If you have the required skills and experience, please submit your proposal. Thank you!

Exciting project opportunity for a skilled Full Stack Developer, who is well versed in: - JavaScript - React - API - SQL We are looking for a skilled Full-Stack Developer with a strong background in .NET Core API, Postgres, SQL query optimization, ReactJS, and TypeScript. The ideal candidate should have a minimum of 3 years of hands-on experience in web development, and be passionate about creating efficient, high-quality software solutions. Key Responsibilities: Develop, maintain, and optimize .NET Core APIs and back-end systems to meet business requirements. Design and implement efficient database schemas using Postgres, and write complex SQL queries to extract and manipulate data. Collaborate with front-end developers to build interactive and...

I'm currently seeking an entry-level (junior) C# developer to assist in the on going development of our dynamic web application. Specific responsibilities include not only the basics of backend development, but also the working with database and some experience with would also be a benefit. Our core business is international eSIM phone plan sales. We are preparing a Shopify store and need to integrate it with our system so that when a purchase is made and payment is successful shopify webhook must trigger our API which will activate a eSIM and send the user a message by email and also preferably use our whatsapp API to also send a message via whatsapp. The message will include pdf link + QrCode to install the eSIM. Its ok to use a digital product app from the spotify store...

Hello, I need Microsoft SQL Server Mgt Studio query for a large dataset 1,000,000's of rows, which - only looks at the rows with the latest revisions (identifable by a revision no); - and for this latest data, sums selected fields to aggregate the data - and applys the above for a selected subset (region) and from date A sample (dummy) dataset and more detailed requirements is provided/attached (excel)

Need help on Oracle Apex Development. Payment based on hourly help

I am seeking an SQL expert with significant experience in SQL Server and data analysis. This project involves the management of personal data requiring precision and security. You will need: - Demonstrable experience with SQL Server. - Experience handling personal sensitive data. - Proven track record of executing data analysis operations. The key task will be to extract insights from substantial personal information datasets. The qualified freelancer will need to demonstrate in-depth knowledge and experience with SQL Server, data analysis, and handling personal data. Strict adherence to data privacy rules is compulsory.

...talented designer who can create the formatting for the booklet and the final design for a set of 25, minimalist oracle cards centered around the theme of love and relationships. We have already designed these so it’s just a case of formatting with the inverted theme, and ensuring overall layout is ready for print and outputting different formats. Your task will entail: - Producing the overall design of the inverted of each card in a minimalist style. They are currently written on pen/ paper (cards) and google drive for the 30’page booklet. The ideal freelancer for this project should possess: - Strong experience in minimalist design. - A portfolio demonstrating previous oracle card designs or related work. - understanding of Adobe and can i...

Seeking a database developer adept in creating a user-friendly, star rating system for my website. This will allow users to review and rate companies. Requirements for this project are: * Development of a database to be integrated into an existing website. * Set up a star rating system through which users can rate companies. * Establish categories for rating - I've left this open for discussion, so expertise in creating impactful categories is appreciated. * Star rating should visibly translate into results, displayed out of a total of 5. Consideration will be leaned towards those with experience in developing interactive databases and user rating systems. Advanced skills in programming languages such as SQL, PHP, Python or Ruby are a huge plus....

I am looking for a developer who can help me convert specific PayPal transaction data to SQL in a DevExpress XAF XPO application using C#. The ideal candidate for this project should have experience with C# programming, DevExpress XAF XPO, and SQL database management. Specific requirements for this project include: - Converting PayPal transaction data, including Transaction ID, Amount, and Customer Information, to SQL format - Working with a relational database structure - Completing the project within a timeline of less than 1 month If you have the necessary skills and experience, and can meet the specified timeline, please submit your proposal. Thank you.

I'm seeking a professional who can assist in integrating Jasper Reports 8.x with Oracle Forms 12c. This is an advanced project that include sub-reports and custom visualizations. Ideal Skills: - Expertise in Oracle Forms 12c and Jasper Reports 8.x - Proficiency in generating advanced reports - Proven experience in creating HTML/pdf output - able to send report to printer -able to display report in browser Responsibilities: - Trigger and call Jasper Reports 8.x from Oracle Forms 12c - Ensure the report output is in HTML format - Deal with the complexity which includes sub-reports and custom visualization A proven track record in similar projects is desirable. A strong understanding of Oracle Forms and de...

I am looking for an experienced freelancer to help me set up a Redhat Satell...instructions and guidance on the functionalities and features of Redhat Satellite Server The expert should perform the following tasks: 1. Set up Red Hat Satellite Server Lab setup in Oracle Virtual Box. 2. Provide a document outlining the installation steps. 3. Teach me how to patch my client servers in my lab setup, specifically those running in production (Web server, Database Server, Containerization Server). Additionally, I would like guidance on the Patching Plan for Production Environments, including pre-patching and post-patching activities. Thank you. If you have the necessary skills and experience in Redhat Satellite Server, and are able to meet my specific requ...

I am looking for a developer who can help us create internal database, write api queries to automate extracting data from suppiers and sales platform, and create apps using Retool. Experience in PostgreSQL, JavaScript, and structuring database schema will help me with a project. The primary goal is to establish a functional database connected with API for automated workflows. The timeline for the project is flexible. Ideal Skills and Experience: - Storng proficiency in Postgre SQL and JavaScript - Experience with database schema development - Experience with Retool app development - Knowledge of workflow automation techniques - Ability to work within flexible timelines

I'm in need of a SQL expert who can quickly resolve an issue I'm having with incorrect results from my queries. I'm not entirely sure which database management system I'm using, so a solid background in multiple systems such as MySQL, Oracle, and PostgreSQL would be ideal. I require immediate attention, as I need the project completed as soon as possible. This job requires: - Strong SQL skills, with experience in troubleshooting and resolving issues - In-depth knowledge of different Database Management Systems - Excellent problem-solving and attention to detail - Ability to explain complex issues in simple terms. Your prompt response is much appreciated.

· Collaborate with a global cross-functional team in building customer-centric software products · Analyze existing software implementations to identify areas of improvement and provide deadline estimates for implementing new features · Develop software applications using technologies that include and not limited to core Java (11+ ), Kafka or messaging system, Web Frameworks like Struts / Spring, relational (Oracle) and non-relational databases (SQL, MongoDB, Hadoop, etc), with RESTful microservice architecture · Implement security and data protection features · Update and maintain documentation for team processes, best practices, and software runbooks · Collaborating with git in a multi-developer team · App...

I am looking for an experienced Oracle Forms and Reports 11g developer to assist with an intermediate level project. The project has no specific timeline and requires expertise in handling intermediate complexity tasks. Skills and Experience Required: - Proficiency in Oracle Forms and Reports 11g - Strong understanding of database management and SQL - Ability to work independently and meet project requirements - Experience in developing intermediate level projects using Oracle Forms and Reports 11g - Attention to detail and ability to troubleshoot and debug code If you have the necessary skills and experience, please submit your proposal.

I am looking for a freelancer who can assist with the maintenance and repairs of my Microsoft Access SQL server. The specific tasks that I need help with include database optimization and we have an error 3464 for mismatched information in "booking Notifications". the database contains Credit card information so it is safety sensitive. The size of my database is less than 1 GB. I already have a backup plan in place for my database but it will need to be updated/merged if repair can not be implemented in a short period of time. Ideal Skills and Experience: - Strong knowledge and experience in Microsoft Access SQL server maintenance - Expertise in database optimization - Familiarity with query optimization - Expe...

...script that can establish a connection to a Google SQL server. Project Overview: I have a Google SQL server set up on a Windows server, and I need a Python script that can connect to this server. Requirements: Proficiency in Python programming. Experience working with Google SQL databases. Strong understanding of database connectivity and security best practices. Scope of Work: The selected freelancer will be responsible for: Developing a Python script to connect to a Google SQL server. Implementing secure authentication methods. Ensuring the script is robust and error-resistant. How to Apply: If you are interested in taking on this project, please respond [Removed by Freelancer.com Admin] with the following: Your relevant experience in...

Im looking to update an ms access application from 32 to 64 bit. Set-up: 2 files, 1 program, other pure data - Basic func...program, other pure data - Basic functions of buttons (printing, updating, sorting) - VBS some scripting for special routines & functions - SQL import/export The app has a number of functions, but I'm not sure in how many cases there will be an effect on them because of the upgrade from 32 to 64 bit version of access Here are some extra points: 1. we import xls files into the database daily. 2. we import data from csv files daily 3. we export data to csv files 4. we export data to a MYSQL database 5. it is basically an ordermanagement and shipment app So in short, we import orders, we add shipping data, create shipping labels and impo...

...all excel files in directory an delete imagenes contained on it 2) Save them as same name + "no images" 3) If the case, convert xls to xlsx while saving 4) from the massivity of fields, best effort to identify some of them by a list of rules & criteria (no artificial intelligence needed, just a couple of ""IF" 5) mix-them and create a new excel file mixing all of them Preferred programming language for the project is Python. Deliverables: Code & project 32 bit compilation (or give a class on what to install in my computer and how to create compiled .exe files) 64 bit compilation The expected timeline for completion of this project will be determined according to the quote provided by the freelancer. Ideal skills and experience for ...

I am looking for an experienced .Net developer, well versed in Net MVC/Core and DevExpress to develop a new module in the web application as described below:. Key Functionalities: * We will use as a control data source the Microsoft SQL Server Analysis Services Data Depth: * We are using two devexpress web controls in particular, which are: Pivot Grid: BI Dashboard - Ideal Skills and Experience: * Expertise in .Net, MVC Core, and DevExpress * Proficiency with data analysis and reporting functionalities * Experience handling User Activity Data is a big plus. * Microsoft SQL Server Analysis Services Over to you now. Do you think you can do it?

I am in search of an experienced Java developer who possesses excellent knowledge of the Angular framework and Microsoft SQL. The main scope of this project is centred around three key aspects: - Java development - Angular Framework - Microsoft SQL For this project, I require specific functionalities which include: - Database integration and management: You will need to link the application with a Microsoft SQL database and efficiently manage data flows. - Data visualization and reporting: The application should be able to generate insightful reports and present data in an easily digestible format. - Business Logic and UI changes: Apart from backend tasks, I also need someone who can make significant changes to the user interface and business logic bas...

I am looking for a data scraper who can help me with my project. The ideal candidate should have experience in web scraping and be familiar with SQL databases. Specifics: - The project involves scraping website URLs. - The scraped data should be stored in an MS SQL format. - The data needs to be scraped continuously, on an ongoing basis. Nature of Work: - Retrieve Data (15 mins & Hourly Table) - Summary / Technical Indicators / Moving Averages Tables Data - Add option to change MSSQL login & pwd details - Attached Screenshots for Reference data Tables - Retrieve data continuously from below url's

I am in need of a professional who is skilled in Power BI and data analytics to create a detailed activity log. The goal is to track user activities on Power BI, including: - Their login and logout times - Their interactions with dashboards and reports Specifically, for dashboard and report interactions, I would like to capture: - The page views - Connection details to Excel data model The ideal freelancer for this project would have in-depth experience with Power BI, data analytics, and user behaviour analysis. Experience with Excel data model connections would be a plus. This project requires a keen eye for detail and a thorough understanding of how to interpret user interaction data. Your role will involve not only setting up the tracking system but also provid...

I need to create a schema to manage data about shipments and packages. See details in the following file. Skills and Experience: - Strong experience in building database schemas using MySQL - Familiarity with database design principles and best practices - Ability to suggest and implement a suitable structure for the database schema based on the client's requirements - Proficiency in writing efficient and optimized SQL queries - Attention to detail to ensure data integrity and security measures are implemented - Excellent communication skills to understand and clarify the client's needs and provide regular updates on the progress of the project.

Full Stack React Developer with Node.js, SQL, and Python I am looking for a Full Stack React Developer with expertise in Node.js, SQL, and Python to assist me with my project. The ideal candidate should have experience in the following areas: Skills and Qualifications: - Strong proficiency in React.js and Node.js - User registration and login integration. - Proficient in SQL, specifically MySQL - Familiarity with Python - Experience with API integration - Host site in windows server. Project Requirements: - User registration, login, and 3 Level user dashboards. - API integration: The project requires seamless integration of APIs to enhance functionality and optimize user experience. - Timeline: The project needs to be completed ...

Hello, Please read carefully : SQL Expert Only ! I am looking for someone who can build me a sql function that will transform a text column into a 10 characters/digits column. If the text column have duplicate then the 10 characters should be the same in the new column. Also the function must avoid any collision : 2 different text cannot have the same 10 characters. A check must be done to avoid colision. Thank you.