Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Patreon
test
CREATE OR REPLACE FUNCTION prem_fun() RETURNS void AS $BODY$ DECLARE f_c_l integer; -- not too sure if this needs to be declared or not result int; BEGIN FOR f_c_l IN select * from emp_leave_balance LOOP update emp_levae_balance set c_l = result+1 WHERE party_id = ''; END LOOP; END $BODY$ LANGUAGE plpgsql
run
|
edit
|
history
|
help
0
Please
log in
to post a comment.
G.Giftcard Interview Analysis Conducted by Miranda Zhao
Cilinica_X
Joins and Case
Ultima Clase
post
SQL Practice Sample: Movie Database
univesp
LeetCode 262
2
Stack
Please log in to post a comment.