Table -> Generate Statement -> MERGE

I'd like to suggest that along with being able to generate a basic insert, update and select statement for a table, it would be nice if TOAD could generate a basic merge statement as well. You could leave the USING portion of the merge statement blank, but still generate the update and insert clauses for me with all the columns of the table. As an example, consider the following table:-

CREATE TABLE EXAMPLE_TBL
(
   COL1   VARCHAR2 (50),
   COL2   VARCHAR2 (50)
);

Generate for me the following merge statement:-

MERGE INTO example_tbl d
     USING (/* insert your merge source here */) s
        ON (/* insert your merge condition here */)
WHEN MATCHED
THEN
   UPDATE SET d.col1 = s.col1, d.col2 = s.col1
WHEN NOT MATCHED
THEN
   INSERT     (d.col1, d.col2)
       VALUES (s.col1, s.col2);

Regards,

Mike McAllister 
Principal Systems Engineer
Decypher
DSN:                      487-3751
Commercial:       (210) 652-3751
Cell:                       (512) 423-7447
Email:                    [email protected]




------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
    http://groups.yahoo.com/group/toad/

<*> Your email settings:
    Individual Email | Traditional

<*> To change settings online go to:
    http://groups.yahoo.com/group/toad/join
    (Yahoo! ID required)

<*> To change settings via email:
    [email protected] 
    [email protected]

<*> To unsubscribe from this group, send an email to:
    [email protected]

<*> Your use of Yahoo! Groups is subject to:
    http://docs.yahoo.com/info/terms/