Find Jobs
Hire Freelancers

Pl/sql coding & shell scripting

$2-8 USD / hour

Lezárt
Kiadva ekkor: 10 hónappal ezelőtt

$2-8 USD / hour

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.
Projektazonosító: 36628934

A projektről

8 ajánlat
Távolról teljesíthető projekt
Aktiválva: 9 hónappal ezelőtt

Szeretne pénzt keresni?

A Freelancer oldalán történő árajánlatadás előnyei

Határozzon meg költségvetést és időkeretet
Kapja meg fizetését a munkáért
Vázolja ajánlatát
Ingyen regisztrálhat és adhat árajánlatot munkákra
8 szabadúszó adott átlagosan $11 USD/óra összegű árajánlatot erre a munkára
Felhasználó avatár
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
$5 USD 40 napon belül
4,8 (69 értékelés)
6,8
6,8
Felhasználó avatár
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
$25 USD 40 napon belül
5,0 (1 értékelés)
0,0
0,0
Felhasználó avatár
13+ working experience, Oracle certified professional, working as Oracle EBS SCM Techo-Functional. Oracl forms reports, SQL , PL/SQL. Panaya tool for migration, package, procedures, functions, triggers,
$12 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
Quick learner on the task given and deliver the project in time. Possess good experience on the task.
$5 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
hey, can you send me more details for this project i think i can do this easily because i am also a student of mca so i think it is easy task for me
$12 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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.
$15 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0
Felhasználó avatár
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.
$5 USD 40 napon belül
0,0 (0 értékelés)
0,0
0,0

Az ügyfélről

UNITED STATES zászlója
Brooklyn, United States
0,0
0
Tagság kezdete: máj. 21, 2023

Ügyfél-hitelesítés

Köszönjük! E-mailben elküldtük a linket, melyen átveheti ajándék egyenlegét.
E-mailje elküldése során valami hiba történt. Kérjük, próbálja újra.
Regisztrált Felhasználók Összes Közzétett Munka
Freelancer ® is a registered Trademark of Freelancer Technology Pty Limited (ACN 142 189 759)
Copyright © 2024 Freelancer Technology Pty Limited (ACN 142 189 759)
Előnézet betöltése
Hozzáférést adott a helymeghatározáshoz.
Belépési munkamenete lejárt, és kijelentkeztettük. Kérjük, lépjen be újra.