title: Need an equivalent function for this T-Sql function in PL/SQL Oracle. If there is other solution then Pipelining
body: <pre><code> ALTER  FUNCTION [dbo].[MyFun]()
   RETURNS  TABLE 
   AS
   RETURN 
   (
   WITH addd(CITY_NAME,CITY_ID)
   AS
   (
      select CITY_NAME,CITY_ID from city
   )
    select * from addd
   )
  </code></pre>
  
  <p>Pipelining is not required because I want to call it direct as called in T-SQL for example</p>
  
  <pre><code>Select * from myfun();
  </code></pre>