|
|
Sponsored Content
Top Forums
UNIX for Beginners Questions & Answers
How to use for loop to execute multiple .sql files while using SQLPLUS for db connection.?
Post 303031876 by RudiC on Thursday 7th of March 2019 03:40:04 AM
03-07-2019
|
|
10 More Discussions You Might Find Interesting
1. AIX
hi everybody,
i am Talip, a begginner at unix based systems and i have a problem (actually, we may think myself as the problem, in this situation).
i am not sure if this is the correct platform for my questions. if it is not please forgive me about this inappropriate mail.
what i have:
*... (2 Replies)
Discussion started by: talipk
2 Replies
2. Shell Programming and Scripting
Hi All,
Please help me to write a shell script to execute the below sql query.
select c.account_no,b.bill_no,a.pay_type,(b.total_due + b.recvd + b.adjusted + b.disputed + b.transferred) as amt_not_billed,d.cash_on_delivery,
(select j.bill_no from
billinfo_T y,
bill_t j
where... (1 Reply)
Discussion started by: girish.raos
1 Replies
3. UNIX for Dummies Questions & Answers
Hello,
I have a set of input data that I split into batches using the following command:
split -l 4000000 MyInput.in Split_a
Once I get the split files, I run a certain command on the split files that spews an output. So far I have been doing it without a for loop. How can I translate the... (2 Replies)
Discussion started by: Gussifinknottle
2 Replies
4. Shell Programming and Scripting
Hi!
I would like to do a single connection to sqlplus and execute some querys.
Actually I do for every query one connection to database
i.e
echo 'select STATUS from v$instance;
exit' > $SQL_FILE
sqlplus user/pass@sid @$SQL_FILE > $SELECT_RESULT
echo 'select VERSION from v$instance;... (6 Replies)
Discussion started by: guif
6 Replies
5. Shell Programming and Scripting
Hi,
I'm trying to build a shell script that reads a set of accounts from a file. For each account I need to perform a set of sql queries. So I have a loop with a set of sqlplus connections to retrieved my data.
Is it possible to have a single sqlplus connection before entering the loop and... (4 Replies)
Discussion started by: lsantacana
4 Replies
6. UNIX and Linux Applications
using sqlplus I want to execute a .sql script that has dbms_output statments in rhe script. I want to write the dbms_output statements from .sql file to a log file. is this possible. thanks
any help would be appreciated
:wall: (1 Reply)
Discussion started by: TRS80
1 Replies
7. Shell Programming and Scripting
Dear All,
I am trying to write a Unix Script which fires a sql query. The output of the sql query gives multiple rows. Each row should be saved in a separate Unix File.
The number of rows of sql output can be variable. I am able save all the rows in one file but in separate files.
Any... (14 Replies)
Discussion started by: Rahul_Bhasin
14 Replies
8. Shell Programming and Scripting
Hi,
I am new to shell scripting and i need to write a automation script to execute sql files. I need to check the table if it is there in system tables and need to write a function to call the .sql files.
For ex. I have a.sql,b.sql,c.sql files, where the sql file contains DELETE and INSERT... (1 Reply)
Discussion started by: Samah
1 Replies
9. Shell Programming and Scripting
How to execute multiple files in multiple folders and also output to be generated in the same folder?
Hello Team,
I have a path like Sanity_test/*/* and it has around 100+ folders inside with files. I would like to run/execute those files and output of execution to be placed on same /... (1 Reply)
Discussion started by: pushpabuzz
1 Replies
10. Shell Programming and Scripting
I am new to shell scripting and i want to know how to execute the *.sql files from a folder through sqlplus in shell script and files should be execute in sequentially one by one while execution if any ORA error it has to exit from sqlplus session
1) scripts from external folder
2) logs has... (1 Reply)
Discussion started by: sreekanth Reddy
1 Replies
LEARN ABOUT SUNOS
gst-register-0.8
gst-register-0.8(1) User Commands gst-register-0.8(1) NAME
gst-register-0.8, gst-register - register GStreamer plugins SYNOPSIS
gst-register-0.8 [gst-std-options] gst-register [gst-std-options] [--gst-list-mm] [--gst-mm=string] [--print] DESCRIPTION
gst-register-0.8 registers all of the GStreamer plugins on your system. gst-register-0.8 creates a listing of their properties so that on startup of GStreamer-based applications, you do not need to load plugins until you need them. When run as the root user, gst-register-0.8 creates the Global GStreamer plugin registry which is stored in /var/cache/gstreamer-X.X/reg- istry.xml, where X.X is the GStreamer major and minor version number. When run as a user other than the root user, gst-register-0.8 creates a user registry ~/.gstreamer-X.X/registry.xml, where X.X is the GStreamer major and minor version number. Programs that uses GStreamer use the user plugin registry if it exists, and use the Global plugin registry if not. gst-register is a wrapper script that runs the latest installed version of gst-register-X.X. For example, if both gst-register-0.7 and gst- register-0.8 are installed on your system, gst-register runs gst-register-0.8. OPTIONS
The following options are supported by gst-register-0.8 and gst-register: gst-std-options Standard options available for use with most GStreamer applications. See gst-std-options(5) for more information. The following options are supported by gst-register only: --gst-list-mm List found major/minor versions. This option displays the versions that are available. --gst-mm=string Force major/minor version. This option enables you to specify a specific version to run, if you do not want to run the default version. --print Print wrapped command line. This option displays the command that will be run, and then runs the command. EXAMPLES
Example 1: Running the Wrapper Script and Displaying the Command Name example% gst-register --print /usr/bin/gst-register-0.8 FILES
The following files are used by this application: /usr/bin/gst-register-0.Executable to register GStreamer plugins /usr/bin/gst-register Wrapper script that runs the latest installed version of gst-register-X.X /var/cache/gstreamer-X.XGStreamer.global plugin registry, where X.X is the GStreamer major and minor version number. ~/.gstreamer-X.X/registrGStreamer user plugin registry, where X.X is the GStreamer major and minor version number. ATTRIBUTES
See attributes(5) for descriptions of the following attributes: +-----------------------------+-----------------------------+ | ATTRIBUTE TYPE | ATTRIBUTE VALUE | +-----------------------------+-----------------------------+ |Availability |SUNWgnome-media | +-----------------------------+-----------------------------+ |Interface stability |External | +-----------------------------+-----------------------------+ SEE ALSO
gst-complete(1), gst-compprep(1), gst-feedback(1), gst-inspect(1), gst-launch(1), gst-launch-ext(1), gst-md5sum(1), gst-thumbnail(1), gst- typefind(1), gst-xmlinspect(1), gst-xmllaunch(1), gstreamer-properties(1), libgstreamer-0.8(3), libgstgetbits(3), gst-std-options(5) NOTES
Original man page written by the GStreamer team at http://gstreamer.net/. Updated by Brian Cameron, Sun Microsystems Inc., 2004. SunOS 5.10 14 Oct 2004 gst-register-0.8(1)