Re: Quick sqlplus cr/lf question


If so, try this:

select '*********************' || chr(10) ||,
'TRAINING SLICE COUNTS'|| chr(10) ||
'*********************' || chr(10)
from dual;

Thanks for that.

The chr(10) is returning a "ORA-00936: missing expression" error - I'll
research that. Might be some 'set' command in the session which enables
the use of 'chr' values or something, I dunno. I see other scripts in
my environment's 'toolkit' (which were made well before my time) that
use it, so it must be something I'm doing.

So can someone explain to me why the 'pagesize 0' has the side effect
of removing my column header definitions?

I'm much more likely to understand and remember things if they 'make
sense'. And at this point, this ain't. ;-)

.

Relevant Pages

  • Re: Explanation of macros; Haskell macros
    ... > server and I got to dictate the form of the commands and arguments. ... it boiled down to (funcall command client-session args). ... Let's assume there is a type "Session" for sessions. ... You don't need the first constraint, ...
    (comp.lang.python)
  • Re: Explanation of macros; Haskell macros
    ... > server and I got to dictate the form of the commands and arguments. ... it boiled down to (funcall command client-session args). ... Let's assume there is a type "Session" for sessions. ... You don't need the first constraint, ...
    (comp.lang.lisp)
  • Re: Newbie: save an interpretation session
    ... editing/interpretation session for next Forth interpreter startup. ... In iForth, every line of input is appended to a history file and all lines ... it on the command line. ...
    (comp.lang.forth)
  • Re: Setting default value on the fly
    ... Thanks for the suggestion. ... on a subform, but the command button is on the main form. ... >>the database a training session for a specific listed ...
    (microsoft.public.access.forms)
  • problems with WinVNC and SQL... help appreciated
    ... Laptop running WinXP and fpipe. ... fpipe is listening on 113 ... and get an active SQL session on Computer 3. ... Computer 3 and execute a batch file from the command line to do the same. ...
    (Pen-Test)