Hi,
I sometimes bulk upload data in oracle. The problem is that I sometimes get an INSERT statemnt like this:
INSERT INTO ALL_USER_HOTSPOT_DETAILS (USR_LOGIN,USR_LASTNAME,USR_FIRSTNAME,USR_EMAIL,
PROPERTYNR)
VALUES ('SABRDAG','D'AGOS','SABRINA','sabrina_d'agos@sheraton.com',70)
I... (4 Replies)
Hi all,
How can i use the below unix command in AWK . Can any one please suggest me how i can use.
sed -e "s/which first.sh/which \$0/g" $shell > $shell.sal
where $0=current program name(say current.sh)
$shell=second.sh (1 Reply)
Hi,
Script that I wrote only run sql query once then exit. But my requirement, I want the query can be execute a couple of time without exiting the script. How could I do it? Thanks. (1 Reply)
Can i do this
Say one command
sed 's/:*/ /g' $summf
is returning
C1234
C2345
C3434
some no of rows, now this ouput i have to insert it into a DB table
how do i do this?? (2 Replies)
Hi Guys..
need some urgent help... I am stuck in something badly
I need to write a script which would read a sql statement (which might be a join/inner join/select/sub select etc. )
I need to read that sql statement ... and in the output I want all the table names and columns (doesn't... (4 Replies)
Hi,
I have problem with the following code. My IF block is not executed. And I see "syntax error near unexpected token `)'" error for line "EOF" in the stats_function().
but when I comment the IF block I don't see this error.
Kindly help me with this issue.
clean_function()
{... (10 Replies)
The following is my script :
#!/bin/bash
echo "please give app_instance_id"
read app_instance_id
echo "id is $app_instance_id"
export app_id=app_instance_id
sqlplus -s nnviewer/lookup@//nasolora008.enterprisenet.org:1521/LOAD3 @test.sql<<EOF
SPOOL /home/tibco/MCH/Data/qa/raak/name.xls... (4 Replies)
Hello
can you please help me with below script which is meant to delete clients from multiple netbackup policies
I want to run a command insdie awk statement
apparelnlty this script is not working for me
for i in $( cat clients_list)
do
bppllist -byclient $i | awk... (6 Replies)
hi all i need to add the prinf statement in awk command for the converted comma separated output....
below is my code :
Code Credits :RudiC
awk -F, 'NF==2 {next}
{ITM=$1
AMT=$2+0
CNT=$3+0
TOTA+=$2
... (4 Replies)
Hi folks,
I have a scenario to convert the update statements into insert statements using shell script (awk, sed...) or in database using regex.
I have a bunch of update statements with all columns in a file which I need to convert into insert statements.
UPDATE TABLE_A SET COL1=1 WHERE... (0 Replies)
Discussion started by: dev123
0 Replies
LEARN ABOUT DEBIAN
dh_installzope
DH_INSTALLZOPE(1) Debhelper DH_INSTALLZOPE(1)NAME
dh_installzope - install zope product and extension files into package build directories
SYNOPSIS
dh_installzope [debhelper options] [-n] [-Xitem] [dir ...]
DESCRIPTION
dh_installzope is a debhelper program that is responsible for installing zope products and extensions into package build directories.
Directory names are interpreted as zope product names and will be installed into the first package dh_installzope is told to act on. By
default, this is the first binary package in debian/control, but if you use -p, -i, or -a flags, it will be the first package specified by
those flags.
dh_installzope automatically installs debian/dzproduct and debian/dzextension if it exists. If dh_installzope is acting on multiple
packages, debian/dzproduct and debian/dzextension files will be installed into the first package. Use debian/package.dzproduct and
debian/package.dzextension for different binary packages.
If your package needs to register more than one product or extension, you need multiple files. To accomplish this, you can use files named
debian/package.dzproduct.* and debian/package.dzextension.*
Missing dzproduct and dzextension files for the first package dh_installzope is told to act on are generated and installed automatically.
The substitution variable zope:Depends is replaced by a list of the available zope versions.
OPTIONS -n, --noscripts
Do not modify postinst/prerm scripts.
-Xitem, --exclude=item
Exclude files that contain "item" anywhere in their filename from being installed.
directory ...
Install these directories as products into the first package acted on.
EXAMPLES
This is an example of a debian/package.dzproduct file:
Package: zope-cmfdefault1.4
Name: CMFDefault
Directory: CMFDefault:1.4
Depends: CMFTopic:1.4
Version: 1.4.7-1
ZopeVersions: 2.9 2.8
The Version field is added or updated by dh_installzope. If Name and Directory match, the latter can be omitted. A deviating Directory is
used to install different product versions. A Directory has the form <product name>[:<suffix>].
It is possible to specify the list of zope versions for the 2.x serie using a >= relation, like in this example:
Package: zope-psycopgda
ZopeVersions: >= 2.7
This allows bin-NMUs of zope products on new Zope 2.x major versions, and for this reason it should be the preferred syntax.
NOTES
Note that this command is not idempotent. "dh_clean -k" should be called between invocations of this command. Otherwise, it may cause
multiple instances of the same text to be added to maintainer scripts.
SEE ALSO debhelper(7)
This program is a part of zope-debhelper.
AUTHOR
Matthias Klose <doko@ubuntu.com> Fabio Tranchitella <kobold@debian.org>
0.3.15 2011-06-21 DH_INSTALLZOPE(1)