Hi. Im using cat to output the contents of a file, then piping it to my while read loop.In this loop variables get assigned values. However when i try to use the variables outside the loop their values has been reset.I understand about subshells etc. but I have no idea how to "preserve" the... (3 Replies)
Hi,
I did not understand why the following did not work out as I expected:
find . -name "pqp.txt" | grep -v "Permission"
I thought I would be able to catch whichever paths containing my pqp.txt file without receiving the display of messages such as "find: cannot access... Permisson... (1 Reply)
Hi,
I was wondering why ls * | echo does not print the contents of the directory to the screen? The way I see it, ls * returns a whole lot of information, and then we pipe all this info to echo, so surely it should all come to our screen!
Is there a serious flaw in my understanding?
... (3 Replies)
Not sure why this does not work in bash:
tail -f err.log |&
-bash: syntax error near unexpected token `&'
I am attempting to continuously read a file that is being updated by doing a "tail -f" on the file and piping the output to stdin which can then be read by the next shell command
Thnx (4 Replies)
Hi.
I have a script like so:
#!/bin/bash
download='php /var/www/last.php'
echo $download
if $downloadHow do I pipe the output of the php file into a variable, as when i run the if statement, it just echos the file output to the screen and does not actually consider the output (it will be... (2 Replies)
Hi All,
I am trying to convert the below Csh code into Perl.
But i have the following error.
Can any expert help ?
Error:
ls: *tac: No such file or directory
Csh
set $ST_file = `ls -rt *$testid*st*|tail -1`;
Perl
my $ST_file = `ls -rt *$testid*st*|tail -1`; (10 Replies)
I would like to pipe "top -n" to a text file, but I get an error:
top: cannot open /dev/kmem
kvm_open: Permission denied
I am a non-root user.
If I could find a way to get this type of output:
"Memory: 2048M real, 1516M free, 4099M swap free"
into a text file, I could further automate... (13 Replies)
Ok, so there is a perl script that runs as a server, on my local host. It tells me which port to use. I want to pipe that output into my browser so I can do the whole thing with a single command. The problem is, I think, that the program doesn't actually exit cause it's running a server, so...... (6 Replies)
Basically I was wondering if any of you know how to pipe the output of ls to a text file? so in my shell script one of the lines is ls but i want to pipe it into a file called directory listing.
Cheers.
I have tried ls | Directorylisting.txt
but it keeps saying " line 7: DirectoryListing.txt:... (9 Replies)
i have a file seperated each line seperated by newline. For example
alpha
beta
gamma
i am trying to replace the newlines to "," but dont want , present at the end of the line so i am trying the below one liner . but not sure whats wrong but its not working
cat myfile | tr -s '\n' ',' | sed... (9 Replies)
Discussion started by: chidori
9 Replies
LEARN ABOUT DEBIAN
dbix::searchbuilder::handle::oracle
DBIx::SearchBuilder::Handle::Oracle(3pm) User Contributed Perl Documentation DBIx::SearchBuilder::Handle::Oracle(3pm)NAME
DBIx::SearchBuilder::Handle::Oracle - An oracle specific Handle object
SYNOPSIS DESCRIPTION
This module provides a subclass of DBIx::SearchBuilder::Handle that compensates for some of the idiosyncrasies of Oracle.
METHODS
Connect PARAMHASH: Driver, Database, Host, User, Password
Takes a paramhash and connects to your DBI datasource.
BuildDSN
Customized version of "BuildDSN" in DBIx::SearchBuilder::Handle method.
Takes additional argument SID. Database argument used unless SID provided. Two forms of DSN are generated depending on whether Host
defined or not:
dbi:Oracle:sid=<SID>;host=...[;port=...]
dbi:Oracle:<SID>
Read details in documentation for DBD::Oracle module.
Insert
Takes a table name as the first argument and assumes that the rest of the arguments are an array of key-value pairs to be inserted.
InsertFromSelect
Customization of "InsertFromSelect" in DBIx::SearchBuilder::Handle.
Unlike other DBs Oracle needs:
o id generated from sequences for every new record.
o query wrapping in parens.
NOTE that on Oracle there is a limitation on the query. Every column in the result should have unique name or alias, for example the
following query would generate "ORA-00918: column ambiguously defined" error:
SELECT g.id, u.id FROM ...
Solve with aliases:
SELECT g.id AS group_id, u.id AS user_id FROM ...
KnowsBLOBs
Returns 1 if the current database supports inserts of BLOBs automatically. Returns undef if the current database must be informed of BLOBs
for inserts.
BLOBParams FIELD_NAME FIELD_TYPE
Returns a hash ref for the bind_param call to identify BLOB types used by the current database for a particular column type. The current
Oracle implementation only supports ORA_CLOB types(112).
ApplyLimits STATEMENTREF ROWS_PER_PAGE FIRST_ROW
takes an SQL SELECT statement and massages it to return ROWS_PER_PAGE starting with FIRST_ROW;
DistinctQuery STATEMENTREF
takes an incomplete SQL SELECT statement and massages it to return a DISTINCT result set.
BinarySafeBLOBs
Return undef, as Oracle doesn't support binary-safe CLOBS
DatabaseVersion
Returns value of ORA_OCI constant, see "Constants" in DBI.
SimpleDateTimeFunctions
Returns hash reference with specific date time functions of this database for "DateTimeFunction" in DBIx::SearchBuilder::Handle.
ConvertTimezoneFunction
Custom implementation of "ConvertTimezoneFunction" in DBIx::SearchBuilder::Handle.
Use the following query to get list of timezones:
SELECT tzname FROM v$timezone_names;
Read Oracle's docs about timezone files:
http://download.oracle.com/docs/cd/B14117_01/server.101/b10749/ch4datetime.htm#i1006667
AUTHOR
Jesse Vincent, jesse@fsck.com
SEE ALSO perl(1), DBIx::SearchBuilder
perl v5.14.2 2011-09-21 DBIx::SearchBuilder::Handle::Oracle(3pm)