Run Code
|
API
|
Code Wall
|
Users
|
Misc
|
Feedback
|
Login
|
Theme
|
Privacy
|
Blog
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.
test_tags_count
Professional Networking Social Media Website SQL Analysis
Tememons Dashboard
Select all countries that can be found by recursively adding all neighbouring countries (PostgreSQL)
G.Giftcard Interview Analysis Conducted by Miranda Zhao
Select rows only with values separated by a given interval from other ...
PC02-DB-UTEC
1
fgf
PostreSQL: CASE
stackse - search stackoverflow differently
Please log in to post a comment.