hi
i want to create file which will be executed in sqlplus
so consider there are abc[1-100] tables and i want count from all the tables now i used for loop for this for eg.
but how can i specify only range like tfj[1-100] ??
Hello,
Using Solaris 10. Going to mirror disks with solstice disksuite. Documentation says I have to make both disks partitioned exactly the same before moving on.
Here's the layout of c1t0d0
Part Tag Flag Cylinders Size Blocks
0 root wm 1237 - 2473 6.00GB (1237/0/0) 12587712
... (1 Reply)
I have a text file which contains a row of values ranging from -9.99 to 1.00
now the issue here is I need the script below to keep checking recursively th entire file, yes the entire fila and only then specify the row contains just 1.00 or any other value...
the script is below
... (0 Replies)
I want to print between the range two patterns if a particular pattern is present in between the two patterns. I am new to Unix. Any help would be greatly appreciated.
e.g.
Pattern1
Bombay
Calcutta
Delhi
Pattern2
Pattern1
Patna
Madras
Gwalior
Delhi
Pattern2
Pattern1... (2 Replies)
Hi all,
I wrote few lines of code to check how long a process has been uptime.
I work on Solaris SunOS 5.10 and perl v5.8.4.
Here is the code:
#!/usr/bin/perl
use Time::Local;
$service="TCPIPSCH";
$PID_SERVICE=`ps -ef | grep -w $service | grep -v grep | awk '{print \$2}'`;
if... (2 Replies)
I have a number of instances wher I need to run reports for the previous month and need to include the last months date range in the sql.
I want to create a string which consists of the first and last dates of last month separated with an ' and ' ie for this month (Feb) I want it to say
'01/01/10... (3 Replies)
Hi All,
I would like to assign the following values to each column in my file.
if $i is between 1 and -1 (ie -1 < $i < 1) then print A;
if $i is between -2 and -1 && 1 and 2 (ie. -2 < $i < -1 && 1 < $i < 2) then print B;
if $i is between -3 and -2 && 2 and 3 (ie. -3 < $i < -2 && 2 < $i < 3)... (1 Reply)
Dear All,
I need to classify my data into sets or ranges based on values in the second column of a file as - low medium and high.
INPUT:
file1.dat
1.tmp 1.03
2.tmp 0.38
3.tmp 3.23
4.tmp 1.34
I would like to classify all the numerical values into a range based on the followng... (3 Replies)
Is there a way to create a loop that will output number starting from 0.1 to 10.0
0.1
0.2
0.3
0.4
0.5
..
...
10.0
This is what i tried.
for i in {1..50}; do printf -v i '%02d' $i ; echo "$i"; done
That will print
01
02
03
..
..
50 (9 Replies)
Hi All,
I'm a bit confused about assigning IP address from IP Ranges.
I am using this scenario below to understand.
Scenario
Adatum.com an international IT solutions company, is launching 12 new branches in a new country where they currently have no existing branches. The sWin CIO has asked... (3 Replies)
THIS IS A SAMPLE PRACTICAL EXAM QUESTION, COMPLETE FILE HAS BEEN ATTACHED AS WELL.
Hi All,
I'm a bit confused about assigning IP address from IP Ranges.
I am using this scenario below to understand.
Scenario
Adatum.com an international IT solutions company, is launching 12 new branches in a... (10 Replies)
Discussion started by: TryllZ
10 Replies
LEARN ABOUT DEBIAN
sql::translator::schema::view
SQL::Translator::Schema::View(3pm) User Contributed Perl Documentation SQL::Translator::Schema::View(3pm)NAME
SQL::Translator::Schema::View - SQL::Translator view object
SYNOPSIS
use SQL::Translator::Schema::View;
my $view = SQL::Translator::Schema::View->new(
name => 'foo', # name, required
sql => 'select id, name from foo', # SQL for view
fields => 'id, name', # field names in view
);
DESCRIPTION
"SQL::Translator::Schema::View" is the view object.
METHODS
new
Object constructor.
my $view = SQL::Translator::Schema::View->new;
fields
Gets and set the fields the constraint is on. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
field names and keep them in order by the first occurrence of a field name.
$view->fields('id');
$view->fields('id', 'name');
$view->fields( 'id, name' );
$view->fields( [ 'id', 'name' ] );
$view->fields( qw[ id name ] );
my @fields = $view->fields;
tables
Gets and set the tables the SELECT mentions. Accepts a string, list or arrayref; returns an array or array reference. Will unique the
table names and keep them in order by the first occurrence of a field name.
$view->tables('foo');
$view->tables('foo', 'bar');
$view->tables( 'foo, bar' );
$view->tables( [ 'foo', 'bar' ] );
$view->tables( qw[ foo bar ] );
my @tables = $view->tables;
options
Gets and sets a list of options on the view.
$view->options('ALGORITHM=UNDEFINED');
my @options = $view->options;
is_valid
Determine whether the view is valid or not.
my $ok = $view->is_valid;
name
Get or set the view's name.
my $name = $view->name('foo');
order
Get or set the view's order.
my $order = $view->order(3);
sql
Get or set the view's SQL.
my $sql = $view->sql('select * from foo');
schema
Get or set the view's schema object.
$view->schema( $schema );
my $schema = $view->schema;
equals
Determines if this view is the same as another
my $isIdentical = $view1->equals( $view2 );
AUTHOR
Ken Youens-Clark <kclark@cpan.org>.
perl v5.14.2 2012-05-01 SQL::Translator::Schema::View(3pm)