No question at this time
DBA Top 10
1 M. Cadot 10800
2 A. Kavsek 10100
3 B. Vroman 4800
4 P. Wisse 4200
5 J. Schnackenberg 2900
6 J. Péran 2000
7 . Lauri 1000
8 F. Pachot 500
9 Z. Hudec 400
9 G. Lambregts 400
9 N. Havard 400
9 T. Boles 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48515
Total active users1426
Act. users last 24h5
Act. users last hour0
Registered user hits last week153
Registered user hits last month718
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, 189 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, 189 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, 189 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, 183 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