Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

What does 1e9 mean and why is this query not working?

Citizen_2May 12 2009 — edited May 12 2009
What does 1e9 mean? Anyone has any oracle documentation links on this? And why am i getting this error?
SQL> select segment_name,(bytes/1e9) AS size from dba_segments where segment_name='MSG_MASTER';
select segment_name,(bytes/1e9) AS size from dba_segments where segment_name='MSG_MASTER'
                                   *
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
This post has been answered by 531871 on May 12 2009
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jun 9 2009
Added on May 12 2009
6 comments
17,601 views