check if the insert statement is using column names Post: 302588413

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

(sed) parsing insert statement column that crosses multiple lines

I have a file with a set of insert statements some of which have a single column value that crosses multiple lines causing the statement to fail in sql*plue. Can someone help me with a sed script to replace the new lines with chr(10)? here is an example: insert into mytable(id, field1, field2)...

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

3. Shell Programming and Scripting

Change names in a column based on the symbols in another column

If the 4th column has - sign then the names in 3rd column has to change to some user defined names (as shown in output). Thanx input1 1 a aaaaa + 2 b bbbbb + 3 c ccccc + 4 d ddddd + 5 e eeeee + 6 f xxxxx + 8 h hhhhh +...

4. Shell Programming and Scripting

rearrange the column names with comma as column delimiter

Hi, I am new to shell scripting, i have requirement can any one help me out in this regrads, in directory i have file like invoice1.txt, invoice2.txt in each file i have fixed number of columns, 62 in number but they are randomly arranged.like for first file invoice1.txt can have columns...

5. Shell Programming and Scripting

How to insert numbers to a in between statement

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

6. Shell Programming and Scripting

Transpose field names from column headers to values in one column

Hi All, I'm looking for a script which can transpose field names from column headers to values in one column. for example, the input is: IDa;IDb;IDc;PARAM1;PARAM2;PARAM3; a;b;c;p1val;p2val;p3val; d;e;f;p4val;p5val;p6val; g;h;i;p7val;p8val;p9val; into the output like this: ...

7. Shell Programming and Scripting

awk to insert a files names

I have a couple of text files which are named as 1.txt 2.txt 1000.txt 11.txt I want to cat/merge the contents of each text file into one single file like this 1 content of 1.txt 2 content of 2.txt 1000 content of 1000.txt 11 content of 11.txt

8. Shell Programming and Scripting

Insert data in first column(if blank) from previous line first column

Dear Team I need to insert field(which is need to taken from previous line's first field) in first column if its blank. I had tried using sed but not find the way. Detail input and output file as below. Kindly help for same. INPUT: SCGR SC DEV DEV1 NUMDEV DCP ...

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. UNIX for Beginners Questions & Answers

How to insert data into black column( Secound Column ) in excel (.XLSX) file using shell script?

Source Code of the original script is down below please run the script and try to solve this problem this is my data and I want it column wise 2019-03-20 13:00:00:000 2019-03-20 15:00:00:000 1 Operating System LAB 0 1 1 1 1 1 1 1 1 1 0 1

LEARN ABOUT OSF1

true

true(1) 						      General Commands Manual							   true(1)

NAME

       true, false - Returns a standard exit value

SYNOPSIS

       true

       false

STANDARDS

       Interfaces documented on this reference page conform to industry standards as follows:

       true:  XCU5.0

       false:  XCU5.0

       Refer to the standards(5) reference page for more information about industry standards and associated tags.

DESCRIPTION

       The true command returns a 0 (zero) exit value. The false command returns a nonzero exit value. These commands are usually used in input to
       shell commands.

NOTES

       The special built-in utility : (colon) is sometimes more efficient than the true command.

EXIT STATUS

       [Tru64 UNIX]  The nonzero value returned by the false command may vary from system to system.

EXAMPLES

       To construct a loop in a shell procedure, enter: while true do	   date      sleep 60 done

       This procedure displays the date and time once a minute.  To stop it, press the Interrupt key sequence.

SEE ALSO

       Commands:  csh(1), ksh(1), Bourne Shell sh(1b), POSIX shell sh(1p)

       Standards:  standards(5)

																	   true(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

(sed) parsing insert statement column that crosses multiple lines

Discussion started by: jjordan

2. Shell Programming and Scripting

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

Discussion started by: nkosaraju

3. Shell Programming and Scripting

Change names in a column based on the symbols in another column

Discussion started by: repinementer

4. Shell Programming and Scripting

rearrange the column names with comma as column delimiter

Discussion started by: madhav62