The first issue is the initial select doesn't have a from clause. While is valid in SQL Server, it's not in Oracle. You always have to specify a from clause. We only want the query to return one row, so we can put dual to good use: with cte as (. select dateadd(mm, -1, convert(date, getdate())) as dt.
Place six pizza rolls on microwavable plate. Space rolls one inch apart. Place plate in microwave. Cook 55 seconds on high. If more time is needed, turn the plate around and cook for 10 additional seconds.
Deflate the dough and turn it out onto a lightly floured surface and roll into a 10x 14 inch rectangle. Lightly brush the far edge with water. In a small bowl combine the cinnamon and 3/4 cup brown sugar and sprinkle over the rectangles. Then sprinkle the raisins and chopped nuts over the dough. Roll up the dough into a log and seal the seam. Cut the dough into 12 equal pieces; place the pieces in a greased 9x13 inch baking pan, or 12 inch deep dish pizza pan. Cover with plastic wrap and place in the refrigerator to rise overnight. The next morning, preheat oven to 375 degrees F (190 degrees C). Take the rolls out of the refrigerator and let stand at room temperature for 30 minutes. Bake the rolls for 25 to 30 minutes or until golden. Meanwhile, combine the corn syrup with the vanilla in a small bowl. Whisk in the powdered sugar and enough cream to make a thick glaze; set aside.