One of the most useful query to look for a Column in all tables:
SELECT
TABLE_NAME,
COLUMN_NAME
FROM
ALL_TAB_COLUMNS
where
COLUMN_NAME like '%COLUMN_NAME%';
More about it on : http://en.wikipedia.org/wiki/Oracle_metadata
Subscribe to:
Post Comments (Atom)
-
LINK: http://www.techonthenet.com/oracle/functions/nvl.php Oracle/PLSQL: NVL Function In Oracle/PLSQL, the NVL function l...
-
Setting up a MPI cluster on Ubuntu involves the following steps: 1. Install OpenMPI on all machines. $sudo apt-get install libopenmpi-de...
-
Very Useful Link: http://people.cc.ku.edu/~grobe/intro-to-LSL/index.html#particle Using the Linden Script Language This page is a short...
No comments:
Post a Comment