Browse categories
Explore
Fiverr Pro
English
$
USD
I will do oracle sql and plsql jobs for you
About this Gig
I have 4.5 years of experience on Oracle SQL, PLSQL Query tuning ,Data migration from Oracle to postgres.
I offer following services for your Project/assignment /jobs
Oracle SQL Indexes
Complex Queries in Oracle
joins in Oracle
set operators
Plsql cursor
Plsql Triggers
Exception Handling
Types
Plsql user defined Functions
Stored Procedure
Stored Procedure with IN ,OUT and INOUT parameter
Plsql Packages
Oracle SQL Performance tuning
Oracle Sql Query optimization
Database design tables,views,Materialized views ,constraints, analyze queries
Sql and Plsql Debugging and fixing
Domains - Insurance ,Agriculture like procurement and farmer registration crop evaluation and benefits of MSP.
Database type:
Relational database
Platform:
Oracle
•
PL/SQL
•
PostgreSQL
•
Teradata
Expertise:
SQL
•
DML
•
Performance
•
Query optimization
FAQ
Can you convert oracle sql queries and plsql subprograms into postgres.
Yes I am well aware of the difference between oracle and postgres. I can convert plsql scripts into Plpgsql scripts also.
Can you tune sql queries for better performance?
Yes I can tune queries by understanding design requirements of the output reducing subquery and improving joins.
How you can find the performance bottleneck in PLSQL
Oracle has provided DBMS_PROFILER package which is helpful for finding out the sql statements degrading the performance.
How can You increase performance for bulk insert ,update or delete .
I can implement Bulk bind concept (bulk collect and forall ) For inserting thousands of rows at one go.
What if Bulk collect throws an error.
I can add save exceptions in forall clause and add in exception block sql%bulkexceptions to get the error number error code and number of rows not inserted .
How many revisions you will provide ?
Unlimited
Reviews
5 reviews for this Gig
| (5) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Recommend to a friend
- Service as described
Sort By
Most relevant
U user23972726
Repeat Client
United States
Thank you very much
Helpful?U user23972726
Repeat Client
United States
Thank you once again. Very talented person.
V 
Seller's Response
Helpful?U user23972726
Repeat Client
United States
Completed my work within few hours and was very helpful about explaining unknown terms to me.
Helpful?L 
liujiji
Repeat Client
United States
Very professional, always follow up the work
Helpful?L liujiji
Repeat Client
United States
He was very professional on the work and responded quickly.
Helpful?
Reviews
5 reviews for this Gig
| (5) | ||
| (0) | ||
| (0) | ||
| (0) | ||
| (0) |
Rating Breakdown
- Seller communication level
- Recommend to a friend
- Service as described
Sort By
Most relevant
U user23972726
Repeat Client
United States
Thank you very much
Helpful?U user23972726
Repeat Client
United States
Thank you once again. Very talented person.
V Seller's Response
Helpful?U user23972726
Repeat Client
United States
Completed my work within few hours and was very helpful about explaining unknown terms to me.
Helpful?L liujiji
Repeat Client
United States
Very professional, always follow up the work
Helpful?L liujiji
Repeat Client
United States
He was very professional on the work and responded quickly.
Helpful?
