In a plsql block you can use parameters, ref cursors or arrays to return tabular data and do if/then/else/while logic.