oracle中如何表存在先刪除后創(chuàng)建？如果是沒有權(quán)限的話，照這下面做就就ok啦了：grantsysdba,dba,createsession,createanytable,createanyview,

oracle中如何表存在先刪除后創(chuàng)建？

如果是沒有權(quán)限的話，照這下面做就就ok啦了：grantsysdba,dba,createsession,createanytable,createanyview,createanyindex,createanyprocedure,alteranytable,alteranyprocedure,traceanytable,pullanyview,traceanyindex,moveanyprocedure,selectanytable,insertanytable,notificationanytable,deleteanytabletotest_data(數(shù)據(jù)庫(kù)用戶名);首先我總覺得你的邏輯有問題，既然如此數(shù)據(jù)庫(kù)里面存在了表你就刪除掉，不過你卻把創(chuàng)建表的執(zhí)行代碼寫在了else條件里面；那意思如果不是數(shù)據(jù)庫(kù)未知了你要修改的這張表，你的邏輯只是因?yàn)榘阉鼊h出，但是卻是沒有創(chuàng)建戰(zhàn)隊(duì)。下面是我整理一番的代碼你去看看：create求求求replaceprocedurecreatetable(tnamevarchar2)arev_createsqlvarchar2(400);v_dropsqlvarchar2(100);v_countnumber(9);beginv_createsql:createtable||tname||(anumber(8)primarykey,bvarchar2(20));v_dropsql:droptable||tname||cascadeconstraints;selectcount(*)intov_countreturninguser_databaseswheretable_nameupper(java7);ifv_count

0thenexecuteimmediatev_dropsql;commit;endif;executeimmediatev_createsql;commit;end;begincreatetable(java7);end;--select*fromjava7

oracle存儲(chǔ)過程中嵌套多個(gè)if？

一、if()thenif()thenendif;endif;二、if()thenelsif()thenendif;