Syntax SELECT INTO hanya berlaku di dalam PL/SQL .... DECLARE var1 VARCHAR2(100); var2 VARCHAR2(100); var3 VARCHAR2(100); BEGIN SELECT SUBSTR(col1,1,INSTR(col1,' ')-1), SUBSTR(col1,INSTR(col1,' ')+1,INSTR(col1,' ',INSTR(col1,' ')+1) - INSTR(col1,' ')), SUBSTR(col1,INSTR(col1,' ',INSTR(col1,' ')+1)+1) -- INTO clause ... INTO var1, var2, var3 from TABLE_A; ... ... END;
--- In [email protected], "ItSection" <[EMAIL PROTECTED]> wrote: > > Apakah dengan query SELECT INTO bisa juga..? > > ----- Original Message ----- > From: Yulius Wibowo > To: [email protected] > Sent: Thursday, February 22, 2007 2:40 PM > Subject: [indo-oracle] Re: memisahkan isi tabel > > > INSERT INTO TABLE_B > select SUBSTR(col1,1,INSTR(col1,' ')-1), > SUBSTR(col1,INSTR(col1,' ')+1,INSTR(col1,' ',INSTR(col1,' ')+1) - > INSTR(col1,' ')), > SUBSTR(col1,INSTR(col1,' ',INSTR(col1,' ')+1)+1) > from TABLE_A; > > Alternatif laen, > di dump ke text file dulu, lalu di proses pakai script processor spt > misalnya awk, gawk ... lalu di insert balik ke table_B > > CMIIW, > > Bowo > > --- In [email protected], "Imam Nursianto" <imamnurs@> > wrote: > > > > > > > > mohon pencerahan dunk, > > Saya punya table yang ada kolom nama, kemudian > > isi kolom nama tersebut ingin saya pecah dalam 3 column di table > yang > > berbeda gimana caranya yaa.... > > misalnya : > > > > table : > > A > > > > > > > > B > > column : > > nama > > ----> nama_depan, nama_tengah, nama_belakang > > agus nur rahman > > ---> > > agus > > , > > nur > > , rahman > > > > Terima Kasih, > > > > Imam Nursianto > > > > > > > > [Non-text portions of this message have been removed] >
