static void Main5(string[] args)
{
try
{
DBAccessController ora = new DBAccessController();
string[] connectionString = { "Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=latx24.nam.nsroot.net)(PORT=1521)))",
"Data Source=latx24.nam.nsroot.net;User Id=PRISM9;Password=PRISM9;",
"Data Source=(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=latx24.nam.nsroot.net)(PORT=1521)))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=SIT11G)));User Id=PRISM9; Password = PRISM9; " };
OracleConnection conection = new OracleConnection(connectionString[2]);
conection.Open();
//OracleCommand cmd = new OracleCommand("SELECT A.*, B.* FROM all_tab_columns A LEFT JOIN(SELECT B.* FROM all_tab_columns B) B ON B.column_name = A.column_name;", conection);
OracleCommand cmd = new OracleCommand("SELECT A.* FROM all_tab_columns A", conection);
OracleDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
}
OracleDataAdapter da = new OracleDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
WriteLine("finished");
ReadKey();
}
catch (Exception ex)
{
ForegroundColor = ConsoleColor.Red;
WriteLine(ex.Message);
}
ReadKey();
}
static void Main(string[] args)
{
//setUpVariables();
DBAccessController obj = new DBAccessController();
if (DBAccessController.dbGetOracleConnection() != null)
{
DataTable ddt = createOraCmd();
if (ddt != null)
{
createFileFromDt(ddt);
}
}
else
{
Main(null);
}
}
static DataTable createOraCmd()
{
DataTable dt = null;
try
{
WriteLine("Command Line = ");
cmd = ReadLine();
OracleCommand oraCmd = new OracleCommand(cmd, DBAccessController.dbGetOracleConnection(connection));
OracleDataAdapter da = new OracleDataAdapter(oraCmd);
da.Fill(dt);
return(dt);
}
catch
{
dt = null;
}
return(dt);
}
