Sekedar mo tanya ttg istilah yg dipakai, setahu saya istilah QUERY itu utk perintah SELECT. makanya saya rada bingung, kok pake istilah QUERY DROP, QUERY DELETE (pada thread yg lain), QUERY PL/SQL, .... :-) :-)
Apakah yg dimaksud adalah QUERY (perintah SELECT) utk menghasilkan script perintah DROP xxx ? cmiiw, bw --- In [email protected], Faridh Wisanggeni <faridh_wisangg...@...> wrote: > > Hehehehe > > Kalo itu aku bisa, Justru pengen usernya yg gak di drop, cuma isinya aja > > > Thank's Yup > > > > > > > > > > ________________________________ > Dari: Yoel Susanto <yoel.susa...@...> > Kepada: [email protected] > Terkirim: Jum, 11 Juni, 2010 05:52:20 > Judul: Re: [indo-oracle] QUERY DROP ALL > > > cara paleng gampang.. drop user dan recreate usernya... > sebelumnya backup dulu > > Cheers, > Yoel Susanto > > On Fri, Jun 11, 2010 at 11:38 AM, I Nyoman Sukaryawan > <komang...@...>wrote: > > > pake script aja ;) > > > > BEGIN > > FOR cur_rec IN (SELECT object_name, object_type > > FROM user_objects > > WHERE object_type IN ('TABLE', 'VIEW', 'PACKAGE', > > 'PROCEDURE', 'FUNCTION', 'SEQUENCE')) > > LOOP > > BEGIN > > IF cur_rec.object_type = 'TABLE' THEN > > EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || > > cur_rec.object_name || '" CASCADE CONSTRAINTS'; > > ELSE > > EXECUTE IMMEDIATE 'DROP ' || cur_rec.object_type || ' "' || > > cur_rec.object_name || '"'; > > END IF; > > EXCEPTION > > WHEN OTHERS THEN > > DBMS_OUTPUT.put_line('FAILED: DROP ' || cur_rec.object_type || ' "' > > || cur_rec.object_name || '"'); > > END; > > END LOOP; > > END; > > / > > > > > > > > On Thu, Jun 10, 2010 at 7:57 PM, Faridh Wisanggeni < > > faridh_wisangg...@...> wrote: > > > > > > > > > > > Dear All, > > > > > > Ada gak sich, query untuk DROP all table,view,package,function dll > > didalam > > > satu user, shingga di usr itu kosong semua...?? > > > > > > Thank's before, > > > > > > Faridh Wisanggeni > > > > > > [Non-text portions of this message have been removed] > > > > > > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > > ------------------------------------ > > > > -- > > -----------I.N.D.O - O.R.A.C.L.E--------------- > > Keluar: [email protected] > > Website: http://indooracle.wordpress.com > > http://www.facebook.com/group.php?gid=51973053515 > > ----------------------------------------------- > > > > Bergabung dengan Indonesia Thin Client User Groups, > > Terminal Server, Citrix, New Moon Caneveral, di: > > http://indo-thin.blogspot.comYahoo! Groups Links > > > > > > > > > > [Non-text portions of this message have been removed] > > > > > > > [Non-text portions of this message have been removed] >
