Archive for July, 2008
Query Referential Integrity Constraints information from ORACLE db
this is how I queried Oracle DB to get information about Foreign keys.
SELECT A.CONSTRAINT_NAME,
C.TABLE_NAME PARENT_TABLE,C.COLUMN_NAME PARENT_COLUMN,
A.TABLE_NAME CHILD_TABLE,B.COLUMN_NAME CHILD_COLUMN
FROM USER_CONSTRAINTS A
INNER JOIN USER_CONS_COLUMNS B
ON A.CONSTRAINT_NAME=B.CONSTRAINT_NAME
INNER JOIN USER_CONS_COLUMNS C
ON A.R_CONSTRAINT_NAME=C.CONSTRAINT_NAME
WHERE A.CONSTRAINT_TYPE=’R’
ORDER BY C.TABLE_NAME
PowerPoint Add-in to Rename Shapes on Slides
If you are a VBA programmer, here is a very useful power point add-in from Microsoft that lets you rename the shapes
Download from here:
http://support.microsoft.com/kb/282937