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

User · Answer

You will get useful information from here   SELECT ticker INTO quotedb FROM tickerdb

User · Answer

try this query below   Insert into tab1  tab1 column1 tab1 column2   select tab2 column1   hard coded  value   from tab2  where tab2 column  value

User · Answer

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

User · Answer

You can use   insert into  lt table name gt  select  lt fieldlist gt  from  lt tables gt

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

Examples related to sql

Examples related to oracle

Examples related to select

Examples related to insert