Sep 21 2007

Log SQL results

Catégorie : Shell, SQL, Tips and tricksCharles Collier @ 12:40 pm

If you’d like to log the result from a sql script, just prepare your sql script like that:spool result.log
SET SERVEROUTPUT ON
select * from dual;
spool off
exit

Then from a command line or a script shell execute the following command:
# sqlplus user/pwd@db_name @script.sql


Sep 06 2007

TouchGraph tool

Catégorie : NewsCharles Collier @ 1:23 pm

Of course you’be been using google for a while… but instead of reading the results, it would also be interesting to see it and see the related websites to yours or see the most relevant websites (linked to each others) dealing with a word or an expression.

For exemple, here is the result for nuxora.com :

Nuxora.com touchGraph - sept 2007

Try it: TouchGraph