Hi,

I'd like to format columns and work some line editing in
svrmgrl/svrmgr30 in 7.3 and 8.0.5. on Solaris 2.5, NT and '95.  Any
attempts to use col or column error out.  Looking at set or show all
don't reveal anything.  Any tips or sources I can run with?

Thanks,
Reed

Hi Reed,

This has never been an option is svrmgrl. You should use sqlplus. One
quick note:
I have seen the ! command this work in the AIX implementation of Oracle
within svrmgrl. Then you could at least run vi, create a script file,
save it
and run it in svrmgrl

Hth,

Sybrand Bakker, Oracle DBA

postbus.vcf < 1K Download

AFAIK, all you can do in Server Manager is

SET CHARWIDTH nn

where nn is the maximum width of alpha characters to display in a
SELECT.  However, you can only have one current setting for CHARWIDTH
so all CHAR and VARCHAR2 columns will have the same max width.

As you've been told, unless you have the need for privileged commands,
use SQL*Plus.

JR

AFAIK, all you can do in Server Manager is

SET CHARWIDTH nn

where nn is the maximum width of alpha characters to display in a
SELECT.  However, you can only have one current setting for CHARWIDTH
so all CHAR and VARCHAR2 columns will have the same max width.

As you've been told, unless you have the need for privileged commands,
use SQL*Plus.

JR