Run Code
|
API
|
Code Wall
|
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
loggin_trigger-audit
cpana
SQL social network practice by Han Wang 20200720 - 2
Social Network SQL
nested array to table
Q3
Return IDs where there are exactly 3 occurrences
Ecommerce Website Analysis by SQL
SQL Practice Sample: Movie Database
Krug_test