Home » SQL & PL/SQL » SQL & PL/SQL » pdf (merged)
pdf (merged) [message #395945] Fri, 03 April 2009 04:28 Go to next message
convey05
Messages: 43
Registered: December 2007
Location: CHENNAI
Member
Hi,
We are Using PLPDF and Query_print package to generate PDF documents.
I have a lengthy label which i have to split and print.
Eg:
Eno Ename Department
no

In this Department no is split into 2 rows.I need to do like this.
Can anyone tell me how to do this.

Thanks in advance.
Re: pdf [message #395947 is a reply to message #395945] Fri, 03 April 2009 04:40 Go to previous messageGo to next message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Use code tags, format your output and show us what you have and what you want.

Regards
Michel
Re: pdf [message #395948 is a reply to message #395945] Fri, 03 April 2009 04:52 Go to previous messageGo to next message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
If you just want to take the string 'Eno Ename Department no' and split it over two lines, the easiest way is to use SUBSTR to split it at the character position you want, and to append CHR(10) or CHR(10)||CHR(13) (depending on OS) to insert a carriage return.

If this isn't what you want, then please post more details about your problem
pdf [message #396327 is a reply to message #395945] Mon, 06 April 2009 02:31 Go to previous messageGo to next message
convey05
Messages: 43
Registered: December 2007
Location: CHENNAI
Member
Hi,
We are Using PLPDF and Query_print package to generate PDF documents.
I have a lengthy label which i have to split and print.

Eg:
Eno Ename Department
          no

In this Department no is split into 2 rows.I need to do like this.
Can anyone tell me how to do this Using Query_print package(which is downloaded from net)and plpdf package

Thanks in advance.

Re: pdf [message #396329 is a reply to message #396327] Mon, 06 April 2009 02:41 Go to previous message
Michel Cadot
Messages: 64120
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
What do you expect more repeating the same topic?
http://www.orafaq.com/forum/m/395945/102589/#msg_395945

What is query_print and pldpf packages?
If you downloaded it from Web, you should to package writters how to use them.

Regards
Michel

[Updated on: Mon, 06 April 2009 02:42]

Report message to a moderator

Previous Topic: Trigger is not working
Next Topic: Retrieve data from rows into columns
Goto Forum:
  


Current Time: Tue Dec 06 14:20:41 CST 2016

Total time taken to generate the page: 0.14664 seconds