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 ステートメントの送信 をご参照ください。
Conținut posibil inadecvat
Exemplele au rolul de a te ajuta să traduci cuvinte sau expresii corect si adaptat la context. Nu sunt selectate sau validate manual, așadar pot conține termeni inadecvați. Te rugăm să raportezi exemplele pe care le consideri inadecvate. Traducerile vulgare sau colocviale sunt în general marcate cu roșu sau cu portocaliu.
Înregistrează-te pentru a accesa mai multe exemple