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
z88dk-copt
copt(1) z88 Development Kit copt(1)NAME
copt - peephole optimizer
SYSNOPIS
copt file ...
DESCRIPTION
copt is a general-purpose peephole optimizer. It reads code from its standard input and writes an improved version to its standard output.
copy reads the named files for its optimizations, which are encoded as follows:
<pattern for input line 1>
<pattern for input line 2>
...
<pattern for input line n>
=
<pattern for output line 1>
<pattern for output line 2>
...
<pattern for output line m>
<blank line>
Pattern matching uses literal string comparison, with one exception: ``%%'' matches the ``%'' character, and ``%'' followed by a digit
matches everything up to the next occurrence of the next pattern character, though all occurrences of %n must denote the same string. For
example, the pattern ``%1=%1.'' matches exactly those strings that begin with a string X, followed by a ``='' (the first), followed by a
second occurrence of X, followed by a period. In this way, the input/output pattern
mov $%1,r%2
mov *r%2,r%2
=
mov %1,r%2
commands copt to replace runs like
mov $_a,r3
mov *r3,r3
with
mov _a,r3
Note that a tab or newline can terminate a %n variable.
copt compares each run of input patterns with the current input instruction and its predecessors. If no match is found, it advances to the
next input instruction and tries again. Otherwise, it replaces the input instructions with the corresponding output patterns, pattern vari-
ables instantiated,and resumes its search with the first instruction of the replacement. copt matches input patterns in reverse order to
cascade optimizations without backing up.
BUGS
Errors in optimization files are always possible.
SEE ALSO z88dk(1), z88dk-zcc(1), z88dk-z80asm(1), z88dk-appmake(1), z88dk-copt(1).
AUTHOR
z88dk was written by Dominic Morris <dom@z88dk.org>, and others.
01 December 2009 copt(1)