10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
I am pretty new to scripting and i need to create a perl or shell script which should fetch a file from local directory and insert the data into a table using sql loader. This will be later added to chron job to run daily and fetch all files and load them into
Also i... (1 Reply)
Discussion started by: sam1234
2. Shell Programming and Scripting
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
Please use code tags next time for your code and data.... (9 Replies)
Discussion started by: Sharanakumar
3. Shell Programming and Scripting
I need to write a simple shell script which will generate a .csv file/report by calling .sql file inside a shell script.
Can somebody help me on this.
Thanks in advance!
LK (7 Replies)
Discussion started by: lakshmanraok117
4. Shell Programming and Scripting
i have a Oracle table like
when i write a script for it , it gives me all the data in one column.
Please give me the solution which gives the exact result like we see in sql editors.
for a in `echo "
set feedback off;
set pagesize 40;... (1 Reply)
Discussion started by: ss135r
5. Shell Programming and Scripting
I have my log file something like this
(07/29/2009 00:02:24.467) 367518 (07/29/2009 00:02:26.214) 949384011
(07/29/2009 00:02:26.236) 367524 (07/29/2009 00:02:28.207) 949395117
(07/29/2009 00:02:28.240) 337710 (07/29/2009 00:02:30.621) 949400864
I am trying to insert the data... (3 Replies)
Discussion started by: rdhanek
6. Shell Programming and Scripting
I connected to oracle database through shell script
My requiremnt is to get more than one record from the sql query.
How can i do in unix to get multiple records. (1 Reply)
Discussion started by: vyagh
7. Shell Programming and Scripting
Hi....can you guys help me out in this script??
Below is a portion text file and it contains these:
GEF001 000093625 MKL002510 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL003604 000001 000000 000000 000000 000000 000000 000001
GEF001 000093625 MKL005675 000001... (1 Reply)
Discussion started by: pallavishetty
8. Shell Programming and Scripting
i am using '#!/bin/bash', i want to make a loop in pl/sql, this loop takes values from a table according to some conditions, each time the loop choose 3 different variables. What i am not able to do is that during the loop i want my shell script to read this 3 variables and run a shell... (1 Reply)
Discussion started by: rosalinda
9. Shell Programming and Scripting
Please let me know if anybody is having a solution handy for the below tasks...
It would be helpful if somebody can resolve my query. I am new to unix and oracle environment and looking for some online reference for completing a task.
Check if the network drive exists
Check... (0 Replies)
Discussion started by: sayydevara
10. Shell Programming and Scripting
I am a beginner. I need an example of using DB2 Load Utility in Shell script.
I appreciate if anyone could help me about it.
Paris (0 Replies)
Discussion started by: parisbeginner