No question at this time
DBA Top 10
1 M. Cadot 10800
2 B. Vroman 6500
3 A. Kavsek 5600
4 J. Schnackenberg 2600
5 P. Wisse 2200
5 J. Péran 2200
7 T. Boles 600
8 D. Dave 400
9 . Lauri 200
9 R. Rao Kulkarni 200
9 H. Bhangu 200
9 V. Gupta 200
9 A. Bourgeois 200
9 M. Jain 200
9 K. Pingeli 200
9 J. Baet 200
9 B. Jacobs 200
9 R. Pastre 200
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48605
Total active users1406
Act. users last 24h5
Act. users last hour0
Registered user hits last week164
Registered user hits last month694
Go up

https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446
Next thread: How to get BSN on GoldenGate 19c
Prev thread: Automatic Memory Management or not ? What is your opinion ?

Message Score Author Date
The usual way (like for example in https://www.dba...... Bruno Vroman Dec 31, 2020, 19:11
Oops, sorry, the subject should have been   Sea...... Bruno Vroman Dec 31, 2020, 19:15
Happy Vaccination Year!... Philip Wisse Jan 03, 2021, 08:27
Hi everyone Happy better year to all of you :) ...... Joël Péran Jan 03, 2021, 10:59

Follow up by mail Click here


Subject: https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446
Author: Bruno Vroman, Belgium
Date: Dec 31, 2020, 19:11, 131 days ago
Message: The usual way (like for example in https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446) has been written as a reply to Joël: see https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=95826

So here is an alternative:
CREATE OR REPLACE FUNCTION what ( p_s IN VARCHAR2 )

RETURN NUMBER
AS
l_n NUMBER;
BEGIN
SELECT SUM( ( ASCII( SUBSTR( p_s, LEVEL, 1 ) ) - ASCII( 'a' ) ) * POWER( 10, LENGTH( p_s ) - LEVEL ) )
INTO l_n
FROM dual
CONNECT BY LEVEL <= LENGTH( p_s )
;
RETURN l_n;
END what;
/

CREATE OR REPLACE FUNCTION happy( p_n IN NUMBER )
RETURN VARCHAR2
AS
l_n NUMBER := p_n;
l_s VARCHAR2( 50 CHAR );
l_c CHAR := ' ';
BEGIN
WHILE l_n > 0
LOOP
l_c := CHR( 67 - ASCII( l_c ) );
l_s := RPAD( l_c, MOD( l_n, 10 ), l_c ) || l_s;
l_n := TRUNC( l_n / 10 );
END LOOP;
RETURN l_s;
END happy;
/

SET LIN 150 PAGES 32000
WITH wishes AS
( SELECT 'dfedeffb' wish FROM dual
UNION ALL SELECT 'cbfbcbdbcbfbdc' FROM dual
UNION ALL SELECT 'ibbbfbhbcbbb' FROM dual
UNION ALL SELECT 'dfcbfbcffb' FROM dual
UNION ALL SELECT 'cbhbfbbbeagb' FROM dual
UNION ALL SELECT 'cbibdbcbbajb' FROM dual
UNION ALL SELECT 'chdddhbf' FROM dual
)
SELECT happy ( what( wish ) ) happy_what FROM wishes
;
DROP FUNCTION what;
DROP FUNCTION happy;
Best regards,

Bruno Vroman.
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446
Author: Bruno Vroman, Belgium
Date: Dec 31, 2020, 19:15, 131 days ago
Message: Oops, sorry, the subject should have been

  Season's greetings, Oracle-mathematical way

Best …

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

Subject: Re: https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446
Author: Philip Wisse, Netherlands
Date: Jan 03, 2021, 08:27, 128 days ago
Message: Happy Vaccination Year!
Your rating?: This reply is Good Excellent
Goto: Reply - Top of page 
If you think this item violates copyrights, please click here

Subject: Re: https://www.dba-village.com/village/dvp_forum.OpenThread?ThreadIdA=94446
Author: Joël Péran, France
Date: Jan 03, 2021, 10:59, 128 days ago
Message: Hi everyone

Happy better year to all of you :)
May you find all the bugs or all the solution to all problems "fingers in the nose" as we say in french ;-)
May you all be healthy and the same wish for all the people you care for and love.
I'm proud to be part of this family :)
Happy 2021 !!!

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