INSERT INTO T1 MATCH_COLUMNS SELECT ‘X’ C1, T2.C2 C2 FROM T2). INSERT INTO T1 VALUES (C1=> ‘X’, C2=> LOCAL_VAR)) and some MATCH_COLUMNS syntax to do INSERT… SELECT… using the SELECT’ed column aliases to point to the desired INSERT columns (e.g. The best of all worlds would be if Oracle offered an INSERT syntax that allowed one to parameterize VALUES clause (e.g. For writing my own INSERT, your solution is fine for generating code to load constants only, but usually I’m writing said INSERT into a PL/SQL procedure inserting a mix of constants and variables (using the values clause), or I’ve got an INSERT/SELECT command. To be clear, call it 80/20 – 80% I’m picking up an INSERT coded by someone else, 20% I’m coding my own from scratch. We love our snark here at Quest Software 😉 Be sure to use a ‘real’ name, so that I can track you down later to get your shipping information.Leave your question as a comment on this page.We’ll run this gig for as long as people keep asking great questions, or until we run out of Toad beanies. The promotion is for our Public Sector Customers in the United States of America, but I am happy to take questions from any and all users from around the world. Please keep the questions to a technical nature, although if you have pricing or licensing questions, I’ll answer those off-line for you, no worries. I’ll answer any and all questions submitted. If I like your question, you get a Toad beanie. We’re looking for challenging questions dealing with Oracle Database and Toad, for example: Ask questions, get answers – and a Toadie!

Toad for sql server developer edition