Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How is use sselect statement o/p in insert statement.
Top Forums Shell Programming and Scripting How is use sselect statement o/p in insert statement. Post 302222267 by nkosaraju on Wednesday 6th of August 2008 12:05:50 PM
Old 08-06-2008
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
(select
A.${PRI_KEY1},
A.${PRI_KEY2,
A.${PRI_KEY3},
${col_name}, - this is variable from script
A.${col_name},
B.${col_name}
from
${TB_NAME} A,
${DEV_DB}.${TB_NAME} B
where
A.${PRI_KEY1}=B.${PRI_KEY1} and
A.${PRI_KEY2}=B.${PRI_KEY2} and
A.${PRI_KEY3}=B.${PRI_KEY3} and
A.${col_name}!=B.${col_name} and
ROWNUM <= ${THRESHOLD})
;
commit;
exit;
EOF`


Thanks in advance
 

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... (4 Replies)
Discussion started by: nattynatty
4 Replies

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 (5 Replies)
Discussion started by: sunils27
5 Replies

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 Replies)
Discussion started by: Amruta Pitkar
4 Replies

4. 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: (2 Replies)
Discussion started by: ragavhere
2 Replies

5. Programming

Dynamic Insert statement

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)
Discussion started by: pritish.sas
1 Replies

6. 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... (16 Replies)
Discussion started by: Poonamol
16 Replies

7. 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.... (14 Replies)
Discussion started by: pinpe
14 Replies

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/ (8 Replies)
Discussion started by: pinpe
8 Replies

9. Shell Programming and Scripting

check if the insert statement is using column names

Hi, Input- a file comtaining a procedure or function with various statements in that one of the statement would be insert into table1 (a,b,c) values (1,2,3) ourput required true if insert statement is using column name (a,b,c) else false. Please suggest (8 Replies)
Discussion started by: manasa_vs
8 Replies

10. 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... (0 Replies)
Discussion started by: dev123
0 Replies

LEARN ABOUT REDHAT

wbinfo

WBINFO(1)																 WBINFO(1)

NAME

       wbinfo - Query information from winbind daemon

SYNOPSIS

       wbinfo  [  -u ]	[ -g ]	[ -h name ]  [ -i ip ]	[ -n name ]  [ -s sid ]  [ -U uid ]  [ -G gid ]  [ -S sid ]  [ -Y sid ]  [ -t ]  [ -m ]  [
       -r user ]  [ -a user%password ]	[ -A user%password ]

DESCRIPTION

       This tool is part of the  Samba suite.

       The wbinfo program queries and returns information created and used by the  winbindd(8) daemon.

       The winbindd(8) daemon must be configured and running for the wbinfo program to be able to return information.

OPTIONS

       -u     This option will list all users available in the Windows NT domain for which the winbindd(8) daemon is operating in.  Users  in  all
	      trusted  domains will also be listed. Note that this operation does not assign user ids to any users that have not already been seen
	      by winbindd(8).

       -g     This option will list all groups available in the Windows NT domain for which the winbindd(8) daemon is operating in. Groups in  all
	      trusted  domains	will  also  be listed. Note that this operation does not assign group ids to any groups that have not already been
	      seen by winbindd(8).

       -h name
	      The -h option queries winbindd(8) to query the WINS server for the IP address associated with the NetBIOS name specified by the name
	      parameter.

       -i ip  The  -i option queries winbindd(8) to send a node status request to get the NetBIOS name associated with the IP address specified by
	      the ip parameter.

       -n name
	      The -n option queries winbindd(8) for the SID associated with the name specified. Domain names can be specified before the user name
	      by  using  the winbind separator character.  For example CWDOM1/Administrator refers to the Administrator user in the domain CWDOM1.
	      If no domain is specified then the domain used is the one specified in the smb.conf workgroup parameter.

       -s sid Use -s to resolve a SID to a name. This is the inverse of the -n option above. SIDs must be specified as ASCII strings in the tradi-
	      tional Microsoft format. For example, S-1-5-21-1455342024-3071081365-2475485837-500.

       -U uid Try  to convert a UNIX user id to a Windows NT SID. If the uid specified does not refer to one within the winbind uid range then the
	      operation will fail.

       -G gid Try to convert a UNIX group id to a Windows NT SID. If the gid specified does not refer to one within the winbind gid range then the
	      operation will fail.

       -S sid Convert a SID to a UNIX user id. If the SID does not correspond to a UNIX user mapped by	winbindd(8) then the operation will fail.

       -Y sid Convert  a  SID  to  a  UNIX group id. If the SID does not correspond to a UNIX group mapped by  winbindd(8) then the operation will
	      fail.

       -t     Verify that the workstation trust account created when the Samba server is added to the Windows NT domain is working.

       -m     Produce a list of domains trusted by the Windows NT server winbindd(8) contacts when resolving names. This list does not include the
	      Windows NT domain the server is a Primary Domain Controller for.

       -r username
	      Try to obtain the list of UNIX group ids to which the user belongs. This only works for users defined on a Domain Controller.

       -a username%password
	      Attempt to authenticate a user via winbindd.  This checks both authenticaion methods and reports its results.

       -A username%password
	      Store username and password used by winbindd during session setup to a domain controller. This enables winbindd to operate in a Win-
	      dows 2000 domain with Restrict Anonymous turned on (a.k.a. Permissions compatiable with Windows 2000 servers only).

EXIT STATUS

       The wbinfo program returns 0 if the operation succeeded, or 1 if the operation failed. If the winbindd(8) daemon is not working wbinfo will
       always return failure.

VERSION

       This man page is correct for version 2.2 of the Samba suite.

SEE ALSO

       winbindd(8)

AUTHOR

       The  original  Samba  software  and  related utilities were created by Andrew Tridgell. Samba is now developed by the Samba Team as an Open
       Source project similar to the way the Linux kernel is developed.

       wbinfo and winbindd were written by Tim Potter.

       The conversion to DocBook for Samba 2.2 was done by Gerald Carter

								 19 November 2002							 WBINFO(1)
All times are GMT -4. The time now is 09:03 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy