XPost: comp.database.oracle   
   From: kennedy-downwithspammersfamily@attbi.net   
      
   "Cherrish Vaidiyan"  wrote in message   
   news:f037d974.0312142033.1f610988@posting.google.com...   
   > "Jim Kennedy"  wrote in message   
   news:...   
   > > "Cherrish Vaidiyan"  wrote in message   
   > > news:f037d974.0312122226.251016d3@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   
      
   --- SoupGate-Win32 v1.05   
    * Origin: you cannot sedate... all the things you hate (1:229/2)