The order in which the Oracle cursor takes data

Such as:

Cursor C_columns (t_table_name varchar) is select column_name from user_tab_columns WHERE table_name = T_table_name Order b Y table_name,column_id;

V_txt1:= ';
For V_col in C_columns (V_tablename) loop--use a For loop to traverse cursor content (for simplicity)
V_column: = V_col.column_name;
If V_column = ' statdate ' THEN
v_txt1:=v_txt1| | ' ' 20161130 ' as ' | | V_column;
Else
v_txt1:=v_txt1| | ', ' | | V_column;
End If;
End Loop;

The cursor is ordered by, and is read in sorted order

Do not add order by the default sort, preferably by, as for Ordey by random see your field uniqueness, is generally added a primary key to sort.