oracle query output in excel file Post: 302311194

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shellscript.query Oracle table..populate in a text file

Hi Guys, I'm new to this forum as well as to UNIX shell scripting. I'm looking for a shellscript to query an Oracle database table and populate the result set of the query in a text file. Could you someone help me out with a sample code? Thanks, Bhagat

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the...

3. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

So, I would like to run differen select queries on multiple databases.. I made a script wich I thought to be called something like.. ./script.sh sql_file_name out.log or to enter select statement in a command line.. (aix) and I did created some shell script wich is not working.. it...

4. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Hi, I need to query Oracle database for 100 users. I have these 100 users in a file. I need a shell script which would read this User file (one user at a time) & query database. For instance: USER CITY --------- ---------- A CITY_A B CITY_B C ...

5. Shell Programming and Scripting

Problems with storing oracle sqlplus query output shell script

Hello everyone, I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected. I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't...

6. Shell Programming and Scripting

Problem in formatting output of SQL query in excel sheet in shell script

Hi Guys.. Need your help to format the output of my shell script. I am using spool command to take out put in csv file. below is my code. (for example) col USERNAME for a15 col EMAIL for a30 col FULL_NAME for a20 col LAST_LOGIN for a40 col DATE_CREATED for a40 SPOOL 120.csv...

7. UNIX for Dummies Questions & Answers

Removing unnecessary eol ($) character from Oracle sql query output

Hi All, I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each line ends with $ character. I want to remove these unnecessary $ character but to keep required $...

8. UNIX for Dummies Questions & Answers

How to extract UNIX output to excel CSV file?

Hi guys - I have a file and output like this below: File: myfile.dat File has content like this: ABCD, 34, 456, 2324 I would like excel to have this: Name (ABCD) Quantity (34), Type (456), Status (2324) (Name, Quantity, Type and Status are columns) I would like to export...

9. Shell Programming and Scripting

Script to generate Excel file or to SQL output data to Excel format/tabular format

Hi , i am generating some data by firing sql query with connecting to the database by my solaris box. The below one should be the header line of my excel ,here its coming in separate row. TO_CHAR(C. CURR_EMP_NO ---------- --------------- LST_NM...

10. UNIX for Beginners Questions & Answers

For loop output to excel file

Hi, I have a shell script which analyses the log folder for a specific string and throws me the output. I have used for loop since it does this in multiple servers. Now I want to save the output in a excel in the below format. Can someone please help? The output which I get Server1 : count...

LEARN ABOUT OSF1

faxlock

FAXLOCK(8)						      System Manager's Manual							FAXLOCK(8)

NAME

       faxlock - tell a HylaFAX server to switch to LOCKWAIT state

SYNOPSIS

       /usr/sbin/faxlock [ -q dir ] modem

DESCRIPTION

       faxlock sends a message to a HylaFAX faxgetty(8) process servicing modem telling it to change its state to LOCKWAIT

       The  specified  modem can either be the name (typically the last component of the terminal port the modem is attached to), or the full name
       of the associated FIFO named pipe file, e.g. ``FIFO.ttym2''.

OPTIONS

       -q dir	 Use a spooling area other than /var/spool/hylafax.

NOTES

       When faxgetty changes it's state to LOCKWAIT, it will start looking for the UUCP lockfile for the device, and when the device is no  longer
       locked, proceed to re-initialize the modem.

FILES

       /var/spool/hylafax		  default spooling area
       /var/spool/hylafax/FIFO		  fifo for contacting faxq

       Consult hylafax-server(5) for a complete discussion of the structure and content of the spooling area.

SEE ALSO

       hylafax-server(5), faxq(8), faxgetty(8)

								   March 3, 1995							FAXLOCK(8)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

shellscript.query Oracle table..populate in a text file

Discussion started by: bhagat.singh-j

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Discussion started by: balaeswari

3. Shell Programming and Scripting

redirecting oracle sqlplus select query into file

Discussion started by: bongo

4. Shell Programming and Scripting

Shell Script to execute Oracle query taking input from a file to form query

Discussion started by: DevendraG