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 XFREE86
unicode
UNICODE(1) General Commands Manual UNICODE(1)NAME
unicode - command line unicode database query tool
SYNOPSIS
unicode [options] string
DESCRIPTION
This manual page documents the unicode command.
unicode is a command line unicode database query tool.
OPTIONS -h--help
Show help and exit.
-x--hexadecimal
Assume string to be a hexadecimal number
-d--decimal
Assume string to be a decimal number
-r--regexp
Assume string to be a regular expression
-s--string
Assume string to be a sequence of characters
-a--auto
Try to guess type of string from one of the above (default)
-mMAXCOUNT
--max=MAXCOUNT
Maximal number of codepoints to display, default: 20; use 0 for unlimited
-iCHARSET
--io=IOCHARSET
I/O character set. For maximal pleasure, run unicode on UTF-8 capable terminal and specify IOCHARSET to be UTF-8. unicode tries to
guess this value from your locale, so with properly set up locale, you should not need to specify it.
-cADDCHARSET
--charset-add=ADDCHARSET
Show hexadecimal reprezentation of displayed characters in this additional charset.
-CUSE_COLOUR
--colour=USE_COLOUR
USE_COLOUR is one of on off auto
--colour=on will use ANSI colour codes to colourise the output
--colour=off won't use colours.
--colour=auto will test if standard output is a tty, and use colours only when it is.
--color is a synonym of --colour
-v--verbose
Be more verbose about displayed characters, e.g. display Unihan information, if available.
-w--wikipedia
Spawn browser pointing to Wikipedia entry about the character.
USAGE
unicode tries to guess the type of an argument. For example, you can use any of the following to display information about U+00E1 LATIN
SMALL LETTER A WITH ACUTE (a):
unicode 00E1
unicode U+00E1
unicode a
unicode 'latin small letter a with acute'
You can specify a range of characters as argumets, unicode will show these characters in nice tabular format, aligned to 256-byte bound-
aries. Use two dots ".." to indicate the range, e.g.
unicode 0450..0520
will display the whole cyrillic and hebrew blocks (characters from U+0400 to U+05FF)
unicode 0400..
will display just characters from U+0400 up to U+04FF
BUGS
Tabular format does not deal well with full-width, combining, control and RTL characters.
SEE ALSO ascii(1)AUTHOR
Radovan Garabik <garabik @ kassiopeia.juls.savba.sk>
2003-01-31 UNICODE(1)