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

17.18. Prepared positional modification operator

Lecture



  <preparable dynamic update statement: positioned> :: =
    UPDATE [<table name>]
    SET <set clause> [{<comma> <set clause>} ...]
    WHERE CURRENT OF <cursor name> 

Comment:

See previous item.

If you carefully compare the dynamic SQL tools of the Oracle V.6 DBMS and the SQL / 92 standard, you can see that Oracle practically embeds in the standard, with the exception of minor syntax differences and (more importantly) different styles of working with descriptors. It seems that approximately the same situation occurs in other DBMS that support dynamic SQL.


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