Em Andamento

pl/sql building blocks

write some pl/sql blocks. the questions are provided in the attachement picture

set serveroutput on

DECLARE

pledgeid [url removed, login to view]%TYPE;

amtpledge [url removed, login to view]%TYPE;

monthspay [url removed, login to view]%TYPE;

datepay [url removed, login to view]%TYPE;

amtpay [url removed, login to view]%TYPE;

donorid [url removed, login to view]%TYPE;

CURSOR cur_pledges IS

SELECT [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view], [url removed, login to view]

FROM dd_pledge pl JOIN dd_payment pay

ON [url removed, login to view] = [url removed, login to view]

WHERE [url removed, login to view] = 309

ORDER BY [url removed, login to view], [url removed, login to view];

BEGIN

OPEN cur_pledges;

LOOP

FETCH cur_pledges INTO pledgeid, amtpledge, monthspay, datepay, amtpay, donorid;

DBMS_OUTPUT.PUT_LINE('Pledge ID: '|| pledgeid || ' Pledge Amount: '|| amtpledge || ' Monthly Payments: '|| monthspay || ' Payment Date: '|| datepay || ' Amount Paid: '|| amtpay );

EXIT WHEN cur_pledges%NOTFOUND;

END LOOP;

CLOSE cur_pledges;

END;

/

Habilidades: PostgreSQL, SQL

Ver mais: sql select order, postgresql sql, sql questions, blocks, building blocks, pledge, simple web building sql, loop picture, building sql front end, declare sql, sql last recent order, childrens building blocks photoshop

Acerca do Empregador:
( 12 comentários ) Washington, United States

ID do Projeto: #5116650

Premiar a:

BhargavaB

Hi This is bhargava expert Sql and Pl/sql . I am already completed this kind of projects successfully . i am ready to provide quick and efficient solution . Looking forward your message .

$20 USD em 1 dia
(4 Avaliações)
2.8

7 freelancers estão ofertando em média $32 para este trabalho

elboukharimu

Hi, I'm very interested helping you creating your pl sql script, I have years of experience in SQL and database administration, modeling, and manipulating, please do not hesitate to check my portfolio, there is some sa Mais

$74 USD in 3 dias
(8 Comentários)
4.0
nibiranijum

Hi, First of all thanks for posting such a project. I am oracle certified developer and dba with more than 5 years of experience. I am expert in SQL, PL/SQL. I did lots of oracle project in freelancer. http://ww Mais

$35 USD in 3 dias
(3 Comentários)
3.6
truongnguyen86

hi akosuaasiedu, sorry for the last time, it was my bad day, my computer and my network was totally down. This time i want to do this for you, i will finish it in 1 day, pls trust me this time, i will not disapoint you Mais

$18 USD em 1 dia
(1 Comentário)
1.0
rengrish

I am interested in this job. Ready to take up right now. I am oracle database developer with over 4+ years of experience . I can handle postgreSQL too . Kindly let me know .

$25 USD in 2 dias
(0 Comentários)
0.0
truongbk24

plsql is my current job, pls check porfolio for more details. Can do this in 1 day, i really want to work with you. pls award me this

$30 USD em 1 dia
(0 Comentários)
0.0
singharun7

i have an exp in pl/sql i can do your task plz provide all details.. so that i can start it quickly ... i m waiting for your reply....... thank you

$25 USD in 3 dias
(1 Comentário)
0.0