When I click and drag a table to the SQL Window and release the button a list of possibilities comes up, I'd like another that would take and define variables for me:

if table = 'mine'
with fields 'one', 'two' and 'there'

I'd like to see

v_one mine.one%type;
v_two mine.two$type;
v_three mine.three$type;

Thank you.

I have added this to the list of enhancement requests.