I need to search our oracle database for a string in all tables and columns. I have the below query I found online but when I execute it I get the following error  Any help is appreciated  ORA-06550: line 6, column 31: PL/SQL: ORA-00904: "COLUMN_NAME": invalid identifier ORA-06550: line 6, column 12: PL/SQL: SQL Statement ignored ORA-06550: line 8, column 30: PLS-00364: loop index variable 'T' use is invalid ORA-06550: line 7, column 4: PL/SQL: Statement ignored ORA-06550: line 12, column 38: PLS-00364: loop index variable 'T' use is invalid ORA-06550: line 12, column 16: PL/SQL: Statement ignored  BEGIN     FOR t IN (SELECT table_name, column_name FROM all_tables) LOOP       EXECUTE IMMEDIATE         'SELECT COUNT(*) FROM '||t.table_name||' WHERE '||t.column_name||' = :1'         INTO match_count          USING v_search_string;            IF match_count &gt; 0 THEN                 dbms_output.put_line( t.table_name ||' '||t.column_name||' '||match_count );            END IF;    END LOOP; END; /
Is it possible to search every field of every table for a particular value in Oracle?  There are hundreds of tables with thousands of rows in some tables so I know this could take a very long time to query. But the only thing I know is that a value for the field I would like to query against is 1/22/2008P09RR8. &lt;  I've tried using this statement below to find an appropriate column based on what I think it should be named but it returned no results.  SELECT * from dba_objects  WHERE object_name like '%DTN%'   There is absolutely no documentation on this database and I have no idea where this field is being pulled from.  Any thoughts?
What are the 'types' of parametric down conversion? Is there any true inertial reference frame in the universe? Is there any true  in the universe?  Newton's first law states that an object at rest remains at rest, and an object performing uniform motion performs uniform motion, until and unless acted upon by an external force, if viewed from an inertial frame. It is the definition of an inertial frame of reference. And Newton's second law states that the net external force acting on a particle equals its mass times its acceleration. Thus we need to have an inertial frame in order for Newton's 1st and 2nd laws to be applicable.  Scientists claim that Earth is an inertial frame, either the  frame or the  frame.  Why is that? Earth's different parts have different accelerations when it performs rotational motion about its axis. Now you may say that Earth's axis is inertial, but the Earth is also revolving around the Sun. Thus Earth's frame should be non-inertial.  Even supposing that earth's frame is inertial, then it means that rest of the universe is non-inertial, because only a frame that moves with constant velocity with respect to an inertial frame is also an inertial frame and according to various scientific experiments there is no other matter in this universe which satisfies that criterion. Now you may say that earth is an approximate inertial frame, but still, my question is: is there any perfect inertial frame in the universe where Newton's laws are exactly applicable? When do I pronounce a non-existent “r” between adjacent vowel sounds? If I say two words consecutively, with the first ending in a vowel sound and the second starting with one, when is it correct to include a non-existent r between those two words?  Examples from phrases I've heard:        I saw (r)a movie   They saw (r)us   Law (r)and order   That's the idea, (r)anyway.      I heard the last one in the movie Edge of Tomorrow yesterday.  Is this grammatically correct? If so, is the omission of the r grammatically incorrect? Are there any rules regarding this? Triangular Factorials I came across a statement online and have been looking for a proof :  It states that 1, 6 and 120 are the only numbers which are both triangular and factorials.  Is there any way I can prove this? This claim looks too 'big' and I've tried to prove it but  I couldn't. Can anyone help me to prove this? Question on the correlation between two dependent variables I'm working on this question and it's stumping me.     Let $S_n = X_1 + \ldots + X_n$ (with $n&gt;=1$) be a random walk with $X_1, \ldots, X_n$ be iid RV's.   $$ E(X_k)=\mu,\,{\rm Var}(X_k)=\sigma^2.  $$   Find the covariance of $S_n$ and $S_m$   Can anyone help out? I am trying to use the equation: $${\rm Cov}[S_n, S_m] = E[S_nS_m] - E[S_n]E[S_m]$$  but can't quite figure it out. Why is $\gcd(x^4+1,x^2-1) = 1$ but I get $2$? [unit normalization of gcds] I need to find the gcd of two polynomials: $f(x) = x^4+1$ and $g(x)=x^2-1$ using the Euclidean algorithm.  Wolfram shows that the gcd is equal to $1$, but for some reason I don't get the same answer.   First I divided $f(x)$ by $g(x)$ and got that the remainder is $2$. Then, I divided $g(x)$ by the remainder, $2$, and got a remainder of zero, hence concluding that the gcd is $2$.   What am I doing wrong? Today I came across an OBVIOUSLY good answer in /review. It had 7 upvotes, contained lists, paragraphs of explanation, and well-applied sample code. It was also moderately long. How does a question like this get flagged for review? I don't really know how the algorithm works.   If this is low-quality then I feel bad about all of my answers.  Here's a  if you care to see it in context. It's not really a huge problem (as Bart's comment emphasizes), but this seems like an extreme outlier in every measurable aspect. Make a failed SSH forward a fatal error I have a script which connects to a remote host to replicate some files via SSH.  I must connect to an rsync daemon listening on port 873.  To accomplish this I have a ssh configuration like this.  Host blah     LocalForward 10873 127.0.0.1:873     Hostname 10.2.4.1   Unfortunately because of the timing of this script, there is a small chance that on occasion when it attempts to establish the SSH session another similar script will have the port open to a different host.  If I connect while another ssh session is open I get the obvious message Address already in use.  me@local:~$ ssh blah bind: Address already in use channel_setup_fwd_listener: cannot listen to port: 10873 Could not request local forwarding. Linux remote 2.6.26-2-amd64 #1 SMP Tue Jan 25 05:59:43 UTC 2011 x86_64 motd... remote:~$    What I want to have happen is to have the SSH client immediately exit with a exit code so I can put some logic into my script to report a failure instead of trying to run any commands against the port forwarded to the incorrect host. For a 2x2 matrix A satisfying $A^k=I$, compute $e^A$  Oh, the exponential of a matrix is: $e^A=\sum_{i=0}^\infty\frac{1}{i!}A^i$    I thought I'd solved the $e^A$ form but I actually did something really silly, now I'm a little stuck.  If $A^k=I$ then $A^{k+1}=A$ and we have a cycle forming, so we will get:  $$\sum^{k-1}_{i=0}\sum^{\infty}_{j=1}\frac{1}{(kj+i)!}A^i$$  (Or something like this form, I don't have paper to hand and just spotted that now)  Is this what the question wants? It doesn't use the 2x2 property.  I believe the answer lies in finding an expression for the inner summation, I can do this for two terms (think of $e+e^{-1}$ all the odd power leave) The following code  number=1 if [[ $number =~ [0-9] ]] then   echo matched fi   works. If I try to use quotes in the regex, however, it stops:  number=1 if [[ $number =~ "[0-9]" ]] then   echo matched fi   I tried "\[0-9\]", too. What am I missing?  Funnily enough,  suggests this should work.  Bash version 3.2.39. Changing Vim indentation behavior by file type Could someone explain to me in simple terms the easiest way to change the indentation behavior of Vim based on the file type? For instance, if I open a Python file it should indent with 2 spaces, but if I open a Powershell script it should use 4 spaces. I'm using terminal-ide  which is basically a terminal for android with all sorts of utilities. One is able to create bash scripts for example. Is there a way to create an icon on the home screen that will launch one of these scripts? Need a MP3 ID3 tagger, and cover fetcher I need to tag my MP3 library, and have tried kid3 (which was manual tagging), when I used Kubuntu 9.10 (I now use Ubuntu Meerkat) Here are the features I am hoping for:   A good and clean UI. Tagging should be automatic, like Winamp's autotag feature, which rocks, btw! It should also embed the cover-art in the mp3, not copy a jpeg file in the folder, because now-a-days all players support displaying cover art. But acceptable if not possible. Rename the files as per some regular expression like %TrackNo - %Artist - %Title.  Should be accurate, and more importantly smart. I want to start tagging at night, and hopefully my collection should be done by the morning, w/o it being stuck at a user prompt at 1%.   If one app cant do all, I am willing to use 3, wouldn't mind exposure to a few more apps ;)  I have used picard or someting, and I didnt like it quite a lot. But wouldn't mind using it, if there is no other alternative.   Thanks for your time! How can one prove the Bohr-Sommerfeld quantization condition $$ \oint p~dq ~=~2\pi n \hbar $$ from the WKB ansatz solution $$\Psi(x)~=~e^{iS(x)/ \hbar}$$ for the Schroedinger equation? With $S$ the action of the particle defined by Hamilton-Jacobi equation $$ \frac{\partial S}{\partial t}+ \frac{(\nabla S)^{2} }{2m}+V(x)~=~0 .$$ Sql Server 'Saving changes is not permitted' error ► Prevent saving changes that require table re-creation No more updates for Google Chrome 32-bit How to implement a single instance Java application? How to tell if a set of vectors spans a space? I want to know if the set $\{(1, 1, 1), (3, 2, 1), (1, 1, 0), (1, 0, 0)\}$ spans $\mathbb{R}^3$. I know that if it spans $\mathbb{R}^3$, then for any $x, y, z, \in \mathbb{R}$, there exist $c_1, c_2, c_3, c_4$ such that $(x, y, z) = c_1(1, 1, 1) + c_2(3, 2, 1) + c_3(1, 1, 0) + c_4(1, 0, 0)$.  I've looked around the internet, but all the answers I found involve setting up a matrix and finding the determinant, and I can't do that here because my matrix isn't square. What am I missing here? Alternatives to 'respectively' How to twist radial vector to make spirals?