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
yap
YAP(1) General Commands Manual YAP(1)NAME
yap - prolog interpreter and compiler
SYNOPSIS
yap [options] filename
DESCRIPTION
yap is a prolog interpreter and compiler.
In its basic form, yap starts an interactive Prolog interpreter. When restoring a saved state, yap will allocate the same amount of memory
as that in use when the state was saved, unless a different amount is specified by flags in the command line. By default, yap restores the
file startup from the current directory or from the yap library.
See the yap manual for how to use yap for writing Prolog scripts.
OPTIONS
-? Print a short error message.
-s n Allocate n K bytes for local and global stacks.
-h n Allocate n K bytes for heap and auxiliary stacks
-t n Allocate n K bytes for the trail stack
-l yap-file
Compile the Prolog file yap-file before entering the top-level.
-L yap-file
Compile the Prolog file yap-file and then halt. This option is useful for implementing scripts.
-g goal
run the goal goal before top-level. The goal is converted from an atom to a Prolog term.
-z goal
run the goal goal as top-level. The goal is converted from an atom to a Prolog term.
-b boot-file
Boot code is in Prolog file boot-file. The filename must define the predicate '$live'/0.
-c ip-host port
Connect standard streams to host ip-host at port port.
filename
Restore state saved in the given file.
-- Separator for arguments to Prolog code. These arguments are visible through the unix/1 built-in.
ENVIRONMENT
YAPBINDIR
Yap usually boots from a saved state. The saved state will use the default installation directory to search for the YAP binary
unless you define the environment variable YAPBINDIR.
YAPLIBDIR
Yap always tries to find saved states from the current directory first. If it cannot it will use the environment variable YAPLIBDIR,
if defined, or search the default library directory.
YAPSHAREDIR
Yap will try to find library files from the YAPSHAREDIR/library directory.
SEE ALSO
The YAP manual is on a debian system available through the info system (command info yap), and as a html document through the debian help
system.
AUTHOR
Yap was written by R. Lopes, L.Damas, V. Santos Costa.
This manual page was compiled by Ralf Treinen <treinen@debian.org> from the Yap manual for the Debian project (but may be used by others).
COPYRIGHT
Since this manpage is derived from the yap manual it is subject to the licence of the yap manual:
Permission is granted to make and distribute verbatim copies of this manual provided the copyright notice and this permission notice are
preserved on all copies.
Permission is granted to copy and distribute modified versions of this manual under the conditions for verbatim copying, provided that the
entire resulting derived work is distributed under the terms of a permission notice identical to this one.
Permission is granted to copy and distribute translations of this manual into another language, under the above conditions for modified
versions.
December 23, 2007 YAP(1)