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)
Perl::Critic::Policy::ValuesAndExpressions::RequireNumbeUseraContributed PPerl::Critic::Policy::ValuesAndExpressions::RequireNumberSeparators(3pm)NAME
Perl::Critic::Policy::ValuesAndExpressions::RequireNumberSeparators - Write " 141_234_397.0145 " instead of " 141234397.0145 ".
AFFILIATION
This Policy is part of the core Perl::Critic distribution.
DESCRIPTION
Long numbers can be difficult to read. To improve legibility, Perl allows numbers to be split into groups of digits separated by
underscores. This policy requires number sequences of more than three digits to be separated.
$long_int = 123456789; #not ok
$long_int = 123_456_789; #ok
$long_float = 12345678.001; #not ok
$long_float = 12_345_678.001; #ok
CONFIGURATION
The minimum absolute value of numbers that must contain separators can be configured via the "min_value" option. The default is 10,000;
thus, all numbers >= 10,000 and <= -10,000 must have separators. For example:
[ValuesAndExpressions::RequireNumberSeparators]
min_value = 100000 # That's one-hundred-thousand!
NOTES
As it is currently written, this policy only works properly with decimal (base 10) numbers. And it is obviously biased toward Western
notation. I'll try and address those issues in the future.
AUTHOR
Jeffrey Ryan Thalhammer <jeff@imaginative-software.com>
COPYRIGHT
Copyright (c) 2005-2011 Imaginative Software Systems. All rights reserved.
This program is free software; you can redistribute it and/or modify it under the same terms as Perl itself. The full text of this license
can be found in the LICENSE file included with this module.
perl v5.14.22012-0Perl::Critic::Policy::ValuesAndExpressions::RequireNumberSeparators(3pm)