its a basic SQL command but require help ?

Collapse
This topic is closed.
X
X
Collapse
 
  • Page of 1
  • Time
  • Show
Clear All
new posts
Previous template Next
  • Cherrish Vaidiyan
    #1

    its a basic SQL command but require help ?

    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
    Tags: None
    • Jim Kennedy
      #2
      Re: its a basic SQL command but require help ?


      "Cherrish Vaidiyan" <unbreakablemat rix@yahoo.comwr ote in message
      news:f037d974.0 312122226.25101 6d3@posting.goo gle.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


        Comment

        • Cherrish Vaidiyan
          #3
          Re: its a basic SQL command but require help ?

          "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message news:<WNCCb.386 30$8y1.163387@a ttbi_s52>...
          "Cherrish Vaidiyan" <unbreakablemat rix@yahoo.comwr ote in message
          news:f037d974.0 312122226.25101 6d3@posting.goo gle.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

            Comment

            • Jim Kennedy
              #4
              Re: its a basic SQL command but require help ?


              "Cherrish Vaidiyan" <unbreakablemat rix@yahoo.comwr ote in message
              news:f037d974.0 312142033.1f610 988@posting.goo gle.com...
              "Jim Kennedy" <kennedy-downwithspammer sfamily@attbi.n etwrote in message
              news:<WNCCb.386 30$8y1.163387@a ttbi_s52>...
              "Cherrish Vaidiyan" <unbreakablemat rix@yahoo.comwr ote in message
              news:f037d974.0 312122226.25101 6d3@posting.goo gle.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_da te(to_char(hire _date,'dd')||'/'||(to_char(hir e_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


                Comment

                • Sharkie
                  #5
                  Re: its a basic SQL command but require help ?

                  unbreakablematr ix@yahoo.com (Cherrish Vaidiyan) wrote in message news:<f037d974. 0312122226.2510 16d3@posting.go ogle.com>...
                  hello googles,
                  Cherrish, not everyone uses google to access the newsgroups.
                  So unless you want to address only people who use google
                  to access this group, I would be careful with this greeting.

                    Comment

                    Previous template Next
                    Working...