1 2 Previous Next 18 Replies Latest reply: Nov 21, 2012 10:51 AM by user515689 Go to original post RSS
      • 15. Re: Update multiple statements in a sql script
        user515689
        sb92075 wrote:
        user515689 wrote:

        SQL> 
        1  UPDATE  table1 SET  empID = 'TL80439' WHERE empID = '1605432'  
        2   /
        3  UPDATE  table1 SET  empID = 'TK83423' WHERE empID = '1614609'    
        4    /
        5  UPDATE  table1 SET  empID = 'AH73188' WHERE empID = '1632330'    
        6    /
        7  UPDATE  table1 SET  empID = 'NB50838' WHERE empID = '1725870' 
        8    /
        9  UPDATE  table1 SET  empID = 'JS16349' WHERE empID = '1729107'  
        10    /
        11  UPDATE  table1 SET  empID = 'GP34923' WHERE empID = '1730327'    
        12    /
        13  UPDATE  table1 SET  empID = 'AM01863' WHERE empID = '1733901'   
        14    /
        15  UPDATE  table1 SET  empID = 'DW23894' WHERE empID = '1742229'
        16    /
        17  UPDATE  table1 SET  empID = 'SS80141' WHERE empID = '1758128'    
        18    /
        19  UPDATE  table1 SET  empID = 'BA71847' WHERE empID = '1805539'  
        20*   /
        UPDATE  table1 SET  empID  = 'TK83223' WHERE empID  = '1614609'
        *
        ERROR at line 3:
        ORA-00936: missing expression
        Please explain how/why posted error is for "empID  = 'TK83223'" when that exact value does NOT* exist in the posted SQL code?*
        Apologies...it shouldn't have been - I accidentally copied that line afterwards, but ignore it, please.
        • 16. Re: Update multiple statements in a sql script
          sb92075
          user515689 wrote:
          sb92075 wrote:
          user515689 wrote:

          SQL> 
          1  UPDATE  table1 SET  empID = 'TL80439' WHERE empID = '1605432'  
          2   /
          3  UPDATE  table1 SET  empID = 'TK83423' WHERE empID = '1614609'    
          4    /
          5  UPDATE  table1 SET  empID = 'AH73188' WHERE empID = '1632330'    
          6    /
          7  UPDATE  table1 SET  empID = 'NB50838' WHERE empID = '1725870' 
          8    /
          9  UPDATE  table1 SET  empID = 'JS16349' WHERE empID = '1729107'  
          10    /
          11  UPDATE  table1 SET  empID = 'GP34923' WHERE empID = '1730327'    
          12    /
          13  UPDATE  table1 SET  empID = 'AM01863' WHERE empID = '1733901'   
          14    /
          15  UPDATE  table1 SET  empID = 'DW23894' WHERE empID = '1742229'
          16    /
          17  UPDATE  table1 SET  empID = 'SS80141' WHERE empID = '1758128'    
          18    /
          19  UPDATE  table1 SET  empID = 'BA71847' WHERE empID = '1805539'  
          20*   /
          UPDATE  table1 SET  empID  = 'TK83223' WHERE empID  = '1614609'
          *
          ERROR at line 3:
          ORA-00936: missing expression
          Please explain how/why posted error is for "empID  = 'TK83223'" when that exact value does NOT* exist in the posted SQL code?*
          Apologies...it shouldn't have been - I accidentally copied that line afterwards, but ignore it, please.
          so you admit is that we should not believe the content of what you post & ignore it all.
          • 17. Re: Update multiple statements in a sql script
            user515689
            Where again, is the Unhelpful button? I see the Helpful one, but not the Unhelpful one.

            Just let me know so that I may click it.

            Thanks.
            • 18. Re: Update multiple statements in a sql script
              user515689
              SomeoneElse wrote:
              The above ..this is if I open the file, "condensed.sql" and then hit Run.
              You lost me here. "Open" and "Run"?

              Are you using that ancient Windows version of SQL Plus? If you are, get rid of it. Use the command line version sqlplus.exe.

              Use the @ operator to run a file.

              SQL> @condensed.sql
              While I am on an older version of SQL Plus (SQL*Plus: Release 10.2.0.5.0 ) connectong to Ora11g (server), I did this and it worked!

              Thank YOU very much, SomeoneElse. This+* is what I needed!                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               
              1 2 Previous Next