svrmgrl columns/editing 
Author Message
 svrmgrl columns/editing
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



Sat, 11 Aug 2001 03:00:00 GMT
 svrmgrl columns/editing

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

Quote:

> 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

  postbus.vcf
< 1K Download


Sat, 11 Aug 2001 03:00:00 GMT
 svrmgrl columns/editing
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

Quote:

>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



Sun, 12 Aug 2001 03:00:00 GMT
 svrmgrl columns/editing
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

Quote:

>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



Sun, 12 Aug 2001 03:00:00 GMT
 
 [ 4 post ] 

 Relevant Pages 

1. How define the column format in svrmgrl?

2. could not edit the column of datagrid where this column is being binded to an alias

3. Can i edit identity column ?

4. edit column values in Query Analyzer 2000

5. Edit a column using T-SQL

6. Adding, editing and removing columns in SQL Server 6.5

7. Editing Column Formula

8. How to Edit the column widths in VB6?

9. Editing columns in code in DBgrid

10. Edit Recordset Column Data

11. Shape Command: Possible to edit Child Column?

12. Rendering and Editing Boolean Columns


 
Powered by phpBB® Forum Software