从一个表中选择，插入到另一个表中 oracle sql 查询

2021-12-19 00:00:00 sql select insert oracle

我正在尝试从一张表中选择数据
并将数据插入到另一个表中

I am trying to select data from one table
and insert the data into another table

    SELECT ticker FROM tickerdb;

我正在尝试使用 OracleSql
从tickerdb表中获取股票代码GOOG"，
并将 t.ticker 插入到 stockdb 表中.

Using OracleSql I am trying to
get the ticker symbol "GOOG" from the tickerdb table,
and insert the t.ticker into the stockdb table.

从tickerdb表中选择-->插入到quotedb表中

select from tickerdb table --> insert into quotedb table

    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

推荐答案

从 oracle 文档中，下面的查询更好地解释了它

From the oracle documentation, the below query explains it better 

INSERT INTO tbl_temp2 (fld_id)
SELECT tbl_temp1.fld_order_id
FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;

您可以阅读此链接

您的查询如下

//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

希望这有帮助！

相关文章