locked
How to get count in oracle? RRS feed

  • Question

  • User-1148373670 posted

    hi,

    My Query is

    string aa="Select Count(*) from table where aa==bb";

    how to get count from aa string

    pls help me

    Friday, September 23, 2011 10:05 AM

Answers

  • User269602965 posted

    normally bb would be supplied as a BIND variable

    where aa = :bb

    and you would have to feed the value and datatype of bb to Oracle Parameter collection

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 26, 2011 1:25 PM

All replies

  • User269602965 posted

    Can you explain to users in greater detail what you are trying to do?

    In your select statement 'aa' would be a COLUMN NAME

    Also Oracle does not support an '==' operator

    Friday, September 23, 2011 12:20 PM
  • User-1148373670 posted

    string oraquery="Select Count(*) from table where aa=bb";

    yes here aa is column name;

    give count when where conditionis true;

    i wrote this query in c# class.

    How to get no of count from string

    Monday, September 26, 2011 12:32 AM
  • User269602965 posted

    normally bb would be supplied as a BIND variable

    where aa = :bb

    and you would have to feed the value and datatype of bb to Oracle Parameter collection

     

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Monday, September 26, 2011 1:25 PM
  • User-1148373670 posted

    thanks

    Tuesday, September 27, 2011 1:53 AM
  • User1857199086 posted

    Hi,

    Plz Help Me!!!!!!!!!!!!!!

    I want  " export Sql Server Database into MS Access " in C#

    Is there any code you have or any link plz let me know............Its very Urgent!!!

    Tuesday, September 27, 2011 2:59 AM
  • User269602965 posted

    Use OLEDB to read MSSQL and insert into Access.

    Caution: MS Access limitations on data size and should be compressed after insertion

    Tuesday, September 27, 2011 7:30 PM