 |
|
| Computers Forum Index » Computer - Databases - Oracle (Misc) » help on sql... |
|
Page 1 of 1 |
|
| Author |
Message |
| Raju Angani... |
 Posted: Sat Oct 10, 2009 6:41 am |
|
|
|
Guest
|
Sorry for the messup
Sample Data
=============
insert into find_fixed_open values(5,3,2,'10/01/2009');
insert into find_fixed_open values(52,38,14,'10/02/2009');
insert into find_fixed_open values(68,45,23,'10/03/2009');
insert into find_fixed_open values(112,59,53,'10/04/2009');
insert into find_fixed_open values(45,12,33,'10/05/2009');
Output should look like this
===================
'10/01/2009',5,3,2
'10/02/2009',52,38,16
'10/03/2009',68,45,39
'10/04/2009',112,59,92
'10/05/2009',45,12,125
thanks
Raju |
|
|
| Back to top |
|
|
|
| Raju Angani... |
| Posted: Sat Oct 10, 2009 6:45 am |
|
|
|
Guest
|
Michael,
You were spot on, thanks for the input.
Regards
Raju |
|
|
| Back to top |
|
|
|
| Raju Angani... |
| Posted: Sat Oct 10, 2009 7:00 am |
|
|
|
Guest
|
| I'm very sorryyyyy Michel, I got your name wrong. |
|
|
| Back to top |
|
|
|
| Frank van Bortel... |
| Posted: Wed Nov 18, 2009 8:19 pm |
|
|
|
Guest
|
RA wrote:
Quote: Hi sql gurus,
I need some help and also curious on how to write this in single sql
statement, requirements goes like this
Table structure
================
create table find_fixed_open (
find number,
fixed number,
open number,
bug_when date
);
Data
=============
insert into find_fixed_open values(5,3,2,'10/01/2009');
-------------------------------------------^^^^^^^^^^
Aaaargghhhh! That NOT a date - it's a string! I read it
as ten divided by one, divided by twothousandandnine
Promise to never, ever do that again! Typecast your
data! You should have use the to_date function here!
--
Regards,
Frank van Bortel |
|
|
| Back to top |
|
|
|
|
|
All times are GMT
The time now is Thu Dec 03, 2009 4:28 pm
|
|