ORACLE 判斷TALBE 存不存在SQL COMMAND

DECLARE tbl_exist PLS_INTEGER;

BEGIN
select count(*) into tbl_exist from user_tables where table_name = 'mytable';
if tbl_exist = 1 then
execute immediate 'drop table mytable';
end if;

END;
參考來源

VB.NET App.Config 使用

app.config 設定如下









VB.NET 程式碼
Imports System.Configuration
Dim CNN as String = ConfigurationManager.ConnectionStrings("CNN").ConnectionString)
Dim ROOT As String = ConfigurationManager.AppSettings("ROOT_PATH").ToString