No question at this time
The DBA-Village forum
as RSS feed
Site Statistics| Ever registered users | 48742 | | Total active users | 1337 | | Act. users last 24h | 1 | | Act. users last hour | 0 | | Registered user hits last week | 108 | | Registered user hits last month | 471 |
|
Go up
Season's greetings, Oracle-mathematical way
| Subject: |
Season's greetings, Oracle-mathematical way |
| Author: |
Bruno Vroman, Belgium |
| Date: |
Dec 31, 2022, 17:18, 153 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, 150 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
|