<div>
Remove the 3rd line it makes no sense in this insert statement.<br />
<br />
Are you trying to merge or update existing data, or insert new rows?<br />

</div>


Remove the 3rd line it makes no sense in this insert statement.

Are you trying to merge or update existing data, or insert new rows?


<div>
ok, i want to change the scheduled ship date in PACKLIST table but only where the drawing number is <br />
FX111. Should I use ALTER or UPDATE?? Thanks so much!!
</div>


ok, i want to change the scheduled ship date in PACKLIST table but only where the drawing number is
FX111. Should I use ALTER or UPDATE?? Thanks so much!!

<div>
Use update instead.<br />
<br />

<pre><code id="code-364130">UPDATE PACKLIST SET SCHEDULED_SHIP_DATE = to_date('08/01/2009', 'mm-dd-yyyy') WHERE DRAWING = 'FX111';
</code></pre>
</div>


Use update instead.



UPDATE PACKLIST SET SCHEDULED_SHIP_DATE = to_date('08/01/2009', 'mm-dd-yyyy') WHERE DRAWING = 'FX111';


<div>
Yes, ok .... oracle db zone, got it. <br />
Thanks!!
</div>


Yes, ok .... oracle db zone, got it.
Thanks!!

<div>
<div class="content wysiwyg-content">
Error 933 says that SQL statement was not properly ended.<br />
Can you help?<br />
Thanks!<br />
Beth<br />

<pre><code id="code-364117">INSERT INTO PACKLIST (SCHEDULED_SHIP_DATE)
VALUES(to_date('08/01/2009', 'mm-dd-yyyy'))
WHERE DRAWING = 'FX111';
</code></pre>
</div>
</div>


Error 933 says that SQL statement was not properly ended.
Can you help?
Thanks!
Beth

Error 933 statement not properly ended

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.