How to update a Oracle table through shell scripting? Post: 302852391

10 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

update a oracle table using shell script

Hi, I would like to know how to update a table in Oracle database, if a command in one shell script either successfully completes or it fails.(like Y if its success or N if its a failure) While the command is running,I am able to view the log file created in the Unix machine.After the command...

2. Shell Programming and Scripting

updating a column in oracle table using shell script

Hi friends, i am having a variable declared in .profile.i am changing its value in a shell script and then i am connecting to oracle and then from there i am calling a .sql called update.sql STATUS is the variable declared in the .profile =============================== if sqlplus <<END...

3. UNIX for Advanced & Expert Users

unix script for update or insert records from a file to a oracle table

Hi, I have delimited file(|). Sample data: 1|name|50009|DS24|0|12 2|name|30009|DS24|0|13 3|name|20409|DS24|0|14 4|name|20009|DS24|0|15 5|name|10009|DS24|0|16 I want to load this data into a oracle table (update and insert) Please help me the commands and also...

4. Shell Programming and Scripting

To update a column in a table through shell script

Hi All, I need to write a shell script in UNIX that should accept booking number as an argument and update it with value "NULL" if the transaction date is greater than 2 years. Booking number and transaction_date are the two columns of the table table_booking. Something like this, through...

5. Shell Programming and Scripting

Create a table using shell scripting

Hi Can we create a rectangular table as i have attached in the query . This is primarily for populating the created table with data gathered . Hope I made myself clear ... Pls suggest Thanks

6. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance

7. Shell Programming and Scripting

Shell script to export data from Oracle table .

Hi, I want to write a shell script which will export data from oracle table . I don't want to save that data . I want the queries . Right now i am right clicking on the table and clicking on export as to my desktop . Please let me know if any one have any idea .

8. Shell Programming and Scripting

Please help in populating output in table using shell scripting

Below is my code where i tried using table tag to print out put in table but its not working #!/bin/ksh #] && . ./.profile 2>/dev/null if test -f '.profile'; then . ./.profile; fi; #. .profile LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1";...

9. UNIX for Advanced & Expert Users

How can i populate the record in to table using shell scripting?

LOG_DIR=/app/rpx/jobs/scripts/just/logs sendEmail() { pzCType="$1"; pzTitle="$2"; pzMsg="$3"; pzFrom="$4"; pzTo="$5"; pzFiles="$6"; pzReplyTo="$7" ( echo "From: $pzFrom\nTo: $pzTo\nSubject: $pzTitle${pzReplyTo:+\nReply-To: $pzReplyTo}" ] && echo...

10. Forum Support Area for Unregistered Users & Account Problems

Creation of Oracle table through shell scripting

Hi, I am trying to create a table through shell scripting . I used a command sqlplus -s to connect to sqlplus and user as sysdba. but there is a problem in it. can anyone please solve this . #!/bin/bash $(`sqlplus -s / as sysdba <<eof create table sample (id,int); insert into sample...

LEARN ABOUT DEBIAN

stg-import

STG-IMPORT(1)							   StGit Manual 						     STG-IMPORT(1)

NAME

       stg-import - Import a GNU diff file as a new patch

SYNOPSIS

       stg import [options] [<file>|<url>]

DESCRIPTION

       Create a new patch and apply the given GNU diff file (or the standard input). By default, the file name is used as the patch name but this
       can be overridden with the --name option. The patch can either be a normal file with the description at the top or it can have standard
       mail format, the Subject, From and Date headers being used for generating the patch information. The command can also read series and mbox
       files.

       If a patch does not apply cleanly, the failed diff is written to the .stgit-failed.patch file and an empty StGIT patch is added to the
       stack.

       The patch description has to be separated from the data with a --- line.

OPTIONS

       -m, --mail
	   Import the patch from a standard e-mail file.

       -M, --mbox
	   Import a series of patches from an mbox file.

       -s, --series
	   Import a series of patches from a series file or a tar archive.

       -u, --url
	   Import a patch from a URL.

       -n NAME, --name NAME
	   Use NAME as the patch name.

       -p N, --strip N
	   Remove N leading slashes from diff paths (default 1).

       -t, --stripname
	   Strip numbering and extension from patch name.

       -i, --ignore
	   Ignore the applied patches in the series.

       --replace
	   Replace the unapplied patches in the series.

       -b BASE, --base BASE
	   Use BASE instead of HEAD for file importing.

       --reject
	   Leave the rejected hunks in corresponding *.rej files.

       -e, --edit
	   Invoke an editor for the patch description.

       -d, --showdiff
	   Show the patch content in the editor buffer.

       -a "NAME <EMAIL>", --author "NAME <EMAIL>"
	   Use "NAME <EMAIL>" as the author details.

       --authname AUTHNAME
	   Use AUTHNAME as the author name.

       --authemail AUTHEMAIL
	   Use AUTHEMAIL as the author e-mail.

       --authdate AUTHDATE
	   Use AUTHDATE as the author date.

       --sign
	   Add a "Signed-off-by:" to the end of the patch.

       --ack
	   Add an "Acked-by:" line to the end of the patch.

STGIT

       Part of the StGit suite - see linkman:stg[1]

StGit								    03/13/2012							     STG-IMPORT(1)