I went to the UK OUG Conference for the first time around 12 years ago, in 2003 if I remember correctly. I enjoyed all the presentations but the two which stuck in my mind were by Jonathan Lewis and Connor McDonald.
This year I will be chairing 8 sessions there, which means I will be introducing the speaker and making sure nothing goes wrong.
Two of these sessions are on 6th December 2015, which is (more...)
I created the following UNIX shell script called loop1.ksh:
Oracle 11.1 > cat loop1.ksh
sqlplus / as sysdba << eof
grant create session to andrew
identified by reid1
echo "User created"
./loop2.ksh > loop2.log1 &
./loop2.ksh > loop2.log2 &
./loop2.ksh > loop2.log3 &
./loop2.ksh > loop2.log4 &
./loop2.ksh > loop2.log5 &
This post is based on a problem I was asked to look at recently.
A colleague was using PL/SQL Developer to compare two tables in an Oracle 11 database. He was matching the rows on a key column then checking the corresponding values from a different column and reporting them if they did not match. His query returned almost 2000 rows but they appeared to have equal, not different values. Five people looked at (more...)