Database Administration (MOSC)

MOSC Banner

select wrapping problem or bug

edited Sep 18, 2013 11:34PM in Database Administration (MOSC) 1 commentAnswered ✓
Hello,Oracle 11.2.0.3.0 on Linux RH 6.4 x86_64.

By setting an environment Variable NLS_LANG= American_America.UTF8 , and perform  "select INSTANCE_NAME,STATUS from v$instance;"
the Layout has wrapped into 2 lines. see example below. Is it a know problem?

regards
Giorgio

SQL*Plus: Release 11.2.0.3.0 Production on Wed Sep 18 17:11:46 2013

Copyright (c) 1982, 2011, Oracle.  All rights reserved.

Enter user-name: / as sysdba

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production

SQL> set linesize 200
SQL> col PROPERTY_value for a20
SQL> col PROPERTY_NAME for a30
SQL> col DESCRIPTION for a30
SQL> select * from database_properties where property_name like '%CHARAC%' order by property_name asc;

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center