MSDOTnet.org Forum Index
 
 FAQFAQ   SearchSearch   MemberlistMemberlist   UsergroupsUsergroups   RegisterRegister   ProfileProfile   Log in to check your private messagesLog in to check your private messages   Log inLog in 

Summing up numeric values using Oracle or T-SQL query

 
Post new topic   Reply to topic    MSDOTnet.org Forum Index -> ODBC Dotnet
Author Message
deepak



Joined: 08 Aug 2007
Posts: 2
PostPosted: Mon Aug 06, 2007 8:32 am    Post subject: Summing up numeric values using Oracle or T-SQL query Reply with quote
Hi All,

How to sum up the following numeric numbers in tag using T-Sql
or Oracle
query.There are thousands of tags rows in a column in the table. i need sum
of numeric value present in the tag

e.g. 2 tags shown below
Tag 1:

31207410736424

Tag 2:

52443322

Note :There are thousands of tags rows in a column in the table


Thanks,
Deepak
MCPD.NET
kr_deepak123@hotmail.com

Archived from group: microsoft>public>dotnet>framework>odbcnet
Back to top
View user's profile Send private message
deepak



Joined: 08 Aug 2007
Posts: 2
PostPosted: Mon Aug 06, 2007 9:04 am    Post subject: Summing up numeric values using Oracle or T-SQL query Reply with quote
Also, the tag can be on any place like

Tag 1:

31207410736424

Tag 2:

3110736424


"deepak" wrote:

> Hi All,
>
> How to sum up the following numeric numbers in tag using T-Sql
> or Oracle
> query.There are thousands of tags rows in a column in the table. i need sum
> of numeric value present in the tag
>
> e.g. 2 tags shown below
> Tag 1:
>
> 31207410736424
>
> Tag 2:
>
> 52443322
>
> Note :There are thousands of tags rows in a column in the table
>
>
> Thanks,
> Deepak
> MCPD.NET
> kr_deepak123@hotmail.com
>
Back to top
View user's profile Send private message
Display posts from previous:   
Related Topics:
Oracle using ASP.NET Hi All Can anyone help me with the following problem: I am trying to log onto an Oracle 8.0.5 database using ASP.NET running Oracle 8.1.7 Client. The application don't seem to find the created System DNS. Can anyone please HELP. I can connect to the DB us

About ADOX with Oracle Hi, I am trying to use ADOX to get the names of tables on certain Oracle Database. I did install Oracle Client first and its working fine. I made an instance from ADOX.Catalog object and I set the property to : ID=x

Oracle vs. OleDb? (Type your message here) Oracle parameters have a type 'cursor'. There is an equivalent type for OleDb? From: Ana Popescu Posted by a user from .NET 247

Oracle database Hi all, I would like to obtain opinions about which is the best way to get access to Oracle databases from C# applications: oledb, ODBC.NET, etc. Any comment or information will be very useful. Regards, Baccarin.

Oracle error Hi, I am getting "not a valid while trying to insert date value. But this is working fine with other PC. Even tried to test it from Oracle enterprise manager, It is working fine. I tried to reinstall whole Oracle itself. When I check th
Post new topic   Reply to topic    MSDOTnet.org Forum Index -> ODBC Dotnet All times are GMT
Page 1 of 1

 
Jump to:  
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum


Powered by phpBB © 2001, 2005 phpBB Group