We konden deze vermelding niet vinden. Er worden benaderende resultaten weergegeven. Controleer je spelling of stel voor deze term aan het woordenboek toe te voegen.
複数の SQL ステートメント
複数のSQL文
One common use for stored procedures is to automate a task that requires multiple SQL statements and is performed frequently.
If you submitted multiple SQL statements in a single request, you get the results of each individual statement by sending a request to check the status of the statement.
Multiple SQL statements can be separated by semicolon';'.
複数のSQL文をセミコロン` ; `で区切ります。
Multiple SQL statements can be separated by semicolon';'.
複数のSQL文は、セミコロン` ; `で区切ることができます。
If multiple SQL statements are combined into a single string (separated by semicolons), the length limit applies to the entire string, not to individual statements within the string.
This example is a left outer join. Rows from table A are included in the joined result even though no rows from table B match them. To create a full outer join in Oracle8i, you must use multiple SQL statements.
For example, you might need to: Define an explicit transaction Define a stored procedure Set and use session variables in statements in a request Create and use temporary tables in statements in a request Change the database, schema, warehouse, or role for statements in a request The following sections explain how to submit a request that contains multiple SQL statements.
When tuning multiple SQL statements, the SQL Tuning Advisor does not recognize interdependencies between the SQL solves SQL performance problems by identifying problems with individual SQL statements, such as a poorly performing optimizer plan or the mistaken use of certain SQL structures.
You use the SQL Tuning Advisor to tune a single or multiple SQL statements. Typically, you run this advisor in response to an ADDM performance finding that recommends its use. You can also run it periodically on the most resource-intensive SQL statements, as well as on a SQL workload.
For more information about the process of handling a response for a request that specifies multiple SQL statements, see Getting the Results for Each SQL Statement in the Request.
Oracle Query Window can process multiple SQL statements and PL/SQL anonymous blocks.
Oracle問合せウィンドウでは、複数のSQL文およびPL/SQL無名ブロックを処理できます。
See Submitting Multiple SQL Statements in a Single Request for details.
詳細については 単一リクエストによる複数の SQL ステートメントの送信 をご参照ください。
Potentieel gevoelige of ongepaste informatie
Er worden alleen voorbeelden gegeven om u te helpen het woord of de woordcombinatie waarop u hebt gezocht, te vertalen. Deze worden niet door ons geselecteerd of gevalideerd en kunnen ongepaste taal bevatten. Wij vragen u melding te maken van voorbeelden die dienen te worden aangepast of verwijderd. Vertalingen met grof of informeel taalgebruik worden meestal rood of oranje gemarkeerd.