The approach typically taken here is to use the Oracle-provided sqlplus command-line client, with your SQL query embedded in-line inside your shell script.
So for example, something like this:
All of the above assumes you have a properly-configured Oracle command-line environment, there are already environment variables and/or config files in existence for the client that define the details of your Oracle database instance, and so on. Likewise, the options you SET depend entirely on what format you want your output in and how you want sqlplus to behave.
But in terms of demonstrating the general approach, the above gives you a fairly straightforward example that you can them customise. You may very well find you need to parse the output of the SQL query further in order to use it for whatever you want to do next, but hopefully this is enough to get you started.
I cannot figure out how to run a SQL script, or just a sqlplus query, from a shell script (bash or ksh). Basically, I need to su - oracle from root and run a query, then test the exit status. (3 Replies)
Hi there folks,
I am trying to execute remote sql queries on an Oracle server.
I would like to save the result of the executed sql queries on a text file, and send that text file as an attachment to an email address.
Could anyone give me an idea on how the above could be achieved? Any help... (2 Replies)
HI ALL
i have a requirement like this. i have to write a shell script to run a sql query. DB is oracle. once the query is run, the results of the query has to be published in a data file. can you please advice me how to go about it. i am absolutely new to shell scripts and this is a part of my job. (14 Replies)
Hi ALL,
I need an help in connecting to oracle database, executing a select query and printing it on the screen. Can any one please write a simple code or psuedo code and let me know.
select query returns multiple values( say select name from emp)
Thanks in advance
LM (1 Reply)
Hello,
I have a sh script excuting a sql query through sqlplus. I am having trouble making my date equal to the date of the server time in the sql script. How can i call the server date from my query?
Thanks (2 Replies)
I want to perform few post-session success tasks like update a status to 'true' in one of the sql database table, update date values to current system date in one of the configuration table in sql. How do i achieve this in a post session command?syntax with example will be helpful. (3 Replies)
Hi All,
I tried executing set of queries from shell script but not able to capture the input query in the log file. The code looks something similar to below
sqlplus user/pwd@dbname << EOF > output.log
$(<inputfile.txt)
EOF
The above code is capturing the output of queries into... (9 Replies)
Hi,
I have one SQL file prepared in UNIX and one script that is executing that.
In SQL i have Update and create queries.
I want to introduce conditions in SQL file (in UNIX) that if either of the create or update query failes whole transaction should be rollback.
I just have 1 create... (2 Replies)
Discussion started by: abhii
2 Replies
LEARN ABOUT DEBIAN
cscope-indexer
cscope-indexer(1) General Commands Manual cscope-indexer(1)NAME
cscope-indexer - Script to index files for cscope
SYNOPSIS
cscope-indexer [-v] [-f database_file] [-i list_file] [-l] [-r]
DESCRIPTION
This script generates a list of files to index (cscope.out), which is then (optionally) used to generate a cscope database. You can use
this script to just build a list of files, or it can be used to build a list and database. This script is not used to just build a data-
base (skipping the list of files step), as this can be simply done by just calling "cscope -b".
Normally, cscope will do its own indexing, but this script can be used to force indexing. This is useful if you need to recurse into sub-
directories, or have many files to index (you can run this script from a cron job, during the night). It is especially useful for large
projects, which can contstantly have source files added and deleted; by using this script, the changing sources files are automatically
handled.
Currently, any paths containing "/CVS/" or "/RCS/" are stripped out (ignored).
OPTIONS -f database_file
Specifies the cscope database file (default: cscope.out).
-i list_file
Specifies the name of the file into which the list of files to index is placed (default: cscope.files).
-l Suppress the generation/updating of the cscope database file. Only a list of files is generated.
-r Recurse into subdirectories to locate files to index. Without this option, only the current directory is searched.
-v Be verbose. Output simple progress messages.
SEE ALSO cscope(1)AUTHOR
This manual page was written for the Debian GNU/Linux system by Robert Lemmen <robertle@semistable.com> (but may be used by others, of
course)
Script to index files for cscope 30. December 2002 cscope-indexer(1)