ODP: [firebird-support] Insert into Select
Hi Whay not two separate "update or insert” for parent and child? You can use „merge” for massive „"update or insert” on single table. Regards, Karol Bieniaszewski
Re: [firebird-support] Insert into Select
01.12.2019 04:56, dmil...@amfes.com [firebird-support] wrote: > As I said - I can do this via stored procedures - but is there a way to do it > without? If you want to insert records to two tables with single query - you cannot. If you don't want to use a stored procedure then the closest approach is an updatable view. -- WBR, SD. ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/
[firebird-support] Re: Insert into Select
dmil...@amfes.com [firebird-support] a écrit : > That's just an "anonymous" procedure. I suppose it is technically something a > client can run without having to define it in the database first - but I was > hoping for something using just insert & select. I do not understand English enough to feel the finesse of your question. but, if execute block does not suit you, there is always the possibility with merge when matched .. / when not matched then insert ... -- Norbert Saint Georges http://tetrasys.fi ++ Visit http://www.firebirdsql.org and click the Documentation item on the main (top) menu. Try FAQ and other links from the left-side menu there. Also search the knowledgebases at http://www.ibphoenix.com/resources/documents/ ++ Yahoo Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/firebird-support/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/firebird-support/join (Yahoo! ID required) <*> To change settings via email: firebird-support-dig...@yahoogroups.com firebird-support-fullfeatu...@yahoogroups.com <*> To unsubscribe from this group, send an email to: firebird-support-unsubscr...@yahoogroups.com <*> Your use of Yahoo Groups is subject to: https://info.yahoo.com/legal/us/yahoo/utos/terms/