08-12-2011
Shell script to export data from Oracle table .
Hi,
I want to write a shell script which will export data from oracle table .
I don't want to save that data . I want the queries .
Right now i am right clicking on the table and clicking on export as to my desktop .
Please let me know if any one have any idea .
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i would like to export a particular table in my oracle database installed in a hpux box. i would like to determine the filesize of the output before performing these action so i can assess if my harddisk can still handle it.
thanks as usuall :rolleyes: (1 Reply)
Discussion started by: inquirer
1 Replies
2. Shell Programming and Scripting
Hi,
I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure)
While the command is running,I am able to view the log file created in the Unix machine.After the command... (2 Replies)
Discussion started by: ann_124
2 Replies
3. Shell Programming and Scripting
Hello people,
Need favour. The problem I have is that, I need to develop a unix shell script that performs recurring exports of data from a csv file to an oracle database. Basically, the csv file contains just the first name and last name will be dumped to an Unix server. The data from these... (3 Replies)
Discussion started by: vinayagan
3 Replies
4. Shell Programming and Scripting
Hi All,
I need to write a shell script(ksh) to take the tables backup in oracle(exporting tables data).
The tables list is not static, and those are selecting through dynamic sql
query. Can any body help how to write this shell script.
Thanks, (3 Replies)
Discussion started by: sankarg
3 Replies
5. Shell Programming and Scripting
Hello Gurus,
I've been tasked with solving a problem at my new job and I'm stumped. We've got a script that dynamically builds an oracle export parameter files and then runs export from the shell. it runs fine when using the shell, but will NOT run (fails in one spot everytime) when entered... (1 Reply)
Discussion started by: jsheehan223
1 Replies
6. Shell Programming and Scripting
Hi,
I have a case where i am connecting to the oracle DB and reading a column value....
Script is in production...it was running fine,,,but suddenly now some times its started giving pain....
Script runs dailly....but sometimes its reading data from Oracle DB and sometimes its not rading the... (2 Replies)
Discussion started by: Sagarddd
2 Replies
7. Shell Programming and Scripting
Hi ,
I would like to get some suggestion from the experts.
My requirement is to export oracle table data as an xml file.
Any unix/linux tools, scripts available?
Regards, (2 Replies)
Discussion started by: LinuxLearner
2 Replies
8. Shell Programming and Scripting
Hi, unix gurnis
I need help for following requirement for writing a shell scritp.
log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file.
Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies
9. Shell Programming and Scripting
Hi,
I want to write a shell script which connect to my database with the following credentials :
User name : user
PWD : rap_user_1
Hostname : app.Unix.Gsm1900.Org
Port : 7862
SID : PTNC1
Once connected to DB i want to fetch data with the help of a SQL statement and expoet... (4 Replies)
Discussion started by: neeraj617
4 Replies
10. Shell Programming and Scripting
I have 100 Scripts, each containing 10-15 SQL's in them.
Each Script run for 40 mins to 1 hour 30 mins.
In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the... (7 Replies)
Discussion started by: kiran1992
7 Replies
GCIN(1) gcin input method platform GCIN(1)
NAME
gcin - an input method server
SYNOPSIS
gcin [-h|-v|--version]
DESCRIPTION
gcin is an input method(IM) server, which focused mainly on Traditional Chinese. It is also very useful for Simplified Chinese, Japanese,
and many other languages. IM table format of gcin is almost as same as those of scim and xcin. Users may append their IMs to gcin very eas-
ily. The "g" of gcin means that it features a better GTK+ user interface.
If you are looking for configuration tool of gcin, please see the manpage of gcin-tools.
OPTIONS
-h, -v, --version
Show version of gcin.
FILES
/usr/share/gcin/table/gtab.list
Input methods available for gcin. You may copy it to $HOME/.gcin/ and edit it as you like. If you have no $HOME/.gcin/gtab.list,
/usr/share/gcin/table/gtab.list will be used.
/usr/share/gcin/script/html-browser
A file helps gcin finding html browsers when needed. You may add any compatible html browser to it.
/usr/share/gcin/script/utf8-edit
A file helps gcin finding text editors when needed. You may add any UTF-8 compatible text editor to it.
ENVIRONMENT VARIABLES
LC_CTYPE
For bash: export LC_CTYPE=zh_TW.UTF-8
For csh: setenv LC_CTYPE zh_TW.UTF-8
XMODIFIERS
For bash: export XMODIFIERS=@im=gcin
For csh: setenv XMODIFIERS @im=gcin
GTK_IM_MODULE
For bash: export GTK_IM_MODULE=gcin
For csh: setenv GTK_IM_MODULE gcin
QT_IM_MODULE
For bash: export QT_IM_MODULE=gcin
For csh: setenv QT_IM_MODULE gcin
GCIN_CONNECT_MSG_ON
Display messages for socket connections.
GCIN_DBG_TMP
Display additional debug messages.
GCIN_ERR_COREDUMP
Option for debugging.
GCIN_IM_CLIENT_NO_AUTO_EXEC
Disable auto-evoke in gcin protocol.
GCIN_OUTPUT_FILTER
Assign output filter to process data before the IM server send them to clients.
GCIN_TABLE_DIR
Assign directory for IM tables other then /usr/share/gcin/table.
SEE ALSO
gcin-tools(1), gcin2tab(1), phoa2d(1), juyin-learn(1), gcin-message(1)
AUTHORS
Edward Der-Hua Liu
Wrote gcin and associated tools.
Friend of Chanjei IM, Malaysia <www.chinesecj.com>
Author of original Chanjei IM version 5 table.
Dayi Co., Ltd. <http://www.dayi.com>
Author of Dayi IM.
GCIN 1.4.4 2 FEB 2008 GCIN(1)