SQLPlus formating -without any fancy clients

Sqlplus output are a pain for end users (if too many columns), Here is a middle middle ground, without too much work and without a client, giving output with html tags. Here is quick step on formatting with html, I think we should offer, since little work for us, and gives some formatting.

1. Save the below sql as html.sql (taken from http://uhesse.com)
2. Run the users sql, it will output on screen
3. Run @html
4. HTML out put will go in myoutput.html

==

----------------------------------------
-- get the last SQL*Plus output in HTML
-- after Tanel Poder
----------------------------------------

set termout off

set markup HTML ON HEAD " -
 -
" -
BODY "" -
TABLE "border='1' align='center' summary='Script output'" -
SPOOL ON ENTMAP ON PREFORMAT OFF

spool myoutput.html

l
/

spool off
set markup html off spool off
host firefox myoutput.html
set termout on

next page

http://openelec.thestateofme.com/

Raspberry Pi

1. Pre Pi OS prep (install tool) I installed this 1st 'win32diskimager-binary.zip' 2. Install OS on Pi SD-Card Using the tool of step 1, copy the OS image to SD Card 3. Test OS Boot the machine worked fine. There is no ON button, connecting the power is ON 4. Java on Pi Installed Java, after having to regiser to download I have used: 'Java SE Embedded 6 - ARMv6/7 Linux - Headless' gunzip tar xvf The directory ejre1.6.0_34 will be created in your current directory and populated with the entire JRE release. This installation directory, /ejre1.6.0_34, will be hereafter referred to as . Add /bin to your PATH environment variable setting in order to run the Java binaries. This also worked for me on 23 Sep 2012 5. Testing of Sound To test sound, ref: http://raspberrypi.stackexchange.com/questions/44/why-is-my-audio-sound-output-not-working sudo apt-get install alsa-utils sudo modprobe snd_bcm2835 sudo aplay /usr/share/sounds/alsa/Front_Center.wav On 24 Sep 2012, this worked for my on my R.Pi

Excel notes for phone style

=IF(MID(AN54,1,2)="79",CONCATENATE("0",MID(AN54,1,2),"-",MID(AN54,3,3),"-",MID(AN54,6,10)),AN54)

Grant Materialized view

grant query rewrite to user1; grant create materialized view to user1; Make sure: SYSTEM> show parameter query NAME TYPE VALUE ------------------------------ ----------- ------------------ query_rewrite_enabled string TRUE

Zen cart About Page goes to Page not found

Zen Cart (Zencart / Zen-Cart) About Page goes to Page not found
After much searching.
Copied the whole folder from hosting site to local disk and done a diff and found following folder (location)/includes/modules/pages/about_us/ was missing on hosting.

USB bootable OS

How to create and use Live USB https://fedorahosted.org/liveusb-creator/ Took very long to fine the CenOS 5 live cd: http://vault.centos.org/5.5/isos/x86_64/ For Linux, do: yum install liveusb-creator Other option, worked for Alex: http://unetbootin.sourceforge.net/ http://unetbootin.sourceforge.net/unetbootin-windows-latest.exe