Login or Register to Ask a Question and Join Our Community

Sponsored Content
Full Discussion: How to create a for loop statement for removing files listed in Oracle table?
Top Forums Shell Programming and Scripting How to create a for loop statement for removing files listed in Oracle table? Post 302979266 by manisha_singh on Thursday 11th of August 2016 08:57:39 PM
Old 08-11-2016
Thank you for your reply. My sql query is very simple. select filename from a_table. There are like 45 files, taking that filename, I have to run 'rm' command a shell script.

---------- Post updated at 07:57 PM ---------- Previous update was at 07:55 PM ----------

Thank you for your reply. My SQL query is very simple. select filename from a_table. There are like 45 files, taking that filename, I have to run 'rm' command a shell script. How can I put a for loop in this command?
 

9 More Discussions You Might Find Interesting

1. HP-UX

CVSWeb - Directories listed but files not listed

I am using CVSWeb on HPUnix. When i access it, all directories are listed but files are not listed. I am getting the error "NOTE: There are 51 files, but none matches the current tag. " in tomcat sevrer log i am getting the message "rlog warning: Missing revision or branch number after -r"... (0 Replies)
Discussion started by: ganesh
0 Replies

2. HP-UX

to create a oracle table in perl script

Hi all, I have to create table for each month inside a perl script. tablename_monthnameyear. megh_aug2008 for august 2008. megh_sep2008 for september 2008. just like the logfiles created on date basis. thanks megh (1 Reply)
Discussion started by: megh
1 Replies

3. Shell Programming and Scripting

[ORACLE] CREATE TABLE in bash

Hey, I want to create a table in bash, my db server is oracle. You can find my script below: I am very confused. I tried to run this script many times without any luck. Please help! (6 Replies)
Discussion started by: radek
6 Replies

4. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time (Go to sleep mode) and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

5. Shell Programming and Scripting

Check the record count in table (table in oracle)

I have requirement: 1) Check the record count in table (table in oracle) 2) If records exists generate the file for existing records and wait for some time then Go to sleep mode and Again check the record count after 10 min.......... (Loop this process if record count >0). 3) Generate touch... (1 Reply)
Discussion started by: kamineni
1 Replies

6. UNIX for Dummies Questions & Answers

create table file from different files with index

Hi, I've several files with two collumns, where first collumn can be used as index. filename1 and filename2 how to create a file I should start with cat all files and extract first collumn to create an index? (4 Replies)
Discussion started by: sargotrons
4 Replies

7. Shell Programming and Scripting

how to create a loop in an if statement

Hey guys, a=`cat abc | wc -l` b=`cat def | wc -l` if $a== $b then echo "a" else echo "b" fi I want the if condition to retry itself , untill a==b. I can't use goto statemt. Please help. Thanx in advance. Please use next time code tags for your code and data (5 Replies)
Discussion started by: jaituteja
5 Replies

8. Shell Programming and Scripting

Create table within awk-if statement

Hi I am trying to create a table within an awk if statement awk -F, '{ if ($8 ~ /Match/) BEGIN{print "<table>"} {print "<tr>";for(i=1;i<=NF;i++)print "<td>" $i"</td>";print "</tr>"} END{print "</table>"}' SN1.csv | mailx -s "Your details" abc@123.com But this doesnt work.. Please suggest (8 Replies)
Discussion started by: sidnow
8 Replies

9. Shell Programming and Scripting

Script to create the SQLLDR control file from Oracle table.

I need to create the shell script load the few 100 table using the SQLLDR. Need to generate the control file for each table using oracle table. table has "table names" and "column names" using this need create the control file. example table rows below table_nme column_nme DEPT ... (2 Replies)
Discussion started by: pimmit22043
2 Replies

LEARN ABOUT BSD

makedev

MAKEDEV(8)						      System Manager's Manual							MAKEDEV(8)

NAME

       makedev - make system special files

SYNOPSIS

       /dev/MAKEDEV device...

DESCRIPTION

       MAKEDEV is a shell script normally used to install special files.  It resides in the /dev directory, as this is the normal location of spe-
       cial files.  Arguments to MAKEDEV are usually of the form device-name?  where device-name is one of the supported devices listed in section
       4  of  the  manual and ``?'' is a logical unit number (0-9).  A few special arguments create assorted collections of devices and are listed
       below.

       std    Create the standard devices for the system; e.g. /dev/console, /dev/tty.	The VAX-11/780 console	floppy	device,  /dev/floppy,  and
	      VAX-11/750 and VAX-11/730 console cassette device(s), /dev/tu?, are also created with this entry.

       local  Create  those  devices specific to the local site.  This request causes the shell file /dev/MAKEDEV.local to be executed.  Site spe-
	      cific commands, such as those used to setup dialup lines as ``ttyd?'' should be included in this file.

       Since all devices are created using mknod(8), this shell script is useful only to the super-user.

DIAGNOSTICS

       Either self-explanatory, or generated by one of the programs called from the script.  Use ``sh -x MAKEDEV'' in case of trouble.

SEE ALSO

       intro(4), config(8), mknod(8)

4.2 Berkeley Distribution					   May 19, 1986 							MAKEDEV(8)
All times are GMT -4. The time now is 10:51 AM.
Unix & Linux Forums Content Copyright 1993-2022. All Rights Reserved.
Privacy Policy