SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

how to add 2 columns using with a data type varchar

user12059276Jul 14 2010 — edited Jul 14 2010

i have two columns in a table called COLUMN_1 and COLUMN_2
the two column's datatype are in varchar .
i need to add the two columns and i need the result set as

Column_1 Column_2 Result
1:10:20 PM 2:12:20 3.22
2:10:20 PM 1:15:50 3.26
3:10:20 PM 1:14:20 6:48
1:16:20 PM 1:15:26 2:31
1:14:20 PM 1:10:26 2:24

Locked Post

New comments cannot be posted to this locked post.

Locked on Aug 11 2010

Added on Jul 14 2010

6 comments

834 views