Help shell script to loop through files update ctl file to be sql loaded Post: 302185750

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are 1. The Control file name(.ctl file) 2. The Data file name(.csv file) Does anybody have an idea about it? :confused:

2. Shell Programming and Scripting

Executing Multiple .SQL Files from Single Shell Script file

Hi, Please help me out. I have around 700 sql files to execute in a defined order, how can i do it from shell script

3. Linux

perl update while script is loaded

Hi All, What will happen to the perl script loaded on the memory if I do perl update? Thanks.

4. Shell Programming and Scripting

how to call shell script from pl/sql loop

Hello, I am doing a shell script which contain a pl/sql loop to search for 3 values, i would like to call another shell script inside this sql loop each time it find the values. so how can i call shell script from pl/sql using its variables, any idea? Here is idea about the code: my...

5. Shell Programming and Scripting

shell script to run .sql files

hi Friends, Please help me in writing shell script to run list of sql files. database is Oracle 9i, unix os is solaris Requirement is 1. sql file must take two inputs a)feed id and b)business date 2.shell script must out put .xls or .csvfile as out put without trimming any column name and...

6. Shell Programming and Scripting

How to retrieve all the linked script files/ctl files/sql files?

Hi I am going to migrate our datawarehouse system from HP Tru 64 Unix to the Red Hat Linux. Inside the box, it is running around 40 cron jobs; inside each cron job, it is calling other shell script files, and the shell script files may again call other shell script files or ctl files(for...

7. Shell Programming and Scripting

how to pass a variable to an update sql statement inside a loop

hi all, i am experiencing an error which i think an incorrect syntax for the where clause passing a variable was given. under is my code. sqlplus -s ${USERNAME}/${PASSWORD}@${SID} << END1 >> $LOGFILE whenever sqlerror exit set serveroutput on size 1000000 declare l_rc ...

8. Shell Programming and Scripting

Shell script to perform appending of .sql files

Hi, We are having multiple .sql files generated programatically which is not containing.. create or replace -- at the start and / -- at the end We need to append those .sql files with the above 2 statements at their respective positions. We will be really thankful to get responses...

9. Shell Programming and Scripting

Oop to copy and rename files through SQL Statement in shell Script

#!/bin/sh sqlplus -s "/ as sysdba" << EOF SET HEADING OFF SET FEEDBACK OFF Select pt.user_concurrent_program_name , OUTFILE_NAME FROm apps.fnd_concurrent_programs_tl pt, apps.fnd_concurrent_requests f where pt.concurrent_program_id = f.concurrent_program_id and pt.application_id =...

10. Shell Programming and Scripting

How to execute 10 sql files from a folder through sqlplus in shell script?

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...

LEARN ABOUT DEBIAN

rpld-stop

rpld-*(1)					       System User's Manual: rpld-deprecated						 rpld-*(1)

NAME

       rpld-deprecated - Deprecated RoarAudio PlayList Daemon control programs

SYNOPSIS

       rpld-play

       rpld-stop

       rpld-next [--ifcurple PLE]

       rpld-prev

       rpld-addplaylist PLI

       rpld-delplaylist PLI

       rpld-store

DESCRIPTION

       The  RoarAudio  PlayList  Daemon is a daemon which manages playlists and can play files or streams from those lists using a RoarAudio Sound
       Server.

       This is a set of deprecated tools to do simple control of the server.  All those tools has be replaced by rpld-ctl(1).

       The following tools are deprecated:

       rpld-play
	      Start playback if not yet started.

	      Replaced by: rpld-ctl play

       rpld-stop
	      Stop playback.

	      Replaced by: rpld-ctl stop

       rpld-next [--ifcurple PLE]
	      Skip current song.

	      if --ifcurple and a PLE is given the song is only skiped if the currently played song matches the given PLE.

	      This tool has only been deprecated in case --ifcurple is not used.  Replaced by: rpld-ctl next

       rpld-prev
	      Go back to previous song.

	      Replaced by: rpld-ctl prev

       rpld-addplaylist PLI
	      Add playlist with name PLI.

	      Replaced by: rpld-ctl addplaylist PLI

       rpld-delplaylist PLI
	      Delete playlist PLI.

	      Replaced by: rpld-ctl delplaylist PLI

       rpld-store
	      Store current state to disk.

	      This tool should not be needed to be called by a user at all for normal use cases.

	      Replaced by: rpld-ctl store

SEE ALSO

       rpld-tools(1), rpld(7), RoarAudio(7).

HISTORY

       For history information see RoarAudio(7).

rpld-deprecated 						     May 2012								 rpld-*(1)

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Shell Script to Load data into the database using a .csv file and .ctl file

Discussion started by: Csmani

2. Shell Programming and Scripting

Executing Multiple .SQL Files from Single Shell Script file

Discussion started by: anushilrai

3. Linux

perl update while script is loaded

Discussion started by: itik

4. Shell Programming and Scripting

how to call shell script from pl/sql loop

Discussion started by: rosalinda