Expression of String type that defines Oracle SQL hint.
It is used as an instruction for the performance optimizer of SQL
command. The value is used without the opening and
terminating characters /*+ <orahint>
*/.
The example is mentioned
here.
Table must be opened with the access _DB_MODIFY. The type of the inserted
row must be correct. Values of all items of the inserted row must be
valid and the structure type of the local variable must be equal to the
table type.
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.
0 komentárov