Guys
I have a date value like this in a table -> 2006-12-29 12:57:08(data type varchar2(25))
I am trying to subtract this column from sysdate.
I am unable to do that. can u guys suggest me a way to do this.. (2 Replies)
Hi all, I want to start a new topic on this matter
I have this script,
#!perl
use strict;
use warnings;
use Data::Dumper;
open my $log, '>', 'log-external.txt' or die "Could not open log: $!";
print $log "Subnet,Static,DHCP,Unused\n";
open my $dump, '>', 'dump.log' or die... (2 Replies)
Dear all
I had input file as mention below and want op as mention.
Kindly let me knw possible ways.
Regards
Jaydeep
INPUT:
RXOTX-48-1
2A 34
2B 35
RXOTX-499-2
2C 32
RXOTX-4-1
2D 23
OUTPUT: (3 Replies)
Hello Team i have a file with following data (as columns).
I need implement a syntax like below for altering table
ALTER TABLE1 TABLENAME
ADD COLUMN COL1 CHAR(5) NOT NULL WITH DEFAULT
ADD COLUMN COL2 CHAR(5)
..
..
ADD COLUMN COLn CHAR(5) NOT NULL... (1 Reply)
This is a bit off the wall, but I often need to run scripts where there are argument values that contain special characters.
For example,
$ ./process.exe -t M -N -o temp.mol.s -i ../molfiles/N,N\',N\'\'-trimethylbis\(hexamethylene\)triamine.mol && sfile_space_to_tab.sh temp.mol.s temp.s
It... (1 Reply)
Hi,
I have a data as follows in some files, i want to change CHAR(2-20) to VARCHAR(2-20). I should not touch any line with CHAR(1)
Example:
Input:
cur_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
prev_rev_stage_cd CHAR(5) CHARACTER SET LATIN NOT... (7 Replies)
I need to create a fixed width file based on the column lengths.
lets assume I have six(this may be dynamic) fields each are of different length
column1=6 #size of the column
column2=3
column3=2
column4=3
column5=4
column6=5
I tried below code snippet but it is not working
echo... (4 Replies)
Discussion started by: gvkumar25
4 Replies
LEARN ABOUT DEBIAN
www::search::ebay::byenddate
WWW::Search::Ebay::ByEndDate(3pm) User Contributed Perl Documentation WWW::Search::Ebay::ByEndDate(3pm)NAME
WWW::Search::Ebay::ByEndDate - backend for searching www.ebay.com, with results sorted with "items ending first"
SYNOPSIS
use WWW::Search;
my $oSearch = new WWW::Search('Ebay::ByEndDate');
my $sQuery = WWW::Search::escape_query("C-10 carded Yakface");
$oSearch->native_query($sQuery);
while (my $oResult = $oSearch->next_result())
{ print $oResult->url, "
"; }
DESCRIPTION
This class is a Ebay specialization of WWW::Search. It handles making and interpreting Ebay searches http://www.ebay.com.
This class exports no public interface; all interaction should be done through WWW::Search objects.
NOTES
The calling program must ensure that the Date::Manip module is able to determine the local timezone. The easiest way is to set the
environment variable TZ, or by calling &Date_Init(). See the documentation of Date::Manip.
The search is done against CURRENT running auctions only.
The query is applied to TITLES only.
The results are ordered auctions ending soon first (order of increasing auction ending date).
In the resulting WWW::Search::Result objects, the description field consists of a human-readable combination (joined with semicolon-space)
of the Item Number; number of bids; and high bid amount (or starting bid amount).
In the WWW::Search::Result objects, the change_date field contains the auction ending date & time in ISO 8601 format; i.e.
year-month-dayThour:minute:second.
SEE ALSO
To make new back-ends, see WWW::Search.
CAVEATS BUGS
Please tell the author if you find any!
AUTHOR
Martin 'Kingpin' Thurn, "mthurn at cpan.org", <http://tinyurl.com/nn67z>.
LEGALESE
Copyright (C) 1998-2009 Martin 'Kingpin' Thurn
THIS SOFTWARE IS PROVIDED "AS IS" AND WITHOUT ANY EXPRESS OR IMPLIED WARRANTIES, INCLUDING, WITHOUT LIMITATION, THE IMPLIED WARRANTIES OF
MERCHANTABILITY AND FITNESS FOR A PARTICULAR PURPOSE.
perl v5.12.4 2011-11-02 WWW::Search::Ebay::ByEndDate(3pm)