04-20-2011
Well, to call a shell from a RDBMS engine is tricky, as it runs under the DB id, so be careful.
Maybe you should share the context with us. A hit on a table is a select of any row. If the table is really a view of a sp, the sp can call a udf to do anything you can write, once either for each row or for the whole select. So, you could log to track id's selecting each row or anywhere in the table.
10 More Discussions You Might Find Interesting
1. Shell Programming and Scripting
i want to call a oracle function in my shell script (4 Replies)
Discussion started by: dineshr85
4 Replies
2. Shell Programming and Scripting
i have a function written in one shell script and i want to call that function in another shell script and use the value returned by that script.
can any one suggest me how can i do that?
regards,
Rajesh.P (4 Replies)
Discussion started by: rajesh.P
4 Replies
3. UNIX for Dummies Questions & Answers
I have the following code for installing a BSD application stack:
#!/bin/sh
# install dos2unix and unix2dos utilities
echo `date "+%Y-%m-%d %H:%M:%S"` "unix2dos and dos2unix: installing..." >> ~/post_install.log
pkg_add -r unix2dos
# install xfce4 desktop environment
echo `date "+%Y-%m-%d... (3 Replies)
Discussion started by: figaro
3 Replies
4. Shell Programming and Scripting
Here is the following code :
1.
# gcc -c test firstprog.c
the above command will generate a executable file called "test " in which ever directory it is run.
Assuming It will also return a value.
2. In the below SCRIPT . test is a file generated by compiling a c program... (3 Replies)
Discussion started by: Vabiosis
3 Replies
5. Red Hat
please help me in this script
shell script :1
***********
>cat file1.sh
#!/bin/bash
echo "this is first file"
function var()
{
a=10
b=11
}
function var_1()
{
c=12
d=13 (2 Replies)
Discussion started by: ponmuthu
2 Replies
6. Shell Programming and Scripting
#!/bin/bash
FUN_ECHO(){
echo $1
}
FUN_ECHO "hi how are you ?"
This code will work fine.
BUT is it possible to make the following to work ?
FUN_ECHO "hi how are you ?"
FUN_ECHO(){
echo $1
}
I know that the code will be executed line by line. But i have a number of... (5 Replies)
Discussion started by: linuxadmin
5 Replies
7. Shell Programming and Scripting
Hi I have a function :
Make_Report()
{
trx_report=`sqlplus -s $conn_str << @@
set echo off;
set pages 0;
set feedback off;
set verify off;
select srv_trx_s_no,... (1 Reply)
Discussion started by: neeraj617
1 Replies
8. Shell Programming and Scripting
I am getting Segmentation fault at below function call in my script:
get_x() {
sqlplus -s / <<end | grep KEEP | sed 's/KEEP//;s///g'
select 'KEEP' ,table_name from all_synonyms where upper(synonym_name)= '$1';
exit
end
x=$(get_x $1)
echo " SQL OUTPUT IS :: $x"
}
I am getting output of... (1 Reply)
Discussion started by: IB_88
1 Replies
9. Shell Programming and Scripting
Dear All,
I want to know how can i call oracle function from shell script code . My oracle function have around 5 input parameters and one return value.
for name in *.csv;
do
echo "connecting to DB and start processing '$name' file at "
echo "csv file name=$x"
sqlplus -s scoot/tiger <!... (2 Replies)
Discussion started by: Balraj
2 Replies
10. Shell Programming and Scripting
I am converting shell script to Perl. In shell I have a code
parse_prog_args()
{
if
then
while
do
case $1 in
-P* | -p* )
export PROCESS_DATE=$2
export MM=`echo $2 | cut -c5-6`
export DD=`echo $2 | cut -c7-8`
export YY=`echo $2 | cut -c3-4`
export... (4 Replies)
Discussion started by: digioleg54
4 Replies
LEARN ABOUT OPENSOLARIS
mysqlshow
mysqlshow(1) MySQL database mysqlshow(1)
NAME
mysqlshow
- Shows the structure of a mysql database (databases,tables and columns)
USAGE
shell> mysqlshow [OPTIONS] [database [table [column]]]
SYNOPSIS
mysqlshow [-#|--debug=...] [-?|--help] [-c|--character-sets-dir=...] [-C|--compress] [-h|--host=...] [-i|--status] [-k|--keys]
[-p|--password[=...]] [-P|--port=...] [-S|--socket=...] [-u|--user=#] [-V|--version]
DESCRIPTION
-#|--debug=...
output debug log. Often this is 'd:t:o,filename`
-?|--help
display help and exit
-c|--character-sets-dir=...
Directory where character sets are
-C|--compress
Use compression in server/client protocol
-h|--host=...
connect to host
-i|--status
Shows a lot of extra information about each table
-k|--keys
show keys for table
-p|--password[=...]
password to use when connecting to server If password is not given it's asked from the tty.
-P|--port=...
Port number to use for connection
-S|--socket=...
Socket file to use for connection
-u|--user=#
user for login if not current user
-V|--version
output version information and exit
NOTE
If last argument contains a shell or SQL wildcard (*,?,% or _) then only what's matched by the wildcard is shown. If no database is given
then all matching databases are shown. If no table is given then all matching tables in database are shown If no column is given then all
matching columns and columntypes in table are shown
SEE ALSO
isamchk(1), isamlog(1), mysql(1), mysqlaccess(1), mysqladmin(1), mysqld(1), mysqld_multi(1), mysqld_safe(1), mysqldump(1), mysql_fix_privi-
lege_tables(1), mysql_zap(1), perror(1), replace(1)
For more information please refer to the MySQL reference manual, which may already be installed locally and which is also available online
at http://www.mysql.com/doc/en/
BUGS
Please refer to http://bugs.mysql.com/ to report bugs.
AUTHOR
Ver 1.0, distribution 4.0.24 Michael (Monty) Widenius (monty@mysql.com), MySQL AB (http://www.mysql.com/). This software comes with no
warranty. Manual page by L. (Kill-9) Pedersen (kill-9@kill-9.dk), Mercurmedia Data Model Architect / system developer (http://www.mercur-
media.com)
ATTRIBUTES
See attributes(5) for descriptions of the following attributes:
+--------------------+------------------------------------+
| ATTRIBUTE TYPE | ATTRIBUTE VALUE |
+--------------------+------------------------------------+
|Availability | SUNWmysqlr, SUNWmysqlu, SUNWmysqlt |
+--------------------+------------------------------------+
|Interface Stability | External |
+--------------------+------------------------------------+
NOTES
Source for mysql is available on http://opensolaris.org.
MySQL 4.0 19 December 2000 mysqlshow(1)