Home » SQL & PL/SQL » SQL & PL/SQL » Query return question
Query return question [message #236855] Fri, 11 May 2007 02:52 Go to next message
mousecriss
Messages: 1
Registered: May 2007
Location: Romania
Junior Member
Hello i got a small problem and i dont know how can i solve it..

So i make a select statement and join 2 tables and get this information:

11-AA-BB acesta este primul nostru test auto task for SITE 0 1 1
11-AA-BB acesta este primul nostru test auto task for TOOL(OSS) 0 11 1
11-AA-BB acesta este primul nostru test auto task for VAS 0 10 1
11-AA-BB acesta este primul nostru test taskul lui gigi 10 2 1
12-AA-BB testul fara domenii asoc
13-AA-AB test 45

But i would like that the information would be returned like this:

11-AA-BB acesta este primul nostru test --------------------
----------------------------------------auto task for SITE 0 1
--------------------------------------- auto task TOOL(OSS) 0 11
---------------------------------------auto task for VAS 0 10
---------------------------------------taskul lui gigi 10 2
12-AA-BB testul fara domenii asoc
13-AA-AB test 45

Meaning if the information from the first 2 rows is the same it shouldn't apear cloned in every row what can i do? "--" beeing blank spaces

Thanks a lot!

Ms frumos!
Re: Query return question [message #236862 is a reply to message #236855] Fri, 11 May 2007 03:10 Go to previous message
Michel Cadot
Messages: 64139
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
break on col1 on col2 on col3...

Regards
Michel
Previous Topic: insert using table in pl/sql
Next Topic: Doubt in alphanumeric vaidation
Goto Forum:
  


Current Time: Thu Dec 08 18:32:25 CST 2016

Total time taken to generate the page: 0.09848 seconds