No question at this time
DBA Top 10
1 A. Kavsek 12200
2 M. Cadot 7700
3 B. Vroman 6000
3 P. Wisse 6000
5 J. Péran 2000
6 . Lauri 1300
7 T. P 500
7 R. Pattyn 500
9 A. Chavan 300
9 D. Johnson 300
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48476
Total active users1471
Act. users last 24h2
Act. users last hour0
Registered user hits last week107
Registered user hits last month462
Go up

Season's greetings, Oracle-mathematical way
Next thread: GoldenGate Upgrade Regd!!
Prev thread: PRKC-1044 : Failed to check remote command execution setup for node rac02 using shells /usr/bin/ssh

Message Score Author Date
<pre>SELECT MAX( CASE WHEN x = 1 THEN CHR( y ) END...... Bruno Vroman Dec 31, 2019, 10:07
select 'Same to You Sir !!!' ||chr(10) ...... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts dattatraya walgude Dec 31, 2019, 10:40
Best Wishes for all of you too!... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Philip Wisse Dec 31, 2019, 12:10
Happy New Year to everyone :)... Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts Joël Péran Jan 06, 2020, 11:26

Follow up by mail Click here


Subject: Season's greetings, Oracle-mathematical way
Author: Bruno Vroman, Belgium
Date: Dec 31, 2019, 10:07, 25 days ago
Error info: ORA-0000 normal successful completion
Message:
SELECT MAX( CASE WHEN x = 1 THEN CHR( y ) END )

|| MAX( CASE WHEN x = 2 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 3 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 4 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 5 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 6 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 7 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 8 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 9 THEN CHR( y ) END )
|| MAX( CASE WHEN x = 10 THEN CHR( y ) END ) "Wishes"
FROM( SELECT x,((((((((((-293/13440)*x+43459/40320)*x-459397/20160)*x+775033/2880)*x-11205977/5760)*x+51091613/5760)*x-127527277/5040)*x+434536117/10080)*x-32965529/840)*x+14339.1) y
FROM ( SELECT LEVEL x FROM dual CONNECT BY LEVEL <= 10 ))
;
Bruno Vroman
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Season's greetings, Oracle-mathematical way
Author: dattatraya walgude, India
Date: Dec 31, 2019, 10:40, 25 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: select 'Same to You Sir !!!'
||chr(10)
||'You are Great Bruno ... ' "Wishes"
from dual;
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Season's greetings, Oracle-mathematical way
Author: Philip Wisse, Netherlands
Date: Dec 31, 2019, 12:10, 25 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Best Wishes for all of you too!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: Season's greetings, Oracle-mathematical way
Author: Joël Péran, France
Date: Jan 06, 2020, 11:26, 19 days ago
Score:   Score: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 PtsScore: 100 Pts
Message: Happy New Year to everyone :)
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here