sql - Fast way to determine if an field exist in a ORACLE table -


I'm looking for a quick SQL sentence to determine when a field exists or does not exist in a table .

In fact, I am using this sentence 

  Select 1 to Dual where exists (Select 1 from all_tab_colymes where table_name = 'mast' and 'Column_name =' MYCOLUMN '')

I think the fastest way to determine whether or not a column in Oracle is in existence should be.

UPDATE

I can not modify source code, because a large software system that makes many calls to this query; (Only I can modify the query that is stored in an external file.

The table has more than one million records of all_tab_column record

is the primary key of all_tab_columns owner, table_name, column_name therefore the search for a particular owner will be faster (or < Code> user_tab_columns .).


Comments

Post a Comment

Popular posts from this blog

Python 2.7.3 Flask ImportError: No module named -

I have a flask application with this error: importError: someone called annotated The module is not, Referer: http://ltw1413.web.cs.unibo.it/ Therefore, my root in the web server is: / home / Web / ltw1413 / html I have the HTML folder inside: One named folder "annotated" named a file .wsgi "wsgi.wsgi" My file is .wsgi: Import Sys.path.insert (0, '/ home / web / ltw1413 / html') annotatia import Application form I have "annotated" inside my folder: "Fixed" folder: stylesheet and JS "Template "Folder: Inside html" "run.py": file python where my application is run.py is: Flask Import Flask, Render_Timetal, Redirect, Import Import, Import Jason Import, Import urlib2 Import import from urlparse import Import import import from SPARQLW Rapper Import SPARQLWrapper, RDflib import JSON Graph, BNode, Literal , Urlib2 import from Time Space import name BeautifulSoup app = flask (__na...
Read more

jpa - Condition left join in CriteriaQuery -

Hi everyone I'm trying to do it in CriteriaQuery, I was searching for so long but let me do this Did not get anything, could someone help me? SELECT b.name Add a left OUTER to the apple Deplo b on (a.id_depl = b.id_depl) and b.id_place = 2; I'm just trying to make a condition in the left unbreakable clause, I looked at the ".on" function, but I do not know how it works and how it works I tried to do something like this: Join Table 1, Table 2j1 = Route. Joint (Table 1Table2, Joint Type, LEFT) .on (cb.and ( Cb.equal (table2_ someid, someId)); But it needs to create a Boolean expression. on section has been introduced in JPA 2.1. An example solution: Benchmark CB = em.getCriteriaBuilder (); CriteriaQuery & LT; String & gt; Cq = cb.createQuery (String.class); The root of the & lt; Empl & gt; A = cq.from (Empl.class); Join & LT; Empl, deplo & gt; B = A.joined ("B", JointTip; LEFT); // Left external participant B.O...
Read more