[appldev@sreendba admin]$ sqlplus apps/apps
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 29 11:21:19 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select (case length(address) when 16 then '64-bit Oracle'
when 8 then '32-bit Oracle'
when 32 then '128-bit Oracle'
end) Wordsize
from v$sql
where rownum <2
/
2 3 4 5 6 7
WORDSIZE
------------------------------------------
64-bit Oracle
SQL>
SQL*Plus: Release 10.1.0.5.0 - Production on Tue Aug 29 11:21:19 2017
Copyright (c) 1982, 2005, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
SQL> select (case length(address) when 16 then '64-bit Oracle'
when 8 then '32-bit Oracle'
when 32 then '128-bit Oracle'
end) Wordsize
from v$sql
where rownum <2
/
2 3 4 5 6 7
WORDSIZE
------------------------------------------
64-bit Oracle
SQL>
No comments:
Post a Comment