Riddonkulous

In a hero's hands, I'm the means by which a great dragon they could slay. But move my first to my tail, and a still mightier weapon you'll find, some say.