grab all records from one table to another oracle sql

Solutions on MaxInterview for grab all records from one table to another oracle sql by the best coders in the world

Search
showing results for - "grab all records from one table to another oracle sql"
Esperanza
24 Jun 2019
1--tbl_temp1 is the source
2--tbl_temp2 is the destination
3--fld_id is the columns you want to bring over
4--where statement is up to you!
5
6INSERT INTO tbl_temp2 (fld_id)
7SELECT tbl_temp1.fld_order_id
8FROM tbl_temp1 WHERE tbl_temp1.fld_order_id > 100;
9
source
similar questions
oracle sql select all days between two dates except weekendsoracle sql select from multiple tablesoracle finding duplicate recordst sql get duplicate rowsoracle columns in all tablesoracle function return multiple rowsshow all tables in oracleoracle find all tables with column namesql select all from one table and one column from anothercopying data from one table to another in sqloracle sql like multiple valuesoracle all tablesoracle select first 10 rowsoracle sql get value from several rows and concatenate stringshow to see all table partition in oracleoracle sql copy table without datafind all tables where column name exists oraclesql search all columns of database oracle sqloracle list duplicatesoracle duplicate tablecopy table oraclesql get rows with duplicate valuesget duplicate records in sqloracle function return tableinserting data into different tables at once in oracle sql
queries leading to this page
how to get all the records from 2 tables in oraclegrab all records from one table to another oracle sqlgrab all records from one table to another oracle sql