You need to make sure that the delimiter is NOT part of the data; I remember faintly ORACLE allows for that (set COLSEP ...). Then, you don't need a shell variable to hold the selection's interim result, try
i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement. (1 Reply)
I want to store the sql query output into a variable
#!/bin/ksh
ORACLE_SID=DB01;
export ORACLE_SID;
export FILE_PATH=/home/asg/Tmp
# Order Checking
echo " removing old files "
rm $FILE_PATH/Malformed_Order.txt
echo " Enter the Malformed Order ....!"
read orders
echo "Regrade... (5 Replies)
Hi,
I am currently filtering a file, "BUILD_TIMES", that has multiple column of information in it. An example of the data is as follows;
Fri Nov 5 15:31:33 2010 00:28:17 R7_BCGNOFJ_70.68
Fri Nov 5 20:57:41 2010 00:07:21 R7_ADJCEL_80.6
Wed Nov 10 17:33:21 2010 00:01:13 R7_BCTTEST3_80.1X... (7 Replies)
Say I have two tables like below..
status
HId sName dName StartTime EndTime
1 E E 9:10 10:10
2 E F 9:15 10:15
3 G H 9:17 10:00
logic
Id devName capacity free Line
1 E 123 34 1
2 E 345 ... (3 Replies)
Hello,
I am very new to shell scripting and I am not sure of how best to handle the following scenario. I need to query a list of values from a table. I need to store those results and use them to selectively delete values in yet another table in a separate database. I do know how to store the... (3 Replies)
Hello,
I would like to ask for help with csh script.
An example of an input in .txt file is below, the number of lines varies from file to file and I have 2 or 3 columns with values. I would like to read all the values (probably one by one) and set them to independent unique variables that... (7 Replies)
Is it possible to have a user input multiple words in one line and have the script assign each word a variable? I'm stuck please assist.
Example using "BILL JOHN SARA JILL" as what the user could type:
printf "Enter account names: " BILL JOHN SARA JILL
read input (9 Replies)
Hi,
I have a text file that has data like this
chr1 156106712 156106819 LMNA 8 + 1 147
chr1 156106712 156106819 LMNA 8 + 2 147
chr1 156106712 156106819 LMNA 8 + 3 148
chr1 ... (4 Replies)
Hello All,
just wanted to export multiple tables from oracle sql using unix shell script to csv file and the below code is exporting only the first table.
Can you please suggest why? or any better idea?
export FILE="/abc/autom/file/geo_JOB.csv"
Export= `sqlplus -s dev01/password@dEV3... (16 Replies)
Discussion started by: Hope
16 Replies
LEARN ABOUT OPENSOLARIS
tk_ownselection
Tk_OwnSelection(3TK) Tk Library Procedures Tk_OwnSelection(3TK)__________________________________________________________________________________________________________________________________________________NAME
Tk_OwnSelection - make a window the owner of the primary selection
SYNOPSIS
#include <tk.h>
Tk_OwnSelection(tkwin, selection, proc, clientData)
ARGUMENTS
Tk_Window tkwin (in) Window that is to become new selection owner.
Atom selection (in) The name of the selection to be owned, such as XA_PRIMARY.
Tk_LostSelProc *proc (in) Procedure to invoke when tkwin loses selection ownership later.
ClientData clientData (in) Arbitrary one-word value to pass to proc.
_________________________________________________________________DESCRIPTION
Tk_OwnSelection arranges for tkwin to become the new owner of the selection specified by the atom selection. After this call completes,
future requests for the selection will be directed to handlers created for tkwin using Tk_CreateSelHandler. When tkwin eventually loses
the selection ownership, proc will be invoked so that the window can clean itself up (e.g. by unhighlighting the selection). Proc should
have arguments and result that match the type Tk_LostSelProc:
typedef void Tk_LostSelProc(ClientData clientData);
The clientData parameter to proc is a copy of the clientData argument given to Tk_OwnSelection, and is usually a pointer to a data struc-
ture containing application-specific information about tkwin.
KEYWORDS
own, selection owner
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+-----------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+-----------------+
|Availability | SUNWTk |
+--------------------+-----------------+
|Interface Stability | Uncommitted |
+--------------------+-----------------+
NOTES
Source for Tk is available on http://opensolaris.org.
Tk 4.0 Tk_OwnSelection(3TK)