updating a column in oracle table using shell script Post: 71260

9 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

Store return code of shell script in oracle table

Hi friends, I have to do the following things : 1) there should be a shell script returning the returning the return code of the script. and i have to add some more details like on which machine is has run , at what time and other details and then using plsql i have to add a row to Oracle...

3. Shell Programming and Scripting

script for updating table using file(

Hi, Data file path (.txt) Control file(.ctl) 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...

4. Shell Programming and Scripting

updating a column in a unix table for a particular row

Hi, I have the following requirement. I have a unix table as below progname par1 par2 par3 par4 PROG1 abc def 0012 ooo PROG2 wed xas 0100 xxx PROG3 kkk ppp 0004 ppp Different programs(ex:PROG1,PROG2..) accesses this table and update...

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

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

Run the Script from any stage by updating data from Oracle Table.

I have 100 Scripts, each containing 10-15 SQL's in them. Each Script run for 40 mins to 1 hour 30 mins. In the event of Failure in any step, if i re-start the Script, it will start running from the beginning. Which is waste of time. So in order handle this, i made the script to run from the...

9. Shell Programming and Scripting

Parameterizing to dynamically generate the extract file from Oracle table using Shell Script

I have below 2 requirements for parameterize the generate the extract file from Oracle table using Shell Script. Could you please help me by modifying the script and show me how to execute it. First Requirement: I have a requirement where I need to parameterize to generate one...

LEARN ABOUT DEBIAN

update-gap-workspace

UPDATE-GAP-WORKSPACE(1) 					   User Commands					   UPDATE-GAP-WORKSPACE(1)

NAME

       update-gap-workspace - manage a GAP workspace.

SYNOPSIS

       update-gap-workspace

       update-gap-workspace update

	      Create or update the GAP workspace.

       update-gap-workspace delete

	      Delete the GAP workspace.

DESCRIPTION

       At  start  up,  GAP  load  all  libraries and packages available on the system.	This take several seconds. To save time, GAP can store the
       result of this initialisation in a `workspace'.	update-gap-workspace help to manage such workspaces.  update-gap-workspace can be  run	as
       root  to  manage  the  system-wide  workspace.	update-gap-workspace  can be run as a normal user. In this case the workspace is stored in
       $HOME/gap/workspace.gz.

       Note that you need to rebuild the workspace each time GAP packages are added, removed or updated. To automate that task, if the system-wide
       workspace exists, it is automatically updated whenever a GAP-related Debian package is installed or upgraded.

       The gap script will automatically load such workspace at start up.

FILES

       /var/lib/gap/workspace.gz:
	      The system-wide GAP workspace.
       $HOME/gap/workspace.gz:
	      The user-specific GAP workspace.

SEE ALSO

       gap(1), The `SaveWorkspace' function in the GAP manual.

AUTHOR

       Bill Allombert <ballombe@debian.org>

NOTES

       We  are	considering  enabling the system-wide workspace per default, though this feature could be too confusing for old-time GAP users. If
       you have opinions about it, please mail <gap@packages.debian.org>.

Debian								     July 2003						   UPDATE-GAP-WORKSPACE(1)