No question at this time
DBA Top 10
1 M. Cadot 9900
2 B. Vroman 9200
3 A. Kavsek 7500
4 T. Boles 6250
5 J. Schnackenberg 5100
6 P. Wisse 2700
7 M. Hidayathullah ... 1500
8 T. P 1200
9 G. Lambregts 1100
9 . Lauri 1100
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48352
Total active users1553
Act. users last 24h3
Act. users last hour0
Registered user hits last week285
Registered user hits last month926
Go up

Season's greetings, Oracle-mathematical way
Next thread: Oracle Data Pump Export through Windows batch File
Prev thread: Career Path from Oracle DBA to Big Data Admin

Message Score Author Date
<pre>SELECT MAX( CASE WHEN x = 1 THEN CHR( y ) EN...... Bruno Vroman Dec 31, 2018, 13:01
Like!... Philip Wisse Jan 03, 2019, 08:42
Thank you and cool!... Jan Schnackenberg Jan 03, 2019, 11:18
Hi Guru's Thankyou very much and Wishing You ...... Raj Kumar Jan 03, 2019, 18:15

Follow up by mail Click here


Subject: Season's greetings, Oracle-mathematical way
Author: Bruno Vroman, Belgium
Date: Dec 31, 2018, 13:01, 82 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 )
"Happy what?"
FROM ( SELECT x, ((((((((((-0.021750992)*x
+1.075595258)*x
-22.74350238)*x
+268.6263933)*x
-1942.231107)*x
+8856.155688)*x
-25265.46594)*x
+43047.64306)*x
-39191.03863)*x
+14320.01019) 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: Philip Wisse, Netherlands
Date: Jan 03, 2019, 08:42, 79 days ago
Message: Like!
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: Jan Schnackenberg, Germany
Date: Jan 03, 2019, 11:18, 79 days ago
Message: Thank you and cool!
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: Raj Kumar, India
Date: Jan 03, 2019, 18:15, 79 days ago
Message: Hi Guru's


Thankyou very much and Wishing You and Your Family A Very Happy and Prosperous New Year,2019 !!


Thankyou,
RajKumar
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here