Q:  When I create a trigger in TOAD using code like the following:

CREATE OR REPLACE TRIGGER NEW_BP

BEFORE INSERT ON BP

FOR EACH ROW

BEGIN

SELECT B_SEQ.nextval INTO :new.BP_ID from DUAL;

END;

I get this stupid dialog box named "variables" where it wants me to give a value to the variable :NEW which isn't a variable at all.

A)  If you execute this as a script(by pressing the 'execute as script' button) instead of a statement, you will not get that stupid dialog box.

12:57:50 PM    

Q:  I wish I could show all the column comments in the column tab aligned with their respective columns instead of down below where I can't see them all at the same time.

A:  Right click anywhere in your schema browser and select the "Show Column Comments in List" option and you will see all the comments all the time

12:47:29 PM    

Q: How do I issue a commit in toad via a keyboard shortcut?

A: Right-click on the menu bar and select "menu shortcuts".  In the menu shortcut customization dialog, scroll down and select database commit.  Once it is selected, you can define a shortcut by pressing Control with some other key (I used CTRL-K)

9:11:04 AM