You get a bonus - 1 coin for daily activity. Now you have 1 coin

17.17. Prepared Positional Delete Operator

Lecture



  <preparable dynamic delete statement: positioned> :: =
    DELETE [FROM <table name>]
    WHERE CURRENT OF <cursor name> 

Comment:

The main reason for the appearance of this and the following statements is that the combination of a cursor defined on a dynamically prepared sample operator and statically defined delete and modification operators on this cursor looks rather ridiculous. Therefore, dynamically prepared positional operators for deletion and insertion appeared in the standard. Naturally, they must be executed using the EXECUTE operator.


Comments


To leave a comment
If you have any suggestion, idea, thanks or comment, feel free to write. We really value feedback and are glad to hear your opinion.
To reply

Databases IBM System R - relational DBMS

Terms: Databases IBM System R - relational DBMS