No question at this time
DBA Top 10
1 M. Cadot 12200
2 B. Vroman 6300
3 A. Kavsek 5600
4 J. Schnackenberg 3200
5 P. Wisse 2900
6 J. Péran 2200
7 T. Boles 600
8 Z. Hudec 400
8 G. Lambregts 400
8 N. Havard 400
8 F. Pachot 400
8 D. Dave 400
About
DBA-Village
The DBA-Village forum
Forum as RSS
as RSS feed
Site Statistics
Ever registered users48570
Total active users1387
Act. users last 24h1
Act. users last hour0
Registered user hits last week32
Registered user hits last month257
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, 15 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, 15 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, 13 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, 12 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