Summary - Stored procedure

Write a balance update with CREATE PROCEDURE.

A stored procedure is SQL code stored in the database. Created with CREATE, called with CALL.

CREATE PROCEDURE get_active() AS $$
  SELECT * FROM customers WHERE status = 'active';
$$;

Summary procedure.

The procedure get_active is created. All columns are selected from customers. WHERE keeps only the rows where status = 'active' holds.

Exercise Summary - Stored procedure

Summary: create the get_active procedure.

Show example solution

CREATE PROCEDURE get_active() AS $$
  SELECT * FROM customers WHERE status = 'active';
$$;