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 SUSE
gd::graph::colour
Graph::colour(3) User Contributed Perl Documentation Graph::colour(3)NAME
GD::Graph::colour - Colour manipulation routines for use with GD::Graph
SYNOPSIS
use GD::Graph::colour qw(:colours :lists :files :convert);
DESCRIPTION
The GD::Graph::colour package provides a few routines to work with colours. The functionality of this package is mainly defined by what is
needed, now and historically, by the GD::Graph modules.
FUNCTIONS
colour_list( number of colours )
Returns a list of number of colours colour names known to the package. Exported with the :lists tag.
sorted_colour_list( number of colours )
Returns a list of number of colours colour names known to the package, sorted by luminance or hue. NB. Right now it always sorts by
luminance. Will add an option in a later stage to decide sorting method at run time. Exported with the :lists tag.
_rgb( colour name )
Returns a list of the RGB values of colour name. if the colour name is a string of the form that is acceptable to the hex2rgb sub, then the
colour will be added to the list dynamically. Exported with the :colours tag.
_hue( R,G,B )
Returns the hue of the colour with the specified RGB values. Exported with the :colours tag.
_luminance( R,G,B )
Returns the luminance of the colour with the specified RGB values. Exported with the :colours tag.
add_colour(colourname => [$r, $g, $b]) or add_colour('#7fe310')
Self-explanatory. Exported with the :colours tag.
rgb2hex($red, $green, $blue)
hex2rgb('#7fe310')
These functions translate a list of RGB values into a hexadecimal string, as is commonly used in HTML and the Image::Magick API, and vice
versa. Exported with the :convert tag.
read_rgb( file name )
Reads in colours from a rgb file as used by the X11 system.
Doing something like:
use GD::Graph::bars;
use GD::Graph::colour;
GD::Graph::colour::read_rgb("rgb.txt") or die "cannot read colours";
Will allow you to use any colours defined in rgb.txt in your graph. Exported with the :files tag.
PREDEFINED COLOUR NAMES
white, lgray, gray, dgray, black, lblue, blue, dblue, gold, lyellow, yellow, dyellow, lgreen, green, dgreen, lred, red, dred, lpurple,
purple, dpurple, lorange, orange, pink, dpink, marine, cyan, lbrown, dbrown.
AUTHOR
Martien Verbruggen <mgjv@tradingpost.com.au>
Copyright
GIFgraph: Copyright (c) 1995-1999 Martien Verbruggen. Chart::PNGgraph: Copyright (c) 1999 Steve Bonds. GD::Graph: Copyright (c) 1999
Martien Verbruggen.
All rights reserved. This package is free software; you can redistribute it and/or modify it under the same terms as Perl itself.
SEE ALSO
GD::Graph, GD::Graph::FAQ
perl v5.12.1 2005-12-14 Graph::colour(3)