Porovnávané verzie
porovnané s
Kľúč
- Tento riadok sa pridal
- Riadok je odstránený.
- Formátovanie sa zmenilo.
PG_DELETE action
Function
Deleting a row in a table.
Declaration
Blok kódu | ||||
---|---|---|---|---|
| ||||
PG_DELETE handleIdent_Int, pageNrIdent_Int, rowInPageIdent_Int, retCodeIdent_Int [ORAHINT hintIdent_Str] |
Parameters
handleIdent_Int | in | Identifier of the Int type (handle) of the connection with a table (returned by the action PG_CONNECT). |
pgNrIdent_Int_Int | in | Identifier of the Int type of the page, where the deleted row is placed in. |
rowInPageIdent_Int | in | Identifier of the Int type of the serial number of a row deleted on the given page. |
retCodeIdent_Int | out | Identifier of the Int type - action success. |
hintIdent_Str | in | Expression of the String type |
which defines Oracle SQL hint. It is used as an instruction for the performance optimizer of the SQL command. The value is used without the opening and terminating characters /*+ <orahint> */. The example is mentioned here. |
Return code
The value of the parameter transHandle_Int. See the table of error codes. It is possible to get extended error information.
Description
Table must be opened with the access _DB_MODIFY. The action will delete a row given by the serial number (the identifier
rowInPageIdent_Int
, numbering from 1 ....) from a page with the given serial number (the identifier pageNrIdent_Int
, numbering from 1 ...).For using the function on Microsoft SQL Server platform, there must be defined the primary key or at least unique index for a table from the platform. For the platform Sybase and Oracle, the function works without these limitations.
Related topics