Re: Space usage from dba_segments

I like ** syntax in PL/SQL, as it reminds me ^

SQL> exec dbms_output.put_line(1024**3); 1073741824

It's really pity, that Oracle SQL doesn't support **

On Thu, Dec 9, 2021 at 11:47 PM Mladen Gogala <gogala.mladen_at_gmail.com> wrote:

> On 12/9/21 14:25, Cee Pee wrote:
> > Good tip. Thanks. I have been working this long, did not know 'POWER'
> > function existed in oracle.
> >
>
> POWER function is a SQL standard function. It exists in MySQL, SQL
> Server and Postgres as well. POWER2PEOPLE is Oracle-specific.
>
> Regards
>
>
> --
> Mladen Gogala
> Database Consultant
> Tel: (347) 321-1217
> https://dbwhisperer.wordpress.com
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best regards,
Sayan Malakshinov
Oracle performance tuning engineer
Oracle ACE
http://orasql.org

--
http://www.freelists.org/webpage/oracle-l