(SQL ORACLE) How to generate html output, given select statement?

Question

I'm working on oracle and taking report from database Oracle.

SELECT OPERATION, OBJECT_TYPE, CPU_COST, IO_COST FROM SYS.V_$SQL_PLAN;

I want to take a html output in oracle. I have this table in output but I want to see html formate. Is there any way to see that?

Kaushik Nayak · Accepted Answer · 2018-07-18 11:45:46Z

1

This can be done from SQL* Plus

SET MARKUP HTML ON
SELECT OPERATION, OBJECT_TYPE, CPU_COST, IO_COST FROM SYS.V_$SQL_PLAN;

Check This link for more options to format the output as desired.

answered Jul 18, 2018 at 11:45

Kaushik Nayak

32k6 gold badges36 silver badges54 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Thank you but I need in ORACLE SQL DEVELOPER.