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
1 Replies
2. UNIX for Dummies Questions & Answers
Hi
I am fetcthing the data from the oracle database using SQLPLUS. Here is my script
#!/bin/ksh
echo `sqlplus -s <<EOF
set feedback off
set linesize 5000
set pages 0
set space 0
set echo off
set trimspool on
set colsep '|'
SELECT col1 , col2... (4 Replies)
Discussion started by: max_hammer
4 Replies
3. Shell Programming and Scripting
Hi ,
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 .
#!/bin/ksh
export FILE_PATH=/maav/home/xyz/abc/
rm $FILE_PATH/sample.csv
sqlplus -s... (2 Replies)
Discussion started by: Nareshp
2 Replies
4. UNIX for Dummies Questions & Answers
Hi guys,
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
FUNCTION FN_ASDSCHEDULE_GET
RETURN VARCHAR2
AS
BEGIN
DECLARE
ASDSchedule varchar2(6);
ASDComplete... (1 Reply)
Discussion started by: reptile
1 Replies
5. 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?
Example:
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
2 Replies
6. UNIX for Dummies Questions & Answers
Hi,
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?
Thanks,
unxhopeful (4 Replies)
Discussion started by: unxhopeful
4 Replies
7. 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).
for exmple
q1="slect * from XXXXXX;";
sqlplus XXX/XXXX@XXXXX
spool XXXX.txt
$q1
spool off
in the text file i want the headers of the query.....
... (1 Reply)
Discussion started by: bhagya.puccha
1 Replies
8. Shell Programming and Scripting
Please tell me how i can use SQL in my unix scripts.
Please give examples.
I just want to start writing some scripts for my use.
Looking for ur cooperation.
thanks (2 Replies)
Discussion started by: Mohit623
2 Replies
9. Shell Programming and Scripting
Hi All,
I have a Sqlplus report which will create a file.
I need a FTP Script that will be executed inside the Sqlplus Report to FTP the report output file to unix server.
Thanks,
Previn (0 Replies)
Discussion started by: vprevin
0 Replies
10. Shell Programming and Scripting
Hi i am creating a report with file format csv using sql plus commands under unix environment. I am sending this report using mailx command to excel spread sheet. when i opened the report my columns are merged. I need to manually pull each column to see whole column results. Is there any way in... (0 Replies)
Discussion started by: raosurya
0 Replies