Java: Wooden Language
The program below uses the typical expressions of the so called "wooden language" which is actually talking with impressive expressions but finally say nothing. I was originally inspired from the…
Java: Connect to DB and fetch data
With the code below you can connect to an Oracle database using JDBC driver and fetch some data: (you can find the libraries needed below) import java.sql.*;import java.util.Date;import java.util.Properties;public class…
Oracle 10g: Find Sessions
How to retrieve session information: select S.LOGON_TIME ,sid, serial#, username, command, lockwait, status, osuser, sql_text, machinefrom v$session s, v$sqlarea q where s.sql_hash_value = q.hash_valueand s.sql_address = q.addressand osuser = 'zzz'and…