Printable View
To make a break from politicks and cricket (did you see that England thrashed the Windies again?)
To start the ball rolling (cricket ball, of course):Quote:
Originally contributed by Cookies
hell, I've seen code with UNIONs and inside
the UNION is a distinct clause! wtf?
(select distinct a from tableA)
union
(select distinct a from tableB)
Who are the Windies and what does cricket have to do with anything useful? ;) I am going to see the Pittsburgh Steelers play tonight. About that I could have a conversation. The only thing that I know about Cricket is what I learned from Douglas Adams. :pQuote:
Originally posted by DaPi
To make a break from politicks and cricket (did you see that England thrashed the Windies again?)
To start the ball rolling (cricket ball, of course):
Who are the Red Sox?Quote:
Originally posted by gandolf989
Who are the Windies . . ?
I'm going to assume that you are serious when you say who are the Red Sox. They are a Major League Baseball team in Boston. But really who are the Windies? Are they from Chicago? ;)Quote:
Originally posted by DaPi
Who are the Red Sox?
windies is a shortened name for West Indies I believe.
No slimdave I'll not be voting for Ralph Nader either. Too green for me, Bush is too red and Kerry is too yellow.
Rick
Well, you'll end up with one of them anyway. You think Kerry was more yellow than Bush? Verrrry interesting.Quote:
Originally posted by Alchemy
No slimdave I'll not be voting for Ralph Nader either. Too green for me, Bush is too red and Kerry is too yellow.
I know what your thinking.
Kerry having gone to vietnam and Georgie boy having played around in Alabama.
If Kerry were elected he would see to it that the US would follow all orders of the UN, hence yellow. Kerry is a liberals liberal. Kennedy appears to be conservative compared to Kerry.
Rick
How sad ... another Fox News victim.Quote:
Originally posted by Alchemy
If Kerry were elected he would see to it that the US would follow all orders of the UN, hence yellow. Kerry is a liberals liberal. Kennedy appears to be conservative compared to Kerry.
I do not watch Fox, nor do I litsen to Shaun Hannity or Rush Limbaugh.Quote:
How sad ... another Fox News victim
They are truely mouth pieces of republicans.
so now what Dave.....a conspiratorial nut?...lol
"Kerry would follow the orders of the UN", "Kennedy appears to be conservative compared to Kerry" -- these easily-digestible and partisan soundbites are statements from the republican mouthpieces you name.
Uhhh I thought this thread was the Dumb Code Gallery? Not the Policitcal Mud Pit???
My fault, I shouldn't have mentioned cricket :cool:
The Secret Service has announced it is doubling its protection for
John Kerry. You can understand why - with two positions on every
issue, hehas twice as many people mad at him." -
"We make jokes about it but the truth is this presidential election
really
offers us a choice of two well-informed opposing positions on every
issue.
OK, they both belong to John Kerry, but they're still there." -
"John Kerry will undergo surgery to repair his right shoulder. He
originally hurt it when he suddenly switched positions on Iraq." -
"President Bush listed his income as $822,000. You know what John
Kerry calls someone who earns $822,000? Not even worth dating." -
"Well, the good news for Democrats, now over half the country can
identify a picture of John Kerry. The bad news, the majority still thinks he's
the dad from 'The Munsters."'! -
"John Kerry accused President Bush of catering to the rich. You
know,as opposed to John Kerry who just marries them." -
"They say John Kerry is the first Democratic presidential candidate
in history to raise $50 million in a three-month period. Actually,
that's nothing. He once raised $500 million with two words: 'I
do.'"
-
I thought Obsfuscation was always a political mud pit. :DQuote:
Originally posted by OracleDoc
Uhhh I thought this thread was the Dumb Code Gallery? Not the Policitcal Mud Pit???
speaking of cricket, good to see engand win 2-1 against India - bring on the ICC trophy!
Quote:
Originally posted by gandolf989
I thought Obsfuscation was always a political mud pit. :D
Anything less would be an anti-climax. Now we have to wait for Dave to search google and find some Bush jokes that he can counter with.
Who needs to search there is so much to choose from.Quote:
Originally posted by Mr.Hanky
Anything less would be an anticlimactic. Now we have to wait for Dave to search google and find some Bush jokes that he can counter with.
:D
The man is a great experienced leader and will get re-elected, sorry Herman Munster but you were set up by Hillary.Quote:
Originally posted by gandolf989
Who needs to search there is so much to choose from.
:D
MH
1) Quit smoking weed.Quote:
Originally posted by Mr.Hanky
The man is a great experienced leader and will get re-elected, sotty Herman Munster but you were set up by Hillary.
MH
2) What does Sotty mean and how does it relate to Herman Munster? Were you watching to much TV Land while sobering up after the trouncing that Baltimore gave the NJ Giants? :D :D :D
3) What does any of this have to do with Hillary? Bush can lose on his own, thank you very much. :cool:
Yer goin down on Dec 18th!!Quote:
Originally posted by gandolf989
1) Quit smoking weed.
2) What does Sotty mean and how does it relate to Herman Munster? Were you watching to much TV Land while sobering up after the trouncing that Baltimore gave the NJ Giants? :D :D :D
3) What does any of this have to do with Hillary? Bush can lose on his own, thank you very much. :cool:
okay since there's some sports talk in this thread. a sign i saw Friday night at Fenway Park:
Pair of Green Monster Seats $90
Beer $5
Yankees lose 22-0 Priceless. :D
Are you going to go and jynx your team on? When you team start losing make sure you hit your own players with ice balls. :DQuote:
Originally posted by Mr.Hanky
Yer goin down on Dec 18th!!
At least they win when it counts!!
Red Sox fans can not talk, EVER!!
U guys SUCK!! BIG TIME
You put the uck in SUCK!!
Well you put the ewww in poo. :rolleyes:Quote:
Originally posted by Mr.Hanky
At least they win when it counts!!
Red Sox fans can not talk, EVER!!
U guys SUCK!! BIG TIME
You put the uck in SUCK!!
Dude, that was seriously weak.Quote:
Originally posted by gandolf989
Well you put the ewww in poo. :rolleyes:
That was sarcasm! i.e. You suck is not a witty retort!Quote:
Originally posted by Mr.Hanky
Dude, that was seriously weak.
In case you are still confused here is the definition.
Quote:
Webster Dictionary
Main Entry: sar·casm
Pronunciation: 'sär-"ka-z&m
Function: noun
Etymology: French or Late Latin; French sarcasme, from Late Latin sarcasmos, from Greek sarkasmos, from sarkazein to tear flesh, bite the lips in rage, sneer, from sark-, sarx flesh; probably akin to Avestan thwar&s- to cut
1 : a sharp and often satirical or ironic utterance designed to cut or give pain
2 a : a mode of satirical wit depending for its effect on bitter, caustic, and often ironic language that is usually directed against an individual b : the use or language of sarcasm
More dumb code from a popular vendor. All the columns have been with "not null" constraints, yet they check for it in a where clause over and over again. Go figure. I suppose it has to do with "database independence". :rolleyes:
PHP Code:SELECT -1, TO_CHAR (TRASH.VIS_DB_MAX_TXN_ID)
FROM
TRASH.S_DUAL UNION ALL select 3, J1.EMP_ID from TRASH.S_ASSET_EMP J1
where J1.EMP_ID is not null and J1.EMP_ID != 'No Match Row Id' and
J1.ASSET_ID = &&blah UNION ALL select 5, primary_table.INVLOC_I
D
from TRASH.S_ASSET primary_table where primary_table.INVLOC_ID is
not null and primary_table.INVLOC_ID != 'No Match Row Id' and
primary_table.ROW_ID = &&blah UNION ALL select 1,
primary_table.OWNER_ACCNT_ID from TRASH.S_ASSET primary_table where
primary_table.OWNER_ACCNT_ID is not null and
primary_table.OWNER_ACCNT_ID != 'No Match Row Id' and
primary_table.ROW_ID = &&blah UNION ALL select 2,
primary_table.PR_CON_ID from TRASH.S_ASSET primary_table where
primary_table.PR_CON_ID is not null and primary_table.PR_CON_ID != 'No
Match Row Id' and primary_table.ROW_ID = &&blah UNION ALL
select 6, T1.FN_RCMD_ID from TRASH.S_FN_RCMD_ASSET T1 where
T1.FN_RCMD_ID is not null and T1.FN_RCMD_ID != 'No Match Row Id'
and T1.ASSET_ID = &&blah UNION ALL select 7, T1.FN_NEED_ID
from TRASH.S_FN_ADRD_NEED T1 where T1.FN_NEED_ID is not null and
T1.FN_NEED_ID != 'No Match Row Id' and T1.ASSET_ID = &&blah
UNION ALL select 8, S1.ACTIVITY_ID from TRASH.S_ACT_ASSET S1 where
S1.ACTIVITY_ID is not null and S1.ACTIVITY_ID != 'No Match Row Id'
and S1.ASSET_ID = &&blah UNION ALL select 9, T1.ROW_ID from
TRASH.S_FN_ASSET_LIAB T1 where T1.ROW_ID is not null and T1.ROW_ID
!= 'No Match Row Id' and T1.ASSET_ID = &&blah UNION ALL
select 10, T1.ROW_ID from TRASH.S_SRV_REQ T1 where T1.ROW_ID is not
null and T1.ROW_ID != 'No Match Row Id' and T1.ASSET_ID = &&blah
UNION ALL select 11, T1.ROW_ID from TRASH.S_EVT_ACT T1 where
T1.ROW_ID is not null and T1.ROW_ID != 'No Match Row Id' and
T1.ASSET_ID = &&blah UNION ALL select 13, T1.ACTIVITY_ID
from TRASH.S_ACTPART_MVMT T1 where T1.ACTIVITY_ID is not null and
T1.ACTIVITY_ID != 'No Match Row Id' and T1.ASSET_ID = &&blah
UNION ALL select 14, T1.ORDER_ID from TRASH.S_ORDER_ITEM T1 where
T1.ORDER_ID is not null and T1.ORDER_ID != 'No Match Row Id' and
T1.ASSET_ID = &&blah
Oh, noble and valiant Axr2, to try thus to bring this thread back on track.
It won't last - a rash of speculation will break out as to which of Bush or Kerry the "popular vendor" supports, and isn't typical etc etc etc.
Kerry must have coded that SQL!!!
Indeed, we've had a rough ride for almost a century.
Yankees lose 22-0 Priceless. :D
On the grounds that Bush wouldn't know which way up to hold the manual?Quote:
Originally posted by Mr.Hanky
Kerry must have coded that SQL!!!
On the grounds that he couldn't spell SQLQuote:
Originally posted by DaPi
On the grounds that Bush wouldn't know which way up to hold the manual?
Anyway ... dumb SQL. I sent some code to a collegue and he wasn't sure if it was working.
However, he modified it so that it "did work". Here's a paraphrasing of the code that he says works ...
Can anyonme spot where he's going wrong? :rolleyes:Code:Select Max(col3)
From my_table1,
my_table2
Where 'MY_TABLE1.COL1' = 'MY_TABLE2.COL1'
And 'MY_TABLE1.COL2' = 'MY_TABLE2.COL2'
Which table does Max(col3) belong to? Unless it only exists in one of the tables it will cause an error. That's a very odd query though.
Actually, it's the way that the column names in the predicates are wrapped in single-quotes (thus turning them into string literals) that is the problem. Effectively he has written ...Quote:
Originally posted by gandolf989
Which table does Max(col3) belong to? Unless it only exists in one of the tables it will cause an error. That's a very odd query though.
Code:Select Max(col3)
From my_table1,
my_table2
Where 'A' = 'B'
And 'X' = 'Y'
Hmm ... and I assume the code have perfect indentation and neat and clean.Quote:
Originally posted by slimdave
Can anyonme spot where he's going wrong? :rolleyes:Code:Where 'MY_TABLE1.COL1' = 'MY_TABLE2.COL1'
And 'MY_TABLE1.COL2' = 'MY_TABLE2.COL2'
Here's what I saw ... I just replaced the table names and column names.
Perfect error trap !Code:SELECT emp_name
FROM emp
WHERE id = some_vbl
IF SQL%ROWCOUNT > 1 THEN
generate_some_error ... ;
END IF ;
Well it compiles doesn't it? :rolleyes: I should have seen that. :confused:Quote:
Originally posted by slimdave
Actually, it's the way that the column names in the predicates are wrapped in single-quotes (thus turning them into string literals) that is the problem. Effectively he has written ...
Code:Select Max(col3)
From my_table1,
my_table2
Where 'A' = 'B'
And 'X' = 'Y'
Here's the explanation from my collegue on his thought process ...
Verrrry encouraging.Quote:
I see, I get in a mode that simply says "what are the different ways this can be done" a-z than I start down the path trying things....
I see. I know this is bad. But what are the different ways of shooting ?
Perhaps he should move "read book about sql" to the top of his list of trying things. :rolleyes:Quote:
Originally posted by slimdave
Here's the explanation from my collegue on his thought process ...
Verrrry encouraging.