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
xcolmix
XCOLMIX(1) General Commands Manual XCOLMIX(1)NAME
xcolmix - an RGB colour mixer
SYNOPSIS
xcolmix [-display host:dpy] [-name appname] [-visual class] [-depth d] [-private] [-shared] [-stdcmap] [-debug d] [-sync] rgb-database-file
The rgb-database-file is the file which holds the X-windows colour definitions, when absent: /etc/X11/rgb.txt is used.
DESCRIPTION
This manual page documents briefly the xcolmix, command. This manual page was written for the Debian GNU/Linux distribution because the
original program does not have a manual page.
xcolmix is a colour mixer that enables you to mix your own colours in order to determine three values (the R/G/B code, or red-green-blue
mix) of a colour. You can use those colours to, e.g., define the foreground or background of X applications which support it. Furthermore,
xcolmix lets you retrieve RGB values from the X system's database of `predefined' colours.
xcolmix is non longer actively maintained upstream. If you would like to take it over, talk to the author: Karel Kubat <karel@icce.rug.nl>.
OPTIONS
xcolmix is built with the XForms Graphical User Interface Toolkit for X, and hence supports a number of flags which are interpreted by
XForms. The flags must be stated before any file arguments, and are:
-display host:dpy
defines the X display.
-name appname
defines the application name (default is xcolmix).
-visual class
TrueColor, PseudoColor etc...
-depth d
visual depth in bits
-private
forces a private colourmap.
-shared
forces a shared colourmap.
-stdcmap
forces a standard colourmap.
-debug l
prints debugging information, l is the level.
-sync forces synchronous mode.
USING XCOLMIX
Xcolmix lets you define a separate background and a foreground colour for a part of the mixer window (the logo). Use this logo to, e.g.,
compare whether a particular text colour looks good on a particular background.
Use the `foreground / background' buttons to select between the foreground or the background. Then, use the three silders labelled `red',
`green' and `blue' to change the colour.
The button `lookup' starts a second window, with a browser showing the system colour database. The default database name is
/etc/X11/rgb.txt, though you can overrule this filename with a file argument in the command that starts up xcolmix.
AUTHOR
Karel Kubat <karel@icce.rug.nl>
This manual page was written by Peter S Galbraith <psg@debian.org>, for the Debian GNU/Linux system (but may be used by others).
XCOLMIX(1)