Home » SQL & PL/SQL » SQL & PL/SQL » Printing Title on the report
Printing Title on the report [message #1978] Fri, 14 June 2002 06:24 Go to next message
Parag dave
Messages: 8
Registered: February 2002
Junior Member
Hi,
I have a report and it has a prompt and I want that
prompt to print on my report title.

I have like:
create or repolace view view1 as
select
.....
, ......
, .....
from
table xxx
where
name = '&&1'
/

I put &&1 as BONN J

in my ttitle, I have
ttitle
center &&1

My report runs fine and output looks good too
but in the title it prints BONNJ insted of BONN J.
It missed the space between N and J.
Any solution to correct this?
I appreciate
Thanks.
Re: Printing Title on the report [message #1980 is a reply to message #1978] Fri, 14 June 2002 08:09 Go to previous message
Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
give the title with quotes.
SQL> ttitle 'Bonn j'
SQL> select * from emp;

Sat Jun 08                                                                                 page    1
                                               Bonn j

     EMPNO ENAME      JOB              MGR HIREDATE         SAL       COMM     DEPTNO
---------- ---------- --------- ---------- --------- ---------- ---------- ----------
      7369 SMITH      CLERK           7902 17-DEC-80        800                    20
      7499 ALLEN      SALESMAN        7698 20-FEB-81       1600        300         30
      7521 WARD       SALESMAN        7698 22-FEB-81       1250        500         30
Previous Topic: sqlloader rows successfully loaded (urgent)
Next Topic: Can you format a date in milliseconds?
Goto Forum:
  


Current Time: Thu Mar 28 23:56:23 CDT 2024