Create a Procedure in Oracle (insert)
$2-8 USD / hour
I want a Procedure in Oracle that will do:
insert A_B with the following values
B_c VARCHAR2(6 BYTE) input,
B_d VARCHAR2(4 BYTE) input
B_e VARCHAR2(20 BYTE) input
B_f NUMBER(18,2), always 99999999999999
B_g NUMBER(18,2) input
B_h NUMBER(18,2) always 99999999999999
B_i NUMBER(4) NOT NULL this year
B_j NUMBER(2) 0
B_k VARCHAR2(40 BYTE) always 'PROCEDURE'
B_l VARCHAR2(40 BYTE) current day time ,
B_m NUMBER(8) 99999999,
B_n NUMBER(16,2) 0,
B_o VARCHAR2(30 BYTE) null,
B_p VARCHAR2(40 BYTE) spaces
It will have an output variable: in the successful insert it will fill with zeros (0)
else the error code
Project ID: #9376301
About the project
2 freelancers are bidding on average $6/hour for this job
Hello, My name is Elena. I am an Oracle developer for 4 years. I can help you with your project. For further questions regarding my experience and my work, do not hesitate to contact me. Best regards, Elena