Monday, May 7, 2018

The DELETE Clause

https://plsqlquery.blogspot.com/2018/05/the-delete-clause.html

The DELETE Statement is used to remove row from table.

How to remove ASLAM'S record from EMP table? Aslam's EMPNO is 1.

SQL> DELETE EMP where EMPNO=1;

row deleted
at

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

XLA to GL Link

  https://plsqlquery.blogspot.com/2025/12/xla-to-gl-link.html SELECT             acr.cash_receipt_id,             acr.receipt_number,       ...

  • Using Outer Joins in PLSQL Query
    https://plsqlquery.blogspot.com/2018/05/using-outer-joins-in-plsql-query.html We use Outer Join when mismatched Values to be displayed    ...
  • Using TRIM in PLSQL Query
    https://plsqlquery.blogspot.com/2018/05/using-trim-in-plsql-query.html The Oracle/PLSQL TRIM function removes all specified characters eit...
  • Using Trunc Function with Numbers in PLSQL
    https://randomsrsolutions.blogspot.com/2018/05/using-trunc-function-with-numbers-in.html The TRUNC function Truncates the Column, Expressi...