I have some triggers created in oracle 8i, now i wanna to see any /all trigers. How to do this?
For example if i have xxx trigger having some script/definition, now i want to see this script. Please note that while creating these triggers spooling was not used. I need some oracle command to view the trigger definition.

Wanna to see all the dependencies of a table, all the factors.
The problem is that i have a table having a field 'others' now i want to alter its data type to CLOB. Alter table is now working, perhaps bcoz of dependencies. Neither the data type changed nor this column is being drop so that i can add fresh one with clob data type. Now i m planning to drop the table and re-create having desired structure. For this now i need to know all the dependencies to re-create them. Also if any better method for it, pl. inform.

Thanks in advance.