sqlplus: could it be dirrected do not printout anything, beside results? Post: 302332788

10 More Discussions You Might Find Interesting

1. Red Hat

How to take printout of linux file from windows xp using putty?

Friends, I have installed Putty in my windows xp pc. I am connecting the RHEL AS 3 server using putty from my windows xp. My printer is connected to my windows xp. Now, i want to print text.txt of RHEL AS 3.0 in my windows xp printer through putty. For Example: my pc ip is 117.23.2.55...

2. SCO

How to remove date and page header from a printout

I have some HP4+ and HP5 printers printing from Unixware 7.1.4. The problem is that they print a page header with the date and page number. I can't seem to figure out how to stop this. These headers through the pagination off.

3. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Hi All, I needed to get the result of two sqlplus queris into shell variables. After days of looking for the ultimate solution to this problem.. i found this... sqlplus -s USER/PASS@DB <<EOF | awk '{if(NR==1) printf("%s ", $1); if(NR==2) printf("%s ", $1);}' | read VAR1 VAR2 set head off...

4. Shell Programming and Scripting

Help with awk printout

I want to represent the columns by whats in a txt file. So the columns.txt file contains "$2$3" and the test.txt file contains "bob tom jones jon" I have #!/bin/bash columnsVar=`cat columns.txt` echo "Columns edited: $columnsVar" awk ' {print $columnsVar }' test.txt But it prints out...

5. UNIX and Linux Applications

linux sqlplus select results writes into file twice

Hello, This is my first post and its because I could not find solution for myself I decided to ask help here. What I want to do; I want to get some data from a table 1 on server 1 and insert those datas into a table 2 on server 2. ( lets say schema names are server1 and server 2 also )....

6. Shell Programming and Scripting

iterating over results from sqlplus

hi all, i am writing a ksh script, i am logging into an oracle db via sqlplus and running a select statement but i dont know how i can store the results from the sql so i can iterate over it and do more operations over it. I dont want to write a stored procedure with a cursor since i need to...

7. Shell Programming and Scripting

Can ctag and cscope support recording search results and displaying the history results ?

Hello , When using vim, can ctag and cscope support recording search results and displaying the history results ? Once I jump to one tag, I can use :tnext to jump to next tag, but how can I display the preview search result?

8. Debian

hardware printout layout terminology

trying to find online or a book. the words to use to find 'a' or 'the ways and means' to format left margin, right margin etc from man pages to Hardware Printer. while looking to print man pages with a Hardware Printer. I have found lp. and did a man sudoers | lp -p2 to test. The...

9. Shell Programming and Scripting

Sqlplus error - sqlplus -s <login/password@dbname> : No such file or directory

i am using bash shell Whenever i declare an array, and then using sqlplus, i am getting sqlplus error and return code 127. IFS="," declare -a Arr=($Variable1); SQLPLUS=sqlplus -s "${DBUSER}"/"${DBPASS}"@"${DBASE} echo "set head off ; " > ${SQLCMD} echo "set PAGESIZE 0 ;" >> ${SQLCMD}...

10. Shell Programming and Scripting

awk --> selective printout with FNR

Hi everybody! need some awk-support. i want a line-selective printout of a file. wat i normally will do with ... awk ' FNR==8' sample.txt But now i need the data from line 8, 10 and the following data from line13 to 250 wich is not end of the file. I tried allready to combine it but without...

LEARN ABOUT DEBIAN

data::stream::bulk::dbi

Data::Stream::Bulk::DBI(3pm)				User Contributed Perl Documentation			      Data::Stream::Bulk::DBI(3pm)

NAME

       Data::Stream::Bulk::DBI - N-at-a-time iteration of DBI statement results.

VERSION

       version 0.11

SYNOPSIS

	       use Data::Stream::Bulk::DBI;

	       my $sth = $dbh->prepare("SELECT hate FROM sql"); # very big resultset
	       $sth->execute;

	       return Data::Stream::Bulk::DBI->new(
		       sth => $sth,
		       max_rows => $n, # how many at a time
		       slice => [ ... ], # if you want to pass the first param to fetchall_arrayref
	       );

DESCRIPTION

       This implementation of Data::Stream::Bulk api works with DBI statement handles, using "fetchall_arrayref" in DBI.

       It fetches "max_rows" at a time (defaults to 500).

ATTRIBUTES

       sth The statement handle to call "fetchall_arrayref" on.

       slice
	   Passed verbatim as the first param to "fetchall_arrayref". Should usually be "undef", provided for completetness.

       max_rows
	   The second param to "fetchall_arrayref". Controls the size of each buffer.

	   Defaults to 500.

METHODS

       get_more
	   See Data::Stream::Bulk::DoneFlag.

	   Calls "fetchall_arrayref" to get the next chunk of rows.

       all Calls "fetchall_arrayref" to get the raminder of the data (without specifying "max_rows").

AUTHOR

       Yuval Kogman <nothingmuch@woobling.org>

COPYRIGHT AND LICENSE

       This software is copyright (c) 2012 by Yuval Kogman.

       This is free software; you can redistribute it and/or modify it under the same terms as the Perl 5 programming language system itself.

perl v5.14.2							    2012-02-14					      Data::Stream::Bulk::DBI(3pm)

10 More Discussions You Might Find Interesting

1. Red Hat

How to take printout of linux file from windows xp using putty?

Discussion started by: sathyguy

2. SCO

How to remove date and page header from a printout

Discussion started by: sladeburke

3. UNIX for Advanced & Expert Users

Set shell variables from SQLPLUS query results

Discussion started by: pranavagarwal

4. Shell Programming and Scripting

Help with awk printout

Discussion started by: Bandit390