Visit Our UNIX and Linux User Community


How to print two sql query outputs side by side in excel


 
Thread Tools Search this Thread
Top Forums Shell Programming and Scripting How to print two sql query outputs side by side in excel
# 1  
Old 09-07-2007
How to print two sql query outputs side by side in excel

Hi,
I have to sql queries like
select sno,sname from temptable;
select deptno,dname from depttable;

In excel i want to specify the column number to which my output should be displayed.
please help me in this...
thanks in advance...
# 2  
Old 09-07-2007
could you please elaborate on the following line

i want to specify the column number to which my output

but as per the subject line , you can write a single query where these 4 columns can be accessed , as follows,

select temp.sno,
temp.sname,
dept.deptno,
dept.dname
from temptable temp ,
depttable dept
;

# 3  
Old 09-07-2007
How to print two sql query outputs side by side in excel

Hi Ranjan Thanks for your prompt reply....
i am using following script..to spool my output in to CSV.
I want to print these two queries output side by side.Is it possible??

spool /apps/ssta/dic_feedfiels/PrimarySecondaryHANDSETsales$tdate.CSV

select ' output1' from dual;

select circle_id,distributor_code,count(*) primary_stock
from table1
where item='HS'
and sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code;

select null from dual;
select null from dual;
select null from dual;
select null from dual;

select 'output2' from dual;

select circle_id,distributor_code,retailer_name,count(*)
from table2
where sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code,name;

spool off
EOF
# 4  
Old 09-07-2007
I am not sure on the below formatted one, but please try this out and let us know,

select A.* ,
B.*
from (select circle_id,distributor_code,count(*) primary_stock
from table1
where item='HS'
and sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code) A,
(select circle_id,distributor_code,retailer_name,count(*)
from table2
where sale_date between TRUNC(TRUNC(TRUNC(SYSDATE,'MONTH'),'MONTH')) and TRUNC(SYSDATE)
group by circle,code,name) B ;
# 5  
Old 09-07-2007
hi ranjan,
second query output is repeating for every row returned for first query.

instead of printing side by side can we print these two outputs in different sheets in same excel....

please help me out.....
# 6  
Old 09-07-2007
hey prasee,

just let me know what xactly u need ???
i can optimized the query in order to return the o/p(no duplicate), in single excel sheet.

but even i am not sure how you are going to export the 2 different queries o/p to a single excel sheet with different tabs ????

can u let me know, whether table1 and table2 are same????
# 7  
Old 09-08-2007
Hi ranjan,
table1 and table2 are different and we can not join those two tables.
I want to put two outputs in same excel but as output1 is very long so i want to print output2 side to it.
is there any other way to print in other sheets of excel.

Previous Thread | Next Thread
Test Your Knowledge in Computers #533
Difficulty: Easy
A Boolean is type of variable that is used to hold a truth value, either true or false.
True or False?

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

How to run 2 python scripts at the same time side by side on the same line?

Could I run 2 python scripts at the same time side by side output on the same line in this same format but with scripts? from itertools import izip_longest with open("file1") as textfile1, open("file2") as textfile2: for x, y in izip_longest(textfile1, textfile2, fillvalue=""): x =... (4 Replies)
Discussion started by: bigvito19
4 Replies

2. Shell Programming and Scripting

How to print the output side by side?

Hello, I know it is too simple but I do not know.. :/ #!/bin/bash for file in *.mp4 do echo "$file" ffmpeg -i $file 2>&1 | grep Duration |cut -d ' ' -f 4 | sed s/,// done Expected Output: NF_-_Let_You_Down-fbHbTBP_u7U.mp4 00:03:35.74 NF_-_WHY-zuJV-DAv_wE.mp4 00:03:11.87... (7 Replies)
Discussion started by: baris35
7 Replies

3. Shell Programming and Scripting

Print side by side

Dear all, How can I print any variable or string value side by side for each line within a loop? For example I have 300 zeros and I want to get an output like below lines. Each line have to be truncated at the end of the lines ( eg. 80 characters). 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0 0.0... (4 Replies)
Discussion started by: bulpak
4 Replies

4. Shell Programming and Scripting

How to print contents side by side of a file ?

Hi Team, I have input like Input file.txt Contents: Total: 939720704 bytes Total: 521142272 bytes Total: 262144 bytes Total: 786432 bytes Total: 9043968 bytes Total: 9371648 bytes I need out put like the content of file should be side by side.that is 1st line beside... (3 Replies)
Discussion started by: rocking77
3 Replies

5. Shell Programming and Scripting

AWK to merge multiple files side by side

I have about 100s of files of type text in a known directory. I want to merge all files side by side. Number of lines in all the files will remain same. For example file1 contains cat dog File 2 contains rat mat Output file should be cat rat dog mat Using awk I was able to... (5 Replies)
Discussion started by: kanthrajgowda
5 Replies

6. Shell Programming and Scripting

printing 3 files side by side based on similar values in rows

Hi I'm trying to compare 3 or more files based on similar values and outputting them into 3 columns. For example: file1 ABC DEF GHI file2 DEF DER file3 ABC DER The output should come out like this file1 file2 file3 ABC ABC (4 Replies)
Discussion started by: zerofire123
4 Replies

7. Shell Programming and Scripting

Paste two file side by side together based on specific pattern match problem

Input file_1: P78811 P40108 O17861 Q6NTW1 P40986 Q6PBK1 P38264 Q6PBK1 Q9CZ49 Q1GZI0 Input file_2: (6 Replies)
Discussion started by: patrick87
6 Replies

8. Web Development

Cannot access Apache web server from Wan side, only Lan side.

I have installed WAMPSERVER 2.0 on my windows vista x64 system but still am having issues with getting the webserver to be seen outside my local network. It is working fine within my local network. Been through several setup tutorials so far, no dice still. For testing purposes I have... (1 Reply)
Discussion started by: davidmanvell
1 Replies

9. Shell Programming and Scripting

How to Merge / combine / join / paste 2 text files side-by-side

I have 2 text files, both have one simple, single column. The 2 files might be the same length, or might not, and if not, it's unknown which one would be longer. For this example, file1 is longer: ---file1 Joe Bob Mary Sally Fred Elmer David ---file2 Tomato House Car... (3 Replies)
Discussion started by: cajunfries
3 Replies

10. Shell Programming and Scripting

Script to place selected columns from a group of files side by side in a new file

Hi Everyone, I need a shell/perl script to bring selected columns from all the files located in a directory and place them in a new file side by side. File1: a b c d 2 3 4 5 f g h i .......... File2: I II III IV w x y z .............. and so on many files are there...... (8 Replies)
Discussion started by: ks_reddy
8 Replies

Featured Tech Videos