62,243
社区成员




string strConnectionString = "data source=ORCL;User ID=michael;Password=admin;";
OracleConnection con = new OracleConnection(strConnectionString);
OracleCommand com = new OracleCommand();
com.Connection = con;
com.CommandText = "select * from a";
con.Open();
OracleDataReader dr = com.ExecuteReader();
if (dr.Read())
Response.Write("read:"+dr[0].ToString());
select * from sys.a
select * from system.a
SQL> conn system/admin
Connected.
SQL> select * from a;
select * from a
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> select * from a;
select * from a
*
ERROR at line 1:
ORA-00942: table or view does not exist
SQL> conn system/admin as sysdba
Connected.
SQL> select * from a;
no rows selected
OracleConnection con = new OracleConnection(@"data source=ORCL;User ID=michael;Password=admin");