SQL Language (MOSC)

MOSC Banner

sql question help !!

edited Oct 18, 2012 6:33AM in SQL Language (MOSC) 10 commentsAnswered
who can tell me , how can i to avoid this sql . in my database this sql is execution 12990 times.

select ac.constraint_name key_name, acc.column_name key_col, 1
  from all_cons_columns acc, all_constraints ac
 where acc.owner = ac.owner
   and acc.constraint_name = ac.constraint_name
   and acc.table_name = ac.table_name
   and ac.constraint_type = 'P'
   and ac.owner = :OwnerName
   and ac.table_name = :TableName
 order by acc.constraint_name

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center