A thief
-
:wtf: :wtf: :wtf: It didn't work on mine :confused: :confused: :confused:
select * from tablename where (1<2)
*
ERROR at line 1:
ORA-00942: table or view does not exist:)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
Chris Meech wrote:
It didn't work on mine
I'm not surprised. The OP's SQL was written on a blue background - yours is on a yellow background.
-
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
-
:wtf: :wtf: :wtf: It didn't work on mine :confused: :confused: :confused:
select * from tablename where (1<2)
*
ERROR at line 1:
ORA-00942: table or view does not exist:)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
even though both of you spelled "*" correctly...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001 -
He's on yang2. It must be some sort of new oriental mind expanding drug...
"Why don't you tie a kerosene-soaked rag around your ankles so the ants won't climb up and eat your candy ass..." - Dale Earnhardt, 1997
-----
"...the staggering layers of obscenity in your statement make it a work of art on so many levels." - Jason Jystad, 10/26/2001:laugh:
"The clue train passed his station without stopping." - John Simmons / outlaw programmer "Real programmers just throw a bunch of 1s and 0s at the computer to see what sticks" - Pete O'Hanlon "Not only do you continue to babble nonsense, you can't even correctly remember the nonsense you babbled just minutes ago." - Rob Graham
-
:wtf: :wtf: :wtf: It didn't work on mine :confused: :confused: :confused:
select * from tablename where (1<2)
*
ERROR at line 1:
ORA-00942: table or view does not exist:)
Chris Meech I am Canadian. [heard in a local bar] In theory there is no difference between theory and practice. In practice there is. [Yogi Berra]
:-D My
5.If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
-
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
-
:-D My
5.If the Lord God Almighty had consulted me before embarking upon the Creation, I would have recommended something simpler. -- Alfonso the Wise, 13th Century King of Castile.
This is going on my arrogant assumptions. You may have a superb reason why I'm completely wrong. -- Iain Clarke
[My articles] -
Hey, onyang2 try this: delete from tablename where(1 < 2). Cool isn’t it?
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
-
? Were you making a subtle joke that I missed? How is that different than select * from tablename?
"It's so simple to be wise. Just think of something stupid to say and then don't say it." -Sam Levenson
Sorry! corrected the query. I meant to say where 1 = 2 not 1 != 2.
-
Hey, onyang2 try this: delete from tablename where(1 < 2). Cool isn’t it?
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
I was one-voted. Obviously some idiot executed the statement upon his database.
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
-
I was one-voted. Obviously some idiot executed the statement upon his database.
The narrow specialist in the broad sense of the word is a complete idiot in the narrow sense of the word. Advertise here – minimum three posts per day are guaranteed.
-
I use this one a lot:
select * from tablename where 1 = 2
modified on Friday, February 20, 2009 12:53 PM
Actually, I've gotten into the habit of adding a
where 1=1clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts withand.select * from tablename where 1=1 and condition1 and condition2 and condition3In the above example, you can simply comment out (using--) any of thewhereclauses without worrying about trailing any leading or trailingand.The StartPage Randomizer - The Windows Cheerleader - Twitter
-
Actually, I've gotten into the habit of adding a
where 1=1clause to all my queries. It makes it really easy to comment out different clauses for testing, because every line starts withand.select * from tablename where 1=1 and condition1 and condition2 and condition3In the above example, you can simply comment out (using--) any of thewhereclauses without worrying about trailing any leading or trailingand.The StartPage Randomizer - The Windows Cheerleader - Twitter
Neat! I ought to remember this!
-
Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.
-
Speaking of hijacking threads; as I recall, a few months ago, there was a minor competition to see who could do it best.
