En cours

Oracle Developer- Procedure

This is a business requirement I have included E-R Diagram for table cust_001 in the end and Schema of all tables in the sql file.

Task-1 :

Create a Procedure that will dynamically insert data from QA2 to Test env in the same database. (Need to take care of all the reference tables (i.e FK constraints) of the table passed in the parameter)

Parameters : Table name , DB link name , Unique ids (Cust_id/fyon).

DBLinks:

CREATE PUBLIC DATABASE LINK DPCDBQ2

CONNECT TO PC00CDB

IDENTIFIED BY <password>

USING '(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)

(HOST=gotsvl3121)(PORT=1521)))

(CONNECT_DATA=(SERVICE_NAME=DPCDBQ2)))';

CREATE PUBLIC DATABASE LINK DPCDBT

CONNECT TO CDB_LU_IT

IDENTIFIED BY <password>

USING '(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = [login to view URL])(PORT = 1521)) (CONNECT_DATA = (SERVER = DEDICATED) (UR=A) (SID = dpcdbt)))';

Task-2 :

Create a procedure that will take backup of the consumer (all the reference table) where it stores all the consumer details.

Parameter : Cust_id

The backup should be of all the data which is being referenced for a particular Cust_id as Cust_id is primary key it's been used everywhere we want to take backup of data just by entering Cust_id.

Any more information please let me know.

Compétences : Oracle, SQL, Administration de Bases de données, MySQL

en voir plus : convert sql stored procedure oracle stored procedure, freelancer oracle developer projects, oracle developer alexandriaegypt, oracle ddl procedure, job oracle developer karachi, oracle developer programming bids, graphics designs oracle developer forms, oracle developer egypt 2009, oracle developer moscow, prepare business requirement specification functionality medical clinics documentation, freelance oracle developer egypt, finger printing software oracle developer, oracle developer 10g fingerprint, oracle developer desired technical strength, oracle developer karachi, web developer example business requirement documents, oracle developer working business suite, i need an oracle developer, This is requirement for a small offline business. I want to start selling my product and services online., execute oracle stored procedure with parameters in sql developer

Concernant l'employeur :
( 0 commentaires ) Mumbai, India

Nº du projet : #29872904

Décerné à:

BeninTechy

Hi I am glad to see your requirement as it opts to my technical skills I have worked vastly in Oracle Sql/Plsql, Have created many tables and have defined its attributes and I am sure no issues will come for you for ye Plus

%selectedBids___i_sum_sub_7% %project_currencyDetails_sign_sub_8% INR en 7 jours
(0 Commentaires)
0.0

2 freelances font une offre moyenne de 825 ₹ pour ce travail

fastlabindia

Greetings!. I checked your 'Oracle Developer- Procedure' requirements. Your work is one of the tasks that can be done very perfectly by us. I am good in MySQL , MS ACCESS, MS SQL, Oracle , No SQL and other DBMS softwar Plus

%bids___i_sum_sub_35% %project_currencyDetails_sign_sub_36% INR en 2 jours
(12 Commentaires)
4.2