Export PL/SQL Query Results

1 year ago
Sophia Anderson
1 minute

In PL/SQL, you can utilize the PUT_LINE procedure from the DBMS_OUTPUT package to output query results to the console. Here is an example:

DECLARE
   -- 声明变量用于存储查询结果
   result_var VARCHAR2(100);
BEGIN
   -- 执行查询并将结果存储到变量中
   SELECT column_name INTO result_var FROM table_name WHERE condition;

   -- 输出结果到控制台
   DBMS_OUTPUT.PUT_LINE(result_var);
END;
/

Please note that in order to see the output results, you need to enable DBMS_OUTPUT before executing the PL/SQL code. You can enable DBMS_OUTPUT using the following command:

SET SERVEROUTPUT ON;

Additionally, if you want to export the query results to a file, you can use the export function provided by tools like Oracle PL/SQL Developer, or write a custom stored procedure to achieve this.

bannerAds