10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
Please share the doc asap as very urgently required. (1 Reply)
Discussion started by: 24ajay
2. Shell Programming and Scripting
am running the shell script below
sqlplus 'scott@orcl/tiger'<<ENDSQL >> outputlogfile.csv
SET PAGES 0
SET HEAD ON
SET ECHO OFF
SET FEEDBACK OFF
SET LINESIZE 100
SET PAGESIZE 100
SET SERVEROUTPUT ON
--# Fire the query on database
... (2 Replies)
Discussion started by: coolboy98699
3. Shell Programming and Scripting
I am accessing Unix through putty (i.e. unix is installed on other server and i am accessing it remotely through putty). I am having SQL Server 2008 installed on my computer.
Now i want to access sql server via. unix.
Could some one please help me in this!!!
Thanks (2 Replies)
Discussion started by: preetpalkapoor
If anyone is familiar with Oracle, there is a way to trace a file. Then there is is a script called tkprof that will generate a report that includes a rollup of some values. The problem with this script is that it only does the rollup properly if the query is finished. So I need something quick and... (2 Replies)
Discussion started by: guessingo
5. Shell Programming and Scripting
I used the below script to get the sql data into csv file using unix scripting.
I m getting the output into an output file but the output file is not displayed in a separe columns .
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
6. UNIX for Dummies Questions & Answers
I am new on here, I have a function in oracle that returns a specific value:
create or replace
PACKAGE BODY "CTC_ASDGET_SCHED" AS
ASDComplete... (1 Reply)
Discussion started by: reptile
7. Shell Programming and Scripting
How do I dynamically assign the below output to unix shell variables
so I can build a menu in a shell script?
var1 = 1 var2= SYSTEM
var3 = 2 var4= UNDOTBS1
and so on, then in the shell script I can use the variables to build a menu.
set serveroutput on
declare... (2 Replies)
Discussion started by: djehres
8. UNIX for Dummies Questions & Answers
I would like to access SQL plus from my unix, and learn to run some SQL scripts in Unix.
How do i begin. Is there any known website that offers a quick tutorial or tips?
unxhopeful (4 Replies)
Discussion started by: unxhopeful
9. Shell Programming and Scripting
when we are spooling query o/p to certain txt file,in that file how we can get headers in the query.(through unix shell scripting).
q1="slect * from XXXXXX;";
in the text file i want the headers of the query.....
... (1 Reply)
Discussion started by: bhagya.puccha
10. Shell Programming and Scripting
Being a newbie not sure whether iam asking the right question?
can we use oracle commands in unix for ex: to read a count on a table.
if so, what needs to be configured and etc..
any kind of help is appreciated.
sish (6 Replies)
Discussion started by: sish78