c******n
发帖数: 4965 | 1 it always gives extremely long lines, even if there is no content inside,
tried tora, but it only gives my mysql provider type, no oracle, though I
installed oracle on my box. | v*****r
发帖数: 1119 | 2 set linesize 80
用来做 text reporting tool, 没见过比 sqlplus 更 flexible,强大的。
【在 c******n 的大作中提到】
: it always gives extremely long lines, even if there is no content inside,
: tried tora, but it only gives my mysql provider type, no oracle, though I
: installed oracle on my box.
| c******n
发帖数: 4965 | 3 did that, but then u will get ugly line wrapping
it took me a lot of time to compile tora on linux, but after start up it
does not function properly... damn
now installing TOAD on windows, and it says no oracle client
【在 v*****r 的大作中提到】
: set linesize 80
: 用来做 text reporting tool, 没见过比 sqlplus 更 flexible,强大的。
| v*****r
发帖数: 1119 | 4 You need to take a look of this chapter on sqlplus formatting:
http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/
【在 c******n 的大作中提到】
: did that, but then u will get ugly line wrapping
: it took me a lot of time to compile tora on linux, but after start up it
: does not function properly... damn
: now installing TOAD on windows, and it says no oracle client
| c******n
发帖数: 4965 | 5 this is what doesn't work for me:
I do a
select * from mytable;
then there are many columns, so I need to do
set lin 200
so they do not wrap around
then when I do a describe mytable,
the result has only 2 columns, but now they are shown really far apart; what
's worse, if I set lin=20000 to disable any line wrapping, (I can do this
because I could spool the output to a file, and later read in vim, with
nowrap option), these 2 columns are displayed in a completely messed up way
【在 v*****r 的大作中提到】
: You need to take a look of this chapter on sqlplus formatting:
: http://download.oracle.com/docs/cd/B19306_01/server.102/b14357/
|
|
