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 next 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 ?

Re: Wordpress Blog - SQL ouput formatting [message #627239 is a reply to message #627227] Mon, 10 November 2014 00:16 Go to previous messageGo to next message
Michel Cadot
Messages: 65255
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator

Quote:
This is how i want to show .


1/ Why do you want to show messed output?
2/ It is not clear what you want to display from what. Is the query part of your output?

Quote:
I am creating a blog to post few test cases


How is this an Oracle question?

Re: Wordpress Blog - SQL ouput formatting [message #627245 is a reply to message #627227] Mon, 10 November 2014 01:33 Go to previous messageGo to next message
Lalit Kumar B
Messages: 3123
Registered: May 2013
Location: World Wide on the Web
Senior Member
gkrishn wrote on Mon, 10 November 2014 02:45

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


In wordpress, you need to use :

<pre><code>
your code...
</code></pre>

The code part would look like http://lalitkumarb.wordpress.com/posts/

I have moved your topic to community hangout as the question bears no real connection with Oracle.
Re: Wordpress Blog - SQL ouput formatting [message #627246 is a reply to message #627245] Mon, 10 November 2014 01:51 Go to previous message
gkrishn
Messages: 506
Registered: December 2005
Location: Putty a dark screen
Senior Member
Great. That helped. Thank you so much.
Previous Topic: Oracle Docs
Next Topic: DBA's nightmares
Goto Forum:
  


Current Time: Sat Dec 16 00:34:53 CST 2017

Total time taken to generate the page: 0.03769 seconds