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,
Can some1 help me to output a tab in an echo statement.
I have tried
echo "RNC: \t NODEB"
but dont get the correct output.
I am a beginnger to unix, so pls hold back the laughs....if u can (5 Replies)
Hi
I have a text file , contents are
Line1:field1,field2,field3,field4,field5,field6.......field20
Line2:field1,field2,field3,field4,field5,field6.......field20
Line3:field1,field2,field3,field4,field5,field6.......field20
....and so on...
I want to read this file and insert the data into... (4 Replies)
Hi All,
I am using Unix ksh script.
I need to insert values to a table using the o/p from a slelect statement.
Can anybody Help!
My script looks like tihs.
---`sqlplus -s username/password@SID << EOF
set heading off
set feedback off
set pages 0
insert into ${TB_NAME}_D... (2 Replies)
hi,
When i try to run the code below, i get the following error
"ksh: syntax error: `(' unexpected"
i am not able to figure it out. Can anyone help me?
Code: (2 Replies)
I have a form , where i will put the values to a table.
I wrote a insert statement for the same.
Table structure is
ename | character varying(30) |
eadd | character varying(30) |
eid | integer |
sal | integer
In the statements, i don't... (1 Reply)
Hello,
Can anyone tell me that,
How can I assign variable to shell script variable, which i need to use in INSERT INTO statement?
my shell script variables are,
EMPNAME=`regular expression`
EMPID=`regular expression`
EMPBDATE=`regular expression`
Now through ksh script I am... (16 Replies)
Hi Guys,
I want to create a shell script that will give me the output below. I want to insert the numbers from the input file to my url addresses below. And from the numbers below, I want to separate the last digit with a period (i.e. from 222222222222 to 22222222222.2). Appreciate any help.... (14 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)
Hi,
Need help, using awk command to insert statement
awk -v q="'" '{ print "db2 connect to repolab > /dev/null; " "\n" "db2 -x \" select name from IBMPDQ.PROFILE where managed_database = " q $1"_"$3"__0" q "\"" } ' profile.txt | sh - | awk -v i="'" ' { print "db2 connect to repolab >... (1 Reply)
Discussion started by: Mathew_paul
1 Replies
LEARN ABOUT DEBIAN
specrb
SPECRB(1)SPECRB(1)NAME
specrb - standalone test runner for test/spec and Test::Unit test suites
SYNOPSIS
specrb [OPTIONS] [FILES | -a ] [-- untouched arguments]
DESCRIPTION
The Ruby script specrb allows you to run tests written with test/spec from the command line. It can also be used for plain Test::Unit test
suites. You can either specify the names of the test files you want to run, or let specrb find automatically all the tests in your project,
by using the -a switch (see TEST/SPEC OPTIONS below).
You can also use various options on the command line to pass parameters to the Ruby interpreterm or to modify the behavior of test/spec
and/or test/unit.
RUBY OPTIONS -e, --eval LINE
evaluate a LINE of code
-d, --debug
set debugging flags (set $DEBUG to true)
-w, --warn
turn warnings on for your script
-I, --include PATH
specify $LOAD_PATH (may be used more than once)
-r, --require LIBRARY
require the LIBRARY, before executing your script
TEST /SPEC OPTIONS:
-s, --specdox
do AgileDox-like output
--rdox
do AgileDox-like output with RDoc formatting
-a, --automatic
gather tests from ./test/, include ./lib/
TEST ::UNIT OPTIONS:
-n, --name NAME
runs tests matching regexp NAME
-t, --testcase TESTCASE
runs tests in TestCases matching regexp TESTCASE
COMMON OPTIONS :
-h, --help
show a message similar to this manpage
--version
show version
AUTHORS
The test/spec library has been written by Christian Neukirchen <http://purl.org/net/chneukirchen>.
This manual page, inspired by the help message of specrb, has been written for the Debian Project by Cedric Boutillier (but may used by
others).
2012-06-26 SPECRB(1)