从一个表中选择，插入到另一个表中 oracle sql 查询
声明：本页面是StackOverFlow热门问题的中英对照翻译，遵循CC BY-SA 4.0协议，如果您需要使用它，必须同样遵循CC BY-SA许可，注明原文地址和作者信息，同时你必须将它归于原作者（不是我）：StackOverFlow
原文地址: http://stackoverflow.com/questions/20261332/
Warning: these are provided under cc-by-sa 4.0 license. You are free to use/share it, But you must attribute it to the original authors (not me):
StackOverFlow
select from one table, insert into another table oracle sql query
提问by user3003451
I am trying to select data from one table
and insert the data into another table
我正在尝试从一个表中选择数据
并将数据插入到另一个表中
SELECT ticker FROM tickerdb;
Using OracleSql I am trying to
get the ticker symbol "GOOG" from the tickerdb table,
and insert the t.ticker into the stockdb table.
使用 OracleSql 我试图
从tickerdb 表中获取股票代码“GOOG”，并将t.ticker
插入到stockdb 表中。
select from tickerdb table --> insert into quotedb table
从tickerdb表中选择-->插入到quotedb表中
INSERT INTO quotedb
(t.ticker, q.prevclose, q.opn, q.rnge,
q.volume, q.marketcap, q.dividend, q.scrapedate)
VALUES (?,?,?,?,?,?,?,?,SYSDATE)
tickerdb t inner JOIN quotedb q
ON t.ticker = q.ticker
回答by Keerthivasan
From the oracle documentation, the below query explains it better
从 oracle 文档中，下面的查询更好地解释了它
INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
You can read this link
你可以阅读这个链接
Your query would be as follows
您的查询如下
//just the concept
INSERT INTO quotedb
(COLUMN_NAMES) //seperated by comma
SELECT COLUMN_NAMES FROM tickerdb,quotedb WHERE quotedb.ticker = tickerdb.ticker
Note: Make sure the columns in insert and select are in right position as per your requirement
注意：确保插入和选择中的列根据您的要求位于正确的位置
Hope this helps!
希望这可以帮助！
回答by vkamayiannis
You can use
您可以使用
insert into <table_name> select <fieldlist> from <tables>
回答by KethanKumar
回答by Rajasekahr
try this query below:
试试下面的这个查询：
Insert into tab1 (tab1.column1,tab1.column2)
select tab2.column1, 'hard coded value'
from tab2
where tab2.column='value';
