Exemplos de System.Data.OracleClient.OracleCommand.ExecuteScalar em C# (CSharp)

Exemplo n.º 1

 private string GetDDLForTable(string tableName, string owner)
 {
     using (System.Data.OracleClient.OracleConnection conn = new System.Data.OracleClient.OracleConnection(strCon1))
     {
         System.Data.OracleClient.OracleCommand cmd = conn.CreateCommand();
         cmd.CommandText = string.Format("select SYS.DBMS_METADATA.GET_DDL('TABLE','{0}','{1}') from dual", tableName, owner);
         conn.Open();
         object result = cmd.ExecuteScalar();
         return(result.ToString());
     }
 }

Exemplo n.º 2

Arquivo: clsOracle.cs Projeto: matrica15/SISPK-PORTAL-PUBLIC

 public void InsertRecord(string SQLStatement)
 {
     if (SQLStatement.Length > 0)
     {
         if (connOracle.State.ToString().Equals("Open"))
         {
             sqlCommandOracle =
                 new System.Data.OracleClient.OracleCommand(SQLStatement, connOracle);
             sqlCommandOracle.ExecuteScalar();
         }
     }
 }

Exemplo n.º 3

 public object ExecuteScalar()
 {
     return(_cmd.ExecuteScalar());
 }