判断表是否存在
cnt1:=0;
BEGIN
SELECT 1 INTO cnt1 FROM dual WHERE exists(SELECT table_name FROM user_tables WHERE table_name = upper('sf_dkh_account_fy'));
exception
WHEN no_data_found THEN
null;
END;
cnt1:=0;
BEGIN
SELECT 1 INTO cnt1 FROM dual WHERE exists(SELECT table_name FROM user_tables WHERE table_name = upper('sf_dkh_account_fy'));
exception
WHEN no_data_found THEN
null;
END;
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8000572/viewspace-62301/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8000572/viewspace-62301/