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
Query integer in text field - Seemingly doesn't work as expected
Weekly Average Starting on Different Days
SQL - Social Network Analysis by Patrick Lin
1280. Students and Examinations
Joins and Case
Food Delivery Website SQL Analysis
SQL social network practice by Han Wang 20200720
book suggestion
Select rows only with values separated by a given interval from other ...
generate-data-combinations-for-a-column-dynamically-based-on-another-column-sql-postgresql