hello
how to run shell script to excute oracle queries on remote db ?
i have tried as following
sqlplus -s user/password@remote_server "select query;"
but not working
also this one
sqlplus -s user/password@remote_server `select query;`
not working :(
i add this line to run another... (4 Replies)
Hello,
If I run this command on the server it works.
# dbc "update config set radio_enabled = 0;"
how can I execute the same command in perl. I have defined the dbc path. Can any one please correct the last line.
#!/usr/bin/perl
#database path
$dbc='/opt/bin/psql -Userver... (0 Replies)
Hi,
I need to run sql query in shell script after getting connected to ssh. For that I connected to ssh through shell script using RSA keys done]. Now when I am running sql query, it's not working... but several other commands like 'ls'. 'mkdir', etc are working properly.
Here is my code:
... (2 Replies)
I need to run sql script from shell script which takes the input from a file and contents of file will be like :
12345
34567
78657
and query will be like :
select seq_nbr from bus_event where event_nbr='12345';
select seq_nbr from bus_event where event_nbr='34567';
select seq_nbr... (1 Reply)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
Hi, this's Pom. I'm quite a new one for shell script but I have to do sql on shell script to query some information from database.
I found a concern to get a new line...When I run my script, it retrieves all data as wondering but it's shown in one line :(
What should I do? I'm not sure that... (2 Replies)
Hi,
I have a query regarding execution of a sql query having long listing of parameters ..I need to execute this query inside a shell script.
The scenario is like....
Suppose I have a file abc.txt that has the card numbers..it could be in thousands..
then I need to fire a query like
... (12 Replies)
I am running this test.ksh on server1. It successfully logins to server2 but runs the queries of query.sql on server1. query.sql is present in both server1 and server2
Can anybody please help.
I need to run queries on server2 itself.:confused:
Below is the test script... (10 Replies)
I want to run sql query in shell script and output data save as delimited text (delimited text would be comma)
Code:
SPOOL_FILE=/pgedw/dan.txt
SQL=/pgedw/dan.sql
sqlplus -s username/password@myhost:port/servicename <<EOF
set head on
set COLSEP ,
set linesize 32767
SET TRIMSPOOL ON
SET... (8 Replies)
Discussion started by: Jaganjag
8 Replies
LEARN ABOUT DEBIAN
m17ndebug
Debugging(3m17n) The m17n Library Debugging(3m17n)NAME
Debugging - Support for m17n library users to debug their programs.
Functions
MCharTable * mdebug_dump_chartab (MCharTable *table, int indent)
Dump a chartable.
MFace * mdebug_dump_face (MFace *face, int indent)
Dump a face.
MFont * mdebug_dump_font (MFont *font)
Dump a font.
MFontset * mdebug_dump_fontset (MFontset *fontset, int indent)
Dump a fontset.
MInputMethod * mdebug_dump_im (MInputMethod *im, int indent)
Dump an input method.
int mdebug_hook ()
Hook function called on an error.
MText * mdebug_dump_mtext (MText *mt, int indent, int fullp)
Dump an M-text.
MPlist * mdebug_dump_plist (MPlist *plist, int indent)
Dump a property list.
MSymbol mdebug_dump_symbol (MSymbol symbol, int indent)
Dump a symbol.
MSymbol mdebug_dump_all_symbols (int indent)
Dump all symbol names.
Detailed Description
Support for m17n library users to debug their programs.
The m17n library provides the following facilities to support the library users to debug their programs.
o Environment variables to control printing of various information to stderr.
o MDEBUG_INIT -- If set to 1, print information about the library initialization on the call of M17N_INIT().
o MDEBUG_FINI -- If set to 1, print counts of objects that are not yet freed on the call of M17N_FINI().
o MDEBUG_CHARSET -- If set to 1, print information about charsets being loaded from the m17n database.
o MDEBUG_CODING -- If set to 1, print information about coding systems being loaded from the m17n database.
o MDEBUG_DATABASE -- If set to 1, print information about data being loaded from the m17n database.
o MDEBUG_FONT -- If set to 1, print information about fonts being selected and opened.
o MDEBUG_FLT -- If set to 1, 2, or 3, print information about which command of Font Layout Table are being executed. The bigger number
prints the more detailed information.
o MDEBUG_INPUT -- If set to 1, print information about how an input method is running.
o MDEBUG_ALL -- Setting this variable to 1 is equivalent to setting all the above variables to 1.
o MDEBUG_OUTPUT_FILE -- If set to a file name, the above debugging information is appended to the file. If set to 'stdout', the
information is printed to stdout.
o Functions to print various objects in a human readable way. See the documentation of mdebug_dump_XXXX() functions.
o The hook function called on an error. See the documentation of mdebug_hook().
Author
Generated automatically by Doxygen for The m17n Library from the source code.
COPYRIGHT
Copyright (C) 2001 Information-technology Promotion Agency (IPA)
Copyright (C) 2001-2011 National Institute of Advanced Industrial Science and Technology (AIST)
Permission is granted to copy, distribute and/or modify this document under the terms of the GNU Free Documentation License
<http://www.gnu.org/licenses/fdl.html>.
Version 1.6.2 12 Jan 2011 Debugging(3m17n)