sql - how to list user tables alone in oracle -

sql - how to list user tables alone in oracle -

for below 4 query getting user defined object name well, scheme related object name need user defined object name. do?

select trigger_name user_triggers; select table_name user_tables select view_name user_views select table_name constraint_name user_constraints;

first query results this.

def$_propagator_trig repcatlogtrig trg (user defined) trig1 (user defined) trig3 (user defined)

i need lastly 3 trigger names. there way?

thanks ganesh

this should give tables created someuser

select owner , object_name , object_type all_objects owner = 'someuser' , object_type = 'table';

sql oracle