No question at this time
DBA Top 10
1 M. Cadot 5400
2 P. Wisse 1300
3 P. Tsongayinwe 900
4 B. Vroman 500
4 J. Schnackenberg 500
6 M. Pagac 400
7 A. Deledda 200
7 D. Walgude 200
7 B. M 200
10 J. Alcroft 100
10 G. Trivedi 100
10 A. Hudspith 100
10 V. Sharma 100
10 L. Ywema 100
About
DBA-Village
Advertise here
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48741
Total active users1338
Act. users last 24h6
Act. users last hour0
Registered user hits last week145
Registered user hits last month435
Go up

Season's greetings, Oracle-mathematical way
Next thread: Tips, advice and recommandations ?
Prev thread: Oracle11g data guarad failover config

Message Score Author Date
Hello, <pre>SET HEA OFF SET COLSEP '' COL X F...... Bruno Vroman Dec 17, 2021, 16:10
Have a great Christmas Bruno ! Many thanks for ev...... Joël Péran Dec 22, 2021, 07:27
Wishing you a happy, healthy New Year. Regards ...... dattatraya walgude Dec 27, 2021, 06:41

Follow up by mail Click here

Subject: Season's greetings, Oracle-mathematical way
Author: Bruno Vroman, Belgium
Date: Dec 17, 2021, 16:10, 528 days ago
Error info: ORA-0000: normal, successful completion
Message: Hello, 

SET HEA OFF

SET COLSEP ''

COL X FOR A1

SELECT MAX( CASE WHEN x =  1 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  2 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  3 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  4 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  5 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  6 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  7 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  8 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x =  9 THEN CHR( y ) END ) x

     , MAX( CASE WHEN x = 10 THEN CHR( y ) END ) x

  FROM ( SELECT x, ((((((((((-      7909 / 362880)*x

                             +      2069 /   1920)*x

                             -    196843 /   8640)*x

                             +    774883 /   2880)*x

                             -   6722381 /   3456)*x

                             +  51083063 /   5760)*x

                             -1147564573 /  45360)*x

                             +  62067281 /   1440)*x

                             -  14126047 /    360)*x

                             +    14337 ) + 0.0001 y

           FROM ( SELECT LEVEL x

                    FROM dual

                    CONNECT BY LEVEL <= 10 )

       )

;
(feel free to reuse)

(previous years:
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=92186
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=89365
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=85625
https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=80463
...
)

Best regards,

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: Joël Péran, France
Date: Dec 22, 2021, 07:27, 524 days ago
Message: Have a great Christmas Bruno !
Many thanks for everything you have written here on this site, it always helps alot !
HNY2K22 too :)
Regards,
Joel
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: dattatraya walgude, India
Date: Dec 27, 2021, 06:41, 519 days ago
Message: Wishing you a happy, healthy New Year.

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