SQLPLUS and update statements using bind variables Post: 302132679

6 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

put value of multiple sql statements into unix variables

i want to use multple sql count statements and store these count values in unix variable but in one connection only i.e. in only 1 time database should be hit ,which is the main requirement.

2. Shell Programming and Scripting

stored procoedure bind variables in shell

Hi , I have a pl/sql procedure which takes its input from a shell script, and deletes rows from db table based on the input. I've dbms_output.put_line statments in procedure which i want to capture and display in the script for example, if no rows have been deleted, i have to stop executing...

3. Shell Programming and Scripting

sqlplus update issue

Hi all, I'm facing a problem with a query in a shell script (AIX). sqlplus -s NAME/PASS@SCHEMA<<EOF set echo off UPDATE HISTORY SET HISTORY.ID = (SELECT OFFER.ID FROM OFFER WHERE HISTORY.ID=TO_NUMBER(OFFER.CODE)) WHERE EXISTS (SELECT OFFER.ID FROM OFFER WHERE...

4. Shell Programming and Scripting

[Help] Grep, Variables, IF statements... Fun

Hello, this will be my first post. I've been browsing around for a bit and have found a lot of useful information on here, hopefully a solution can be provided to me. Issue: Alright, I am looking to search for strings within a file using variables. I have a script that will accept 3 or 4...

5. Homework & Coursework Questions

Grep, Variables, IF statements... Fun

Use and complete the template provided. The entire template must be completed. If you don't, your post may be deleted! 1. The problem statement, all variables and given/known data: The issue I am having is part of a validation problem. My script will validate 3 or 4 parameters entered by the...

6. Programming

Using tops command to update NSLog statements in objective-c code

In my objective-c code base I have several NSLog statements. eg. NSLog(@"Here is the message without arguments"); NSLog(@"Here is the message with arguments: %s, %s","argument1","argument2"); Now I want to do two things: First to do: updating NSLog statements with...

LEARN ABOUT OPENSOLARIS

update-mime-database

update-mime-database(1) 					   User Commands					   update-mime-database(1)

NAME

       update-mime-database - build the shared MIME_Info database cache

SYNOPSIS

       update-mime-database [-h] [-v] [-V] mime-dir

DESCRIPTION

       update-mime-database  updates  the  shared mime-info cache according to the system described in the Shared MIME-Info Database specification
       from the X Desktop Group.

OPTIONS

       The following options are supported:

       -h	       Display a command summary.

       -v	       Display version information

       -V	       Display verbose output

OPERANDS

       The following operands are supported:

       mime-dir        The directory for which update-mime-database should rebuild the cache. This option is mandatory if no other option is  pro-
		       vided.

EXAMPLES

       Example 1: Update Shared mime-info Cache for /usr/share

       example% update-mime-database /usr/share

ENVIRONMENT VARIABLES

       See environ(5).

EXIT STATUS

       The following exit values are returned:

       0	Application exited successfully

       >0	Application exited with failure

FILES

       The following files are used by this application:

       /usr/bin/update-mime-database   Executable to build the shared MIME_Info database cache

ATTRIBUTES

       See attributes(5) for descriptions of the following attributes:

       +-----------------------------+-----------------------------+
       |      ATTRIBUTE TYPE	     |	    ATTRIBUTE VALUE	   |
       +-----------------------------+-----------------------------+
       |Availability		     |SUNWgnome-vfs		   |
       +-----------------------------+-----------------------------+
       |Interface stability	     |Committed 		   |
       +-----------------------------+-----------------------------+

SEE ALSO

       update-desktop-database(1), attributes(5), environ(5), gnome-interfaces(5)

       Latest version of the GNOME Desktop User Guide for your platform.

       Shared MIME info at http://www.freedesktop.org/.

NOTES

       Original man page written by Filip Von Raemdonck (mechanix@debian.org).

       Updated by Matt Keenan, Sun Microsystems Inc., 2004, 2007.

SunOS 5.11							    08 Nov 2007 					   update-mime-database(1)