select from one table, insert into another table oracle sql query

Question

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.

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 

Answer 1

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; 

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!