Requirement #1. write a pl/sql package to fetch data from 2 parent & child tables with multiple filters (where) clause and get the data in csv & excel format and insert/update the data back to the same tables having datatypes null, notnull, Pk, Fk, check, sequence, lob, xlm, varchar, nvarchar, char date, timestamp, long datatypes in the tables, indexes partitions. Write the efficient code to run from sql developer sqlplus & bash shell.
—ORACLE 19c / Bash shell /Linux 7
Requirement #2.
There are multiple users in the database having tables index partitions and tablespaces having numbers of user objects & segments with various data types lobs, xml, varchar, nvarchar, date, timestamp, number long, iot, partitions pk, fk,, organizational index, check constrains , sequences etc we require a pl/sql code to release fragmentation from the tablespaces based on user by creating a backup of all the tablespaces (create all the new tablespaces as a backup) for that one user, then copy all the objects in a new tablespaces then drop all the old all tablespaces for that user and replace the newly created tablespaces with the original Names back.
create a new user to create & executable pl/sql package and from there you clear the fragmentation by calling pl/sql code and call the bash script to run the package. For each schema user (there may be many schema’s in the oracle 19c database on linux & bash shell.
3. Oracle password encryption script to generate for each user file meaning read the user file having user names and generate a sql file(Alter user username passport ….)
Required efficient coding and provide privileges to implement & execute/run the packages.
Hello there! My name is Adeel and I am a Oracle Fusion Financials,Inventory HCM Techno Functional Oracle Patching Cloning Oracle Apex 18.2,19.1,19.2 Deployment,Development,Administration Oracle database implementation 12c,11g,10g on Premises as well as Oracle Cloud and AWS Oracle Data Modeler Linux installation and Administration Oracle EBS Installation and Upgradation specialist with over 11 years of experience in the field.
I understand that you are looking for someone to write a pl/sql package to fetch data from 2 parent & child tables with multiple filters (where) clause and get the data in csv & excel format and insert/update the data back to the same tables having datatypes null, notnull, Pk, Fk, check, sequence, lob date xlm varchar nvarchar char date timestamp long datatypes in the tables indexes partitions.
I believe I am the perfect fit for this project as I have the skills required to complete the job successfully. My expertise includes Oracle database Administration SQL PL/SQL OAF development R12.1&12.2 VO Extension CO Extension Java AD
Hello there,
I am excited to apply for the job you have posted. With over ten years of experience in Oracle PLSQL, PostgreSQL, MySQL, MS SQL, and other NoSQL databases, I am confident that I have the necessary skills to meet your requirements. I have a proven track record of delivering high-quality solutions to clients across various industries.
In addition, I am committed to providing excellent customer service and am available 24x7 to answer any questions you may have about the requirements. My goal is to exceed your expectations and deliver results that meet your needs in a timely and efficient manner.
If you are interested in learning more about my qualifications and experience, please do not hesitate to reach out to me. I would be happy to discuss the project with you in more detail and provide you with a detailed proposal that outlines my approach to the project.
Thank you for considering my application. I look forward to the opportunity to work with you.
Best regards,
Courser Xu
Hi, my extensive +10 years of experience in Java Core, Spring Boot, Microservice, Oracle Database, PLSQL, Linux, and Shell Scripting. I am confident that I can make a valuable contribution to your project. I look forward to discussing my qualifications in further detail. Regards.
Oracle SQL, PL/SQL Development, PostGre SQL, SQL Server Database, Sr. Database Developer and Python expert having knowledge in writing complex queries, tuning queries, optimization, Mviews, Triggers, Procedure, functions, packages, file handling etc.
Looking first project at upwork and can do this work at very low rate as priorities my tech work skills first.