Oracle sql - global variable -

I have two SQL script files that should be set as window jobs. 1. SQL has begun in: column dat1 new_value DAY_NUMBER; Select from dual 2 to 2;

While the 2. SQL is in the beginning: column dat1 new_value DAY_NUMBER; Choose from dual to 1 dat1;

If I am going to combine this two script into one, will DAY_NUMBER be set to 1?

Thank you very much.

Sara

I think this will generate an error:

  column dat1 new_value DAY_NUMBER; Select from dual 2 to 2; Column dat1 new_value DAY_NUMBER; Choose from dual to 1 dat1;  

The error is that you will have the same column variation declared dat1 twice.