Unix and SQL Tips

Unix Tips This week:

To get previous day in unix

`date -d yesterday +%Y%m%d`

SQL Tips This week:

To get the constraints related to a table. (Eg. Foreign keys)

set lines 100 pages 999

select    a.owner

,               a.table_name

,               a.constraint_name

from      dba_constraints a

,               dba_constraints b

where   a.constraint_type = 'R'

and        a.r_constraint_name = b.constraint_name

and        a.r_owner  = b.owner

and        b.owner = '&table_owner'

and        b.table_name = '&table_name'