如何从存储过程返回多个行?(Oracle PL / SQL)

I want to create a stored procedure with one argument which will return different sets of records depending on the argument. What is the way to do this? Can I call it from plain SQL?I want to create a stored procedure with one ar