Re: advanced SQL question
From: Gerard H. Pille <ghp_at_skynet.be>
Date: Fri, 17 Sep 2010 23:07:27 +0200
Message-ID: <4c93d79e$0$5283$ba620e4c_at_news.skynet.be>
Michel Cadot schreef:
> "Maxim Demenko"<mdemenko_at_gmail.com> a écrit dans le message de news: 4C913B74.1030107_at_gmail.com...
> | + length(replace(sys_connect_by_path(lpad('x',clength,'x'),'/'),'/',''))
> | as circlelength
> |
> | ;-)
> |
> | Best regards
> |
> | Maxim
>
> Indeed! I forgot the length.
>
> Regards
> Michel
>
>
Date: Fri, 17 Sep 2010 23:07:27 +0200
Message-ID: <4c93d79e$0$5283$ba620e4c_at_news.skynet.be>
Michel Cadot schreef:
> "Maxim Demenko"<mdemenko_at_gmail.com> a écrit dans le message de news: 4C913B74.1030107_at_gmail.com...
> | + length(replace(sys_connect_by_path(lpad('x',clength,'x'),'/'),'/',''))
> | as circlelength
> |
> | ;-)
> |
> | Best regards
> |
> | Maxim
>
> Indeed! I forgot the length.
>
> Regards
> Michel
>
>
The length of the circle, eh? It proves one is never too old to learn. Received on Fri Sep 17 2010 - 16:07:27 CDT