Home » Other » Community Hangout » Wordpress Blog - SQL ouput formatting (Wordpress)
Wordpress Blog - SQL ouput formatting [message #627227] Sun, 09 November 2014 15:15 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
I am creating a blog to post few test cases but SQL and SQL outputs formats get messed up in the page .

This is how i want to show .

SELECT SQL_HANDLE, SQL_TEXT, PLAN_NAME, ORIGIN,
ENABLED, ACCEPTED
FROM DBA_SQL_PLAN_BASELINES
WHERE SQL_TEXT LIKE '%id=1000%';


SQL_HANDLE            SQL_TEXT                                         PLAN_NAME                     ORIGIN        ENA ACC
------------------------- -------------------------------------------------- ---------------------------------------- -------------- --- ---
SQL_a6b12c50dcd955b1 select /*+ id=1000 */ name from EMP where id=1000 SQL_PLAN_adc9ca3fdkpdjd8a279cc AUTO-CAPTURE YES NO
SQL_a6b12c50dcd955b1 select /*+ id=1000 */ name from EMP where id=1000 SQL_PLAN_adc9ca3fdkpdjea3b638c MANUAL-LOAD  YES YES




Tried <code> <pre> etc .. but that didn't help .

Any idea ?

 
Read Message
Read Message
Read Message
Read Message
Previous Topic: Oracle Docs
Next Topic: DBA's nightmares
Goto Forum:
  


Current Time: Mon Jan 27 16:37:39 CST 2020