Re: its a basic SQL command but require help ?

"Cherrish Vaidiyan" <unbreakablematrix_at_yahoo.com> wrote in message news:f037d974.0312142033.1f610988_at_posting.google.com... > "Jim Kennedy" <kennedy-downwithspammersfamily_at_attbi.net> wrote in message news:<WNCCb.38630$8y1.163387_at_attbi_s52>...
> > "Cherrish Vaidiyan" <unbreakablematrix_at_yahoo.com> wrote in message
> > news:f037d974.0312122226.251016d3_at_posting.google.com...
> > > hello googles,
> > >
> > > I have a small sqlplus problem. i have created a table with date field
> > > along with other varchar2,number etc. But unfortunately i made a
> > > mistake in entering the date. for some date records i made an error in
> > > month... say for 20 record.Now i need to correct the month.HOW????
> > >
> > > i have tried with 'update' statement using like,=,... etc.All resulted
> > > in failure.i thought of converting date datatype to character and then
> > > use the 'update'.But its not working.What shall i do now ? should i
> > > correct each and every record . Is this a drawback of Oracle????
> > >
> > > regards,
> > > Cherrish Vaidiyan
> > Keep it a date. use an update statement
> > update myTable set myfield=to_date('12/25/2003','mm/dd/yyyy') where
> > myfield=to_date('11/25/2003','mm/dd/yyyy');
> > ...
> >
> > for 20 yrows
> > commit;
> >
> >
> >
> > This is assuming that you don't want the time componet of a date. Have
you
> > looked in the manual? There are other ways of doing it, but you have
not
> > given enough information to suggest them. That is there an easy way to
> > distinguish these rtecords from other records and thus write 1 update
> > statment instead of 20. You have another pst asking what Crystal
Reports is
> > (it is a report writer), but the question is so basic that I shudder to
> > think what you could be doing connecting to a database.
> >
> > Jim

>
> Hello Jim,
>
> Thanx for ur suggestion. I couldnt understand wat extra details u need
> to suggest a single step to update the month. i tell u the full
> details now.
>
> I have a table with empno,ename,sal,hire_date etc.In the hire_date
> column i made mistake in month  ie..instead of giving as 12-Nov-03, I
> have given as 12-Sep-03. I have 20 rows with the same type of
> mistake.I want to have a single or a couple of SQL statement which
> could solve this error rather than updating each 20 rows.
>
> Hope u have got my problem. Can u help me???
>
> In my question of crystal report. I want to know What is it? Wats its
> use? Wats its advantages? where it can be applied (i mean what type of
> objects and situations) ??
>
> regards,
> Cherrish Vaidiyan

Are there only 20 rows in the whole table? If the whole table then: update theTable set
hire_date=to_date(to_char(hire_date,'dd')||'/'||(to_char(hire_date,'mm')-1)| |'/'||to_char(hire_date,'YYYY'),'dd/mm/yyyy');

got to seagate's web site and look up. Crystal reports is a report writer. If you don't know what a report writer is then you don't need one. Jim Received on Mon Dec 15 2003 - 06:11:51 CET