title: SELECT * FROM TABLE(pipelined function): can I be sure of the order of the rows in the result?
body: <p>In the following example, will I always get “1, 2”, or is it possible to get “2, 1” and can you tell me where in the documentation you see that guarantee if it exists? </p>
  
  <p>If the answer is yes, it means that without <code>ORDER BY</code> nor <code>ORDER SIBLINGS</code> there is a way to be sure of the result set order in a SELECT statement.</p>
  
  <pre><code>CREATE TYPE temp_row IS OBJECT(x number);
  /
  
  CREATE TYPE temp_table IS TABLE OF temp_row;
  /
  
  CREATE FUNCTION temp_func
  RETURN temp_table PIPELINED
  IS
  BEGIN
      PIPE ROW(temp_row(1));
      PIPE ROW(temp_row(2));
  END;
  /
  
  SELECT * FROM table(temp_func());
  </code></pre>
  
  <p>Thank you.</p>