How to create a for loop statement for removing files listed in Oracle table? Post: 302979347

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

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

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!

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

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

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?

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

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

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

LEARN ABOUT PHP

dbx_escape_string

DBX_ESCAPE_STRING(3)							 1						      DBX_ESCAPE_STRING(3)

dbx_escape_string - Escape a string so it can safely be used in an sql-statement

SYNOPSIS

       string dbx_escape_string (object  $link_identifier, string  $text)

DESCRIPTION

	Escape the given string so that it can safely be used in an sql-statement.

PARAMETERS

	      o $link_identifier
		- The DBX link object returned by dbx_connect(3)

	      o $text
		- The string to escape.

RETURN VALUES

	Returns the text, escaped where necessary (such as quotes, backslashes etc). On error, NULL is returned.

EXAMPLES

       Example #1

	      dbx_escape_string(3) example

	      <?php
	      $link   = dbx_connect(DBX_MYSQL, "localhost", "db", "username", "password")
		  or die("Could not connect");

	      $text = dbx_escape_string($link, "It's quoted and backslashed (\).");
	      $result = dbx_query($link, "insert into tbl (txt) values ('" . $text . "')");
	      if ($result == 0) {
		  echo dbx_error($link);
	      }
	      dbx_close($link);
	      ?>

SEE ALSO

       dbx_query(3).

PHP Documentation Group 												      DBX_ESCAPE_STRING(3)

9 More Discussions You Might Find Interesting

1. HP-UX

CVSWeb - Directories listed but files not listed

Discussion started by: ganesh

2. HP-UX

to create a oracle table in perl script

Discussion started by: megh

3. Shell Programming and Scripting

[ORACLE] CREATE TABLE in bash

Discussion started by: radek

4. Shell Programming and Scripting

Check the record count in table (table in oracle)

Discussion started by: kamineni

5. Shell Programming and Scripting

Check the record count in table (table in oracle)

Discussion started by: kamineni

6. UNIX for Dummies Questions & Answers

create table file from different files with index

Discussion started by: sargotrons

7. Shell Programming and Scripting

how to create a loop in an if statement

Discussion started by: jaituteja

8. Shell Programming and Scripting

Create table within awk-if statement

Discussion started by: sidnow

9. Shell Programming and Scripting

Script to create the SQLLDR control file from Oracle table.

Discussion started by: pimmit22043

LEARN ABOUT PHP

dbx_escape_string