Apex: How to find out the schema name? -

i need find schema name because want delete triggers created. example following:

create or replace trigger trigger_order before insert on house_order referencing old old new new each row     when (new.order_id null) begin     select seq_order_id.nextval     :new.order_id dual; end; / 

when try drop trigger:

drop trigger trigger_order 

i following error:

ora-04080: trigger 'trigger_order' not exist 

i found out need call like

drop trigger schema_name.trigger_order 

but have no idea schema name is. how can find it?

you should use all_triggers view. there's column named table owner indicates schema.

select * all_triggers table_name = 'your_table'