Hi all, I'm about to fill table table1 (field1, field2, etc.) using different statements (and maybe variables) for each field. My statements are too different to combine them into one query, but my example is simple: statement 1: Code (SQL): SELECT ttt AS field1 FROM dual statement 2: Code (SQL): SELECT yyy AS field2 FROM dual Each statement returns one value. Maybe I need some variable for each value, so var_field1 = field1, var_field2 = field2, etc. As a result I need to fill table table1 using my variables, so it must be some procedure. Could you please show me some example, how this procedure should be written?