this is a little more complex than that. I have a text file and I need to find all the distinct words that appear in a line after the word TABLESPACE
when I grep for just the word tablespace, I get:
how do i parse this a little better so i have a smaller file to read?
This is just an... (4 Replies)
I am a beginner to scripting, please help me in this regard.
How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (1 Reply)
I am a beginner to scripting, please help me in this regard.
How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (2 Replies)
Hello ,
Can anyone help me with my below query
I am trying to find a text in directory of files via below command
grep -i cmps_cgs_crs_rfnc_id *
But it returns multiple times same file name i.e if the text found in a file 4 times the file name shown 4 times in the o/p
Is... (1 Reply)
Hello,
I have a file which looks like:
%_SPE_RDP_NUM_ECH(7)*************%
%_SPE_RDP_NUM_ECH(70)************%
%_SPE_RDP_NUM_ECH(71)************%
%_SPE_RDP_NUM_ECH(72)************%
%_SPE_RDP_NUM_ECH(8)*************%
%_SPE_RDP_NUM_ECH(9)*************%
%_SPE_FLUXPREV_PRES1_MT_HT(2)****%... (5 Replies)
From the below ps output , I want the distinct values of the third field (ie. I need the distinct PPIDs)
$ ps -ef
UID PID PPID C STIME TTY TIME CMD
root 1 0 0 Nov 10 - 48:49 /etc/init
root 1769576 1 0 Nov 10 - 0:07... (1 Reply)
Hi,
I have two files of the following format
file1
chr1:345-456
chr2:123-456
chr2:455-678
chr3:456-789
chr3:444-555
file2
chr1:345-456
chr2:123-456
chr3:456-789
output (2 Replies)
Red Hat Enterprise Linux 5.4
I have a text file (error log file) , which has occurences of an error message like
ORA-01652: unable to extend temp segment by 8 in tablespace xxxxxThere are around 3000 error messages like this in the error log file. But there are only 7 or 8 distinct... (3 Replies)
Discussion started by: John K
3 Replies
LEARN ABOUT DEBIAN
class::dbi::test::sqlite
Class::DBI::Test::SQLite(3pm) User Contributed Perl Documentation Class::DBI::Test::SQLite(3pm)NAME
Class::DBI::Test::SQLite - Base class for Class::DBI tests
SYNOPSIS
use base 'Class::DBI::Test::SQLite';
__PACKAGE__->set_table('test');
__PACKAGE__->columns(All => qw/id name film salary/);
sub create_sql {
return q{
id INTEGER PRIMARY KEY,
name CHAR(40),
film VARCHAR(255),
salary INT
}
}
DESCRIPTION
This provides a simple base class for Class::DBI tests using SQLite. Each class for the test should inherit from this, provide a
create_sql() method which returns a string representing the SQL used to create the table for the class, and then call set_table() to create
the table, and tie it to the class.
METHODS
set_table
__PACKAGE__->set_table('test');
This combines creating the table with the normal Class::DBI table() call.
create_sql (abstract)
sub create_sql {
return q{
id INTEGER PRIMARY KEY,
name CHAR(40),
film VARCHAR(255),
salary INT
}
}
This should return, as a text string, the schema for the table represented by this class.
perl v5.12.4 2005-05-24 Class::DBI::Test::SQLite(3pm)