July 2013 ~ Dream Big, Start Small, Act Now

Anda ingin mengcopi record pada tabel A ke tabel B dengan bantuan Toad Oracle dengan mengikuti petunjuk image di bawah ini.

Pertama-tama adalah gunakan filter untuk menyeleksi record dari range 1 sampai range 2
misal anda hanya akan mengexport data dengan route ID = 14000 saja

kemudian klik kanan dan save as

akan muncul pilihan, pilihlah insert statement

Simpan file tersebut di directori/folder yang anda inginkan dengan menentukan nilai Save To :
contoh hasil export file tadi copi hasil tersebut ke Toad dan tekan F5
SET DEFINE OFF;
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 21, 1, 26);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 21, 4, 56);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 1, 35);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 2, 27);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 3, 36);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 5, 38);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 6, 39);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 7, 40);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 9, 46);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 10, 45);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 11, 48);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 22, 12, 41);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 1, 28);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 2, 34);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 3, 37);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 4, 50);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 5, 49);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 6, 30);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 7, 31);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 8, 29);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 9, 50);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 10, 49);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 11, 31);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 12, 30);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 13, 29);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 14, 32);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 17, 43);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 18, 47);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 22, 33);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 23, 27, 42);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 24, 2, 44);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 1, 57);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 2, 64);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 3, 71);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 4, 78);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 5, 57);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 6, 64);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 7, 71);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 8, 78);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 9, 57);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 10, 64);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 11, 71);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 12, 78);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 25, 58);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 26, 65);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 27, 72);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 28, 79);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 29, 58);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 30, 65);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 31, 72);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 32, 79);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 33, 58);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 34, 65);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 35, 72);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 36, 79);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 37, 62);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 38, 69);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 39, 76);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 40, 83);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 41, 62);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 42, 69);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 43, 76);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 44, 83);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 45, 62);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 46, 69);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 47, 76);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 48, 83);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 49, 59);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 50, 66);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 51, 73);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 52, 80);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 53, 59);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 54, 66);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 55, 73);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 56, 80);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 57, 59);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 58, 66);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 59, 73);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 60, 80);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 61, 63);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 62, 70);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 63, 77);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 64, 84);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 65, 63);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 66, 70);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 67, 77);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 68, 84);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 69, 63);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 70, 70);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 71, 77);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 72, 84);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 73, 61);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 74, 68);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 75, 75);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 76, 82);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 77, 61);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 78, 68);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 79, 75);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 80, 82);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 81, 61);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 82, 68);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 83, 75);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 84, 82);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 85, 60);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 86, 67);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 87, 74);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 88, 81);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 89, 60);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 90, 67);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 91, 74);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 92, 81);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 93, 60);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 94, 67);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 95, 74);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 25, 96, 81);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 26, 1, 53);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 26, 2, 52);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 26, 7, 51);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 26, 10, 54);
Insert into L8PHOTO.PHOTO_ROUTE_DTL
   (ROUTE_ID, GROUP_ID, PHOTO_ID, PHOTO_ID_DEST)
Values
   (14000, 26, 11, 55);
COMMIT;

Dream Big, Start Small, Act Now

Rabbi zidni 'ilman war zuqni fahman
“Yaa Rabb, tambahkanlah ilmu bagiku, dan berilah aku kefahaman”
“… Maha Suci Engkau, tidak ada yang kami ketahui selain dari apa yang telah Engkau ajarkan kepada kami …”

Menu

Mengcopi file record database pada tabel A ke tabel B dengan TOAD Oracle

Popular Posts

Blog Archive

Daftar Blog Teman