10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Hi All,
I want to run multiple sql queries and store the data in variable but i want to use sql command only once. Is there a way without running sql command twice and storing.Please advise.
Eg :
Select 'Query 1 output' from dual;
Select 'Query 2 output' from dual;
I want to... (3 Replies)
Discussion started by: Rokkesh
3 Replies
2. Shell Programming and Scripting
I tried executing set of queries from shell script but not able to capture the input query in the log file,but the input query is not displayed along with output. Only the outputs are being captured in the log file. Is there a way to capture the input query along with the corresponding input?? (8 Replies)
Discussion started by: pallvi_mahajan
8 Replies
3. Shell Programming and Scripting
hey i have to connect to sql through shell script , then store the value of the query in a variable and then compare it after some time after running a process.
i have used this code but it is not working.
#!/bin/sh
Val = (sqlplus -s rte/rted2@rel76d2 <<!
SELECT MAX(STAT_ID) FROM CVT_STATS;... (3 Replies)
Discussion started by: ramsavi
3 Replies
4. UNIX for Dummies Questions & Answers
Which is the UNIX command to get the SQL Loader Help??:confused: (1 Reply)
Discussion started by: venkatesh sunil
1 Replies
5. SuSE
Is there a command that will output all mysql details. eg. host name, port etc?
Cheers
Paul (1 Reply)
Discussion started by: runnerpaul
1 Replies
6. Programming
Hi all,
I would like to display more values of different tables in one row. The issue is that I want to display more values from the same column!
exp.
Table1
id | col1
----------
1 val1
2 val2
Table2
id | col2
-----------
1 val2
2 val3
3 val4 (2 Replies)
Discussion started by: research3
2 Replies
7. UNIX for Advanced & Expert Users
Guys,
My question is on the Sybase sql query, command 'sp_help' shows me list of all the tables. but I can not view them page by page. So is there any command to view them page by page as in our unix 'ls | less'.
and one more thing command/procedure to store output into the file.
Any... (4 Replies)
Discussion started by: jagdish.machhi@
4 Replies
8. Shell Programming and Scripting
Experts,
I need small help in oracle. I am just putting this question here because i think there are SQL geniuses here as well as UNIX.
I have a string that contains the First name, Middle name and last name in one field in the table in Oracle. I need to extract each one of them... (5 Replies)
Discussion started by: dsravan
5 Replies
9. Shell Programming and Scripting
Hi,
sqlplus -s / <<EOF > /dev/null
insert into table1 (a1, a2, a3) values ('a',1,'b');
commit;
EOF
in the above code can i pass the values to the insert command from shell script like this:
insert into table1 (a1, a2, a3) values ('$a',$b,'$c');
If yes, how is it passed??
Any... (2 Replies)
Discussion started by: abey
2 Replies
10. Windows & DOS: Issues & Discussions
does somebody know where i can find command reference for mssql? i tried to search via google and it does help me that much. maybe someone can refer me a site.
thank you very much. (2 Replies)
Discussion started by: inquirer
2 Replies