using data dictionary views in application logic
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: using data dictionary views in application logic

  1. #1
    Join Date
    Sep 2000
    Posts
    77

    using data dictionary views in application logic

    Can someone please advise if it is good pratice to query data dictionary views from application code using java. For example to query dba_tab_columns to dynamically find number of columns in a table and code some logic based upon number of columns. Thanks in advance for your time and help.
    Thanks

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    if you need that info and you cannot get it anywhere else, then sure go for it.

  3. #3
    Join Date
    Sep 2000
    Posts
    77
    Are these queries expensive? Is it better to use them in stored procedures.
    Thanks

  4. #4
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,331
    they can be expensive if overused, dba_tab_columns one of the lesser one.

    The in memory ones can cause you trouble.

    SP are better as far as I am concerned (all sql should be in them) but if you write it correctly put the code where you want it

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width