מדרש על דניאל 4:2

Let our master instruct us further: What is the difference between the dreams of the righteous and the dreams of the wicked? The dreams of the wicked are neither in the heavens nor on the earth. Thus it is stated (in Gen. 41:1): PHARAOH DREAMED, AND THERE HE WAS STANDING ON THE NILE. So also it is written of Nebuchadnezzar (in Dan. 4:2): {IT WAS} [I SAW] A DREAM, AND IT MADE ME AFRAID, for he was neither on the earth nor in the heavens (cf. vss. 7-8). However, the dreams of the righteous are < both > in the heavens and on the earth. You therefore find that Joseph said to his brothers (in Gen. 37:7): HERE WE WERE BINDING SHEAVES: Ergo, < his dreams were > on the earth. Where is it shown that they were also in heaven? Where it is stated (in Gen. 37:9): HERE WERE THE SUN, THE MOON, AND ELEVEN STARS BOWING DOWN TO ME. So also it was in the case of our father Jacob (according to Gen. 28:12): THEN HE DREAMED THAT HERE WAS A LADDER [PLACED ON EARTH WITH ITS TOP REACHING TO THE HEAVENS. Ergo, < his dream was both > in the heavens and on the earth].