How to insert numbers to a in between statement Post: 302531996

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk command for INSERT statement

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...

2. Shell Programming and Scripting

Insert TAB in echo statement

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

3. Shell Programming and Scripting

Script does not execute Insert Statement

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. Shell Programming and Scripting

How is use sselect statement o/p in insert statement.

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...

5. Shell Programming and Scripting

error in insert statement

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:

6. Programming

Dynamic Insert statement

7. Programming

Assign variable for INSERT INTO statement

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...

8. Shell Programming and Scripting

How to insert date in a statement?

Hi Guys, Can somebody help me in inserting today's DATE format (20110709) in my awk statement. I have a script but its not working. inputfile.txt: 269,1,0,AAA,430 231,2,0,BBB,430 252,3,0,CCC,430 214,4,0,DDD,430 script.sh #!/bin/bash DATE="`date +%Y%m%d`" cd /var/opt/

9. Shell Programming and Scripting

Convert Update statement into Insert statement in UNIX using awk, sed....

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...

10. Shell Programming and Scripting

How to insert random numbers into each line?

I have a file contains thousands of lines. I want to insert n random numbers into each line at specific position. Like this: 0 22…… 1 33…… …… …… I want to insert 3 random numbers from position 2 to 4 into each line. 0 325 22…… 1 685 33…… …… …… Please use CODE tags when...

LEARN ABOUT DEBIAN

finance::quote::cdnfundlibrary

Finance::Quote::Cdnfundlibrary(3pm)			User Contributed Perl Documentation		       Finance::Quote::Cdnfundlibrary(3pm)

NAME

       Finance::Quote::Cdnfundlibrary  - Obtain mutual fund prices from www.fundlibrary.com

SYNOPSIS

	   use Finance::Quote;

	   $q = Finance::Quote->new;

	   %stockinfo = $q->fetch("canadamutual","fundlib-code"); # Can
       failover to other methods
	   %stockinfo = $q->fetch("fundlibrary","fundlib-code"); # Use this
       module only.

	   # NOTE: currently no failover methods exist for canadamutual

DESCRIPTION

       This module obtains information about Canadian Mutual Fund prices from www.fundlibrary.com.  The information source "canadamutual" can be
       used if the source of prices is irrelevant, and "fundlibrary" if you specifically want to use www.fundlibrary.com.

FUNDLIB-CODE
       In Canada a mutual fund does not have a unique global symbol identifier.

       This module uses an id that represents the mutual fund on an id used by www.fundlibrary.com.  There is no easy way of fetching the id
       except to jump onto the fundlibrary website, look up the fund and view the url for clues to its id number.

LABELS RETURNED

       Information available from fundlibrary may include the following labels:

       exchange method link source name currency yield last nav price.	The link label will be a url location for a one page snapshot that
       fundlibrary provides on the fund.

SEE ALSO

       Fundlibrary website - http://www.fundlibrary.com/

       Finance::Quote

perl v5.14.2							    2012-05-06				       Finance::Quote::Cdnfundlibrary(3pm)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

awk command for INSERT statement

Discussion started by: nattynatty

2. Shell Programming and Scripting

Insert TAB in echo statement

Discussion started by: sunils27

3. Shell Programming and Scripting

Script does not execute Insert Statement

Discussion started by: Amruta Pitkar

4. Shell Programming and Scripting

How is use sselect statement o/p in insert statement.

Discussion started by: nkosaraju