<div>
You can't use table or view name before the 'From' clause in plsql. &nbsp;so right statement should be like this:<br />
<br />
&nbsp; 
<pre><code id="code-7982911">DELETE 
FROM STATEMENTS A, REVERSELINES T
WHERE A.ACCNO = T.ACCNO AND A.FIYID= T.FIYID AND A.PERID = T.PERID AND A.LINENO = T.LINENO</code></pre>
</div>


You can't use table or view name before the 'From' clause in plsql.  so right statement should be like this:

 

DELETE 
FROM STATEMENTS A, REVERSELINES T
WHERE A.ACCNO = T.ACCNO AND A.FIYID= T.FIYID AND A.PERID = T.PERID AND A.LINENO = T.LINENO

<div>
Hi, thank you for your help, both solutions are correct. <br />
<br />
<br />
<br />

</div>


Hi, thank you for your help, both solutions are correct.





<div>
<div class="content wysiwyg-content">
Hi, I am trying to delete records from one table upon reletion to the other <br />
somephing like this:<br />
<br />
&nbsp;
<pre><code id="code-7982899">DELETE STATEMENTS A
FROM reverselines T
WHERE A.ACCNO = T.ACCNO AND A.FIYID= T.FIYID AND A.PERID = T.PERID AND A.LINENO = T.LINENO</code></pre>
<br />
I am new to PL-SQL and I need help on that. <br />
<br />
Thank you for your help. <br />
<br />
<br />
<br />

</div>
</div>


Hi, I am trying to delete records from one table upon reletion to the other 
somephing like this:

 

I am new to PL-SQL and I need help on that. 

Thank you for your help. 





PL-SQL Delete statement

Visual Basic .NET (VB.NET) is an object-oriented programming language implemented on the .NET framework, but also supported on other platforms such as Mono and Silverlight. Microsoft launched VB.NET as the successor to the Visual Basic language. Though it is similar in syntax to  Visual Basic pre-2002, it is not the same technology,

Visual Basic.NET

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.