No question at this time
DBA Top 10
1 M. Cadot 7000
2 B. Vroman 3000
3 P. Wisse 1300
4 P. Tsongayinwe 1100
5 J. Péran 1000
6 A. Kavsek 600
7 D. Walgude 400
7 J. Schnackenberg 400
9 J. Alcroft 200
9 B. M 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48717
Total active users1324
Act. users last 24h1
Act. users last hour0
Registered user hits last week17
Registered user hits last month178
Go up

Season's greetings, Oracle-mathematical way
Next thread: Help with a SQL query
Prev thread: Exhausted Resultset

Message Score Author Date
Hello, let me wish you like each year:<pre>SET ...... Bruno Vroman Dec 31, 2022, 17:18
Same to you !!!... dattatraya walgude Jan 04, 2023, 05:06

Follow up by mail Click here


Subject: Season's greetings, Oracle-mathematical way
Author: Bruno Vroman, Belgium
Date: Dec 31, 2022, 17:18, 39 days ago
Error info: ORA-0000: normal, successful completion
Message: Hello,

let me wish you like each year:
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, ((((((((((-       659 /  30240)*x
                             +     10861 /  10080)*x
                             -     12757 /    560)*x
                             +     96851 /    360)*x
                             -   2800741 /   1440)*x
                             +  12769697 /   1440)*x
                             - 382491371 /  15120)*x
                             +  54304799 /   1260)*x
                             -    823960 /     21)*x
                             + 143360001 /  10000) 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=96726
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


Season's greetings, Oracle-mathematical way
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: Jan 04, 2023, 05:06, 36 days ago
Message: Same to you !!!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here