How to create Procedure/funciton to disply result of a query

Off-Topic
1

How to create Procedure/funciton to display the result of a query?

I have a table emp.

select * from emp;

I would like to display the result set of the above query using stored procedure.

2

You can use an ECHO SELECT function.
See the details here:

Depending on your use case you can also look at using a TVF.