Re: its a basic SQL command but require help ?

"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 Received on Mon Dec 15 2003 - 05:33:39 CET