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 in pl sql, in pl sql, SQL PL SQL , pl\sql, pl/sql, pl-sql, sql select order, postgresql sql, sql questions, blocks, building blocks, pledge, years sql pl sql working experience fake, simple web building sql, oracle sql pl sql jobs malaysia, loop picture, building sql front end, sql query find last order date, sql query display descending order, declare sql, sql server running total update order, sql last recent order, childrens building blocks photoshop, oracle sql order numbers last

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