mimi
mimi

Reputation: 279

how to generate report and save it to file using pl/sql oracle?

how to generate report and save it to file using pl/sql oracle?

Upvotes: 2

Views: 2729

Answers (2)

DCookie
DCookie

Reputation: 43533

DBMS_OUTPUT can be used to generate shorter reports (there is a maximum size that the generated output can be) that can be saved on the client side.

Upvotes: 1

andr
andr

Reputation: 1646

From your post it's unclear what report and from what data sources you want to generate. Concerning writing to a file from PL/SQL utl_file package can help, but bear in mind that file will be written to a server directory.

Upvotes: 4

Related Questions