Printing Title on the report [message #1978] |
Fri, 14 June 2002 06:24 |
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 |
|
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
|
|
|