OoooOoooO ngono tho critane .... Pokoknya semua yg ditulis dan dijalankan lewat TOAD atau PL/SQL Developer atau SQL*Plus ... sebutannya "QUERY" ... :-)
Iya ya, bener juga ya,... khan semuanya termasuk perintah SQL (structure QUERY language), .... naruhodo neee !!! bw --- In [email protected], Faridh Wisanggeni <faridh_wisangg...@...> wrote: > > Ohh kalo istilah2 itu sich saya blm tahu mas, > kalau disini yang senior bilangnya dengan istilah query, > apapun tulisannya, yg penting ditulis di TOAD dan PL SQL > hehehehe > > > > > ________________________________ > Dari: yulius_wibowo <yulius_wib...@...> > Kepada: [email protected] > Terkirim: Jum, 11 Juni, 2010 07:34:42 > Judul: Re: Bls: [indo-oracle] QUERY DROP ALL > > > 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_wisanggeni@> > wrote: > > > > Hehehehe > > > > Kalo itu aku bisa, Justru pengen usernya yg gak di drop, cuma isinya aja > > > > > > Thank's Yup > > > > > > > > > > > > > > > > > > > > ________________________________ > > Dari: Yoel Susanto <yoel.susanto@> > > 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 > > <komang108@>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_wisanggeni@> 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] > > > > > > > > > [Non-text portions of this message have been removed] >
