I need to execute the below code to get the max & min date from the table:
Code:
su - oracle<<EOC
export PATH=${PATH}:${ORACLE_HOME}/bin
id -a
exit
EOC
`sqlplus abc/xyz123@localdb<<EOS
select min(time) from tab_purg;
select max(time) from tab_purg;
exit
EOS`
I want to store the date values retrieved from the above two queries in two different variables and want this variable values to display on the screen.
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (5 Replies)
Hi all
I need to input values in a .csv file into my Oracle table running in Unix, I wonder what would be the command to do so...
The values are recorded in an excel file and I tried using a formatted text file to do so but failed because one of the field is simply too large to fit in the... (4 Replies)
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
I have requirement:
1) Check the record count in table (table in oracle)
2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and
Again check the record count after 10 min.......... (Loop this process if record count >0).
3) Generate touch... (1 Reply)
I have an input file like
RMS_RPT_PERIOD_DIM,Table,NYTD_SLS_DM,GPS_SLS_DM1,NYTD_SLS_GPS_INT,RMS_DM,byreddys,7/31/2009,byreddys,7/31/2009,Y,//depot/eqr/salesgps/trunk/src/db/table,TBL_GPS_CONTACT_DETAILS.sql,1.1,,lakshmi,sql,y... (2 Replies)
Hi
I am having three oracle databases running in three different machine. their ip address is different. from one of the DB am able to access both the databases.(means am able to select values and insert values in to tables individually.)
I need to fetch some data from DB1 table(say DB1 ip is... (2 Replies)
Hi,
I am new to Unix/ksh script and will like to check how do I retrieve just the count of '258' in the last line in a text file ?
There will be this "TRL" appended with number of count at the last line in a text file .
TRL0000000258
var=`grep 'TRL' $HOME/folder/test.txt | wc -l`
... (12 Replies)
hi,
i need to copy one table with data into another table,
right now am using
create table table1 as select * from table2
i want the constraints of table1 to be copied to table2 also , can anyone give me some solution to copy the constraints also, now am using oracle 10.2.0.3.0... (1 Reply)
Discussion started by: senkerth
1 Replies
LEARN ABOUT DEBIAN
text::password::pronounceable
Text::Password::Pronounceable(3pm) User Contributed Perl Documentation Text::Password::Pronounceable(3pm)NAME
Text::Password::Pronounceable - Generate pronounceable passwords
SYNOPSIS
# Generate a pronounceable password that is between 6 and 10 characters.
Text::Password::Pronounceable->generate(6, 10);
# Ditto
my $pp = Text::Password::Pronounceable->new(6, 10);
$pp->generate;
DESCRIPTION
This module generates pronuceable passwords, based the the English digraphs by D Edwards.
METHODS
new
$pp = Text::Password::Pronounceable->new($min, $max);
$pp = Text::Password::Pronounceable->new($len);
Construct a password factory with length limits of $min and $max. Or create a password factory with fixed length if only one argument
is provided.
generate
$pp->generate;
$pp->generate($len);
$pp->generate($min, $max);
Text::Password::Pronounceable->generate($len);
Text::Password::Pronounceable->generate($min, $max);
Generate password. If used as an instance method, arguments override the factory settings.
HISTORY
This code derived from mpw.pl, a bit of code with a sordid history.
o CPAN module by Chia-liang Kao 9/11/2006.
o Perl cleaned up a bit by Jesse Vincent 1/14/2001.
o Converted to perl from C by Marc Horowitz, 1/20/2000.
o Converted to C from Multics PL/I by Bill Sommerfeld, 4/21/86.
o Original PL/I version provided by Jerry Saltzer.
LICENSE
Copyright 2006 by Best Practical Solutions, LLC.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
See <http://www.perl.com/perl/misc/Artistic.html>
perl v5.10.1 2010-08-16 Text::Password::Pronounceable(3pm)