Use ALTER PIPELINE to add steps to a pipeline.

 

1. Add Step 1.

 

1 SQL> alter pipeline p_pay_extract add step s_get_month_period_type;

 

2. Add Step 2.

 

1 SQL> alter pipeline p_pay_extract add step s_set_period_end_date;

 

3. Add Step 3.

 

1 SQL> alter pipeline p_pay_extract add step s_set_period_name;

 

4. Add Step 4.

 

1 SQL> alter pipeline p_pay_extract add step s_create_pay_extract;