Sponsored Content
Top Forums Shell Programming and Scripting connecting to table to extract multiple rows into file from unix script Post 302588081 by radoulov on Friday 6th of January 2012 04:08:40 PM
Old 01-06-2012
Quote:
Originally Posted by methyl
This is not the correct syntax for a comment in Oracle.
Code:
/* for sending the jobs to the file jobs123 */
spool jobs123.dat

Good catch! This will definitely cause an error.
For comments that don't span multiple lines, you could use also double dash (--).
 

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

extract multiple cloumns from multiple files; skip rows and include filenames; awk

Hello, I am trying to write a bash shell script that does the following: 1.Finds all *.txt files within my directory of interest 2. reads each of the files (25 files) one by one (tab-delimited format and have the same data format) 3. skips the first 10 rows of the file 4. extracts and... (4 Replies)
Discussion started by: manishabh
4 Replies

2. Shell Programming and Scripting

Unix command to extract a record from a table

Suppose there is a table like the following...I just wanted to know if there is any command using which we can get the record/name of the person who joined before 2005.. Sl Name des y.o.joining 1 Ram Engineer 2001 2 Hari Doctor 2004 3 David Plumber 2005 4 Rahim painter 2007 5 gurmeet... (1 Reply)
Discussion started by: satyajit007
1 Replies

3. Shell Programming and Scripting

Connecting to multiple unix server from unix server using shell script

Hi Gurus, I'm a unix newbie and I would like to connect to multiple unix servers from unix server using shell script i.e from server a to server b,c,d etc. I want to copy the files from unix server a to server b, c, d. I can access staright using ssh without the need to have password and user... (5 Replies)
Discussion started by: sexyTrojan
5 Replies

4. Shell Programming and Scripting

Shell script to extract rows from table

I have an Employee with EID, ENAME and ESTATUS as columns in SQL. I want to extract the status of an employee and update the details if the status is 'A'. Can anyone help in writing the shell script. (1 Reply)
Discussion started by: vkca
1 Replies

5. Shell Programming and Scripting

extract complex data from html table rows

I have bash, awk, and sed available on my portable device. I need to extract 10 fields from each table row from a web page that looks like this: </tr> <tr> <td>28 Apr</td> <td><a... (6 Replies)
Discussion started by: rickgtx
6 Replies

6. Shell Programming and Scripting

Connecting sqlplus from UNIX with multiple select statement

hi, i have a requirement where i need to connect sqlplus from unix and i am able to do so by following command: cust_count=`sqlplus -s $ORACLE_USER/$ORACLE_PASS@$ORACLE_SID << EOF set pagesize 0 set feedback off set verify off ... (1 Reply)
Discussion started by: lovelysethii
1 Replies

7. Shell Programming and Scripting

Retrieve multiple rows from mysql and automatically create a table

Hi, i want to create a table automatically based on another table (sms_key). For example; If user create a new row with sms_keyword field: IRC then a table created automatically (with some field on it, like: name, ph_number, messages). select * from sms_key; +-------------+ |... (1 Reply)
Discussion started by: jazzyzha
1 Replies

8. Shell Programming and Scripting

Create Multiple UNIX Files for Multiple SQL Rows output

Dear All, I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File. The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files. Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies

9. Shell Programming and Scripting

Using Isql for SQL SERVER to get the table rows counts in UNIX shell script to

need to create shell script to read the table's name from file and connect SQL SERVER using isql (odbcunix) i 'm able connect to database with below command line syntex but i could not get working in shell script with SQL and storing the row count in variable. isql -v DSN USERNAME PASSWD ... (6 Replies)
Discussion started by: pimmit22043
6 Replies

10. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one... (0 Replies)
Discussion started by: hareshvikram
0 Replies
faxq(1) 						       mgetty+sendfax manual							   faxq(1)

NAME
faxq - display fax jobs queued by faxspool(1) SYNOPSIS
faxq [<command>] [-osa] [-v] [-r] [-P<job><prio>] DESCRIPTION
Display the fax queue set up by faxspool(1). faxq looks for all the jobs queued by faxspool(1) to /var/spool/fax/outgoing/*. For each job in the queue, faxq displays some status infor- mations about it. If no options are specified, one line per queued fax job is printed, displaying the job number, sender, number of pages and target fax number. COMMANDS
faxq stop stops the fax queue processing by creating the file /var/spool/fax/outgoing/stop. This command works only if you have write access to the spool directory. Depending on local setup, this means ``root only'' or ``fax administrator group''. If you don't have write access, an error message is printed. faxq start re-starts a previously stopped fax queue, by removing the ``stop'' file. As for faxq stop this only works if you have write access. OPTIONS
-v Tells faxq to print a more verbose report for each job (multiple lines). -o Show old jobs, already sent but still in the queue directory, too. -s Show suspended jobs (stopped because of too many fatal errors during sending). You can restart those jobs with faxq -r -a Show all jobs (active, old, suspended). -r Restart suspended jobs. Every suspended job in the queue (that you have write permissions for) will be requeued. Use faxrm to delete jobs that you do not want to be sent! -P <job> <prio> Change the priority of fax job <job> to <prio>. Example: "faxq -P F000247 3". BUGS
faxq doesn't handle time scheduling yet. faxq -P is currently broken (needs re-implementing with faxq-helper). SEE ALSO
faxrunq(1), faxspool(1), faxrm(1), faxqueue(5) AUTHOR
faxq is Copyright (C) 1993 by Gert Doering, <gert@greenie.muc.de>. greenie 27 Oct 93 faxq(1)
All times are GMT -4. The time now is 03:18 PM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy