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

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

qrencode

QRENCODE(1)						      General Commands Manual						       QRENCODE(1)

NAME

       qrencode - Encode input data in a QR Code and save as a PNG or EPS image.

SYNOPSIS

       qrencode [OPTION]...  [STRING]

DESCRIPTION

       Libqrencode  is	a  library  for encoding data in a QR Code symbol, a kind of 2D symbology that can be scanned by handy terminals such as a
       mobile phone with CCD. The capacity of QR Code is up to 7000 digits or 4000 characters, and has high robustness.

       Qrencode is a utility software using libqrencode to encode string data in a QR Code and save as a PNG or EPS image.

OPTIONS

       -h, --help
	      display help message.

       -o FILENAME, --output=FILENAME
	      write image to FILENAME. If '-' is specified, the result will be output to standard output. If -S is given, structured  symbols  are
	      written to FILENAME-01.png, FILENAME-02.png, ... (suffix is removed from FILENAME, if specified)

       -s NUMBER, --size=NUMBER
	      specify the size of dot (pixel). (default=3)

       -l {LMQH}, --level={LMQH}
	      specify error collectin level from L (lowest) to H (highest). (default=L)

       -v NUMBER, --symversion=NUMBER
	      specify the version of the symbol. (default=auto)

       -m NUMBER, --margin=NUMBER
	      specify the width of margin. (default=4)

       -d NUMBER, --dpi=NUMBER
	      specify the DPI of the generated PNG. (default=72)

       -t {PNG,EPS,ANSI,ANSI256}, --type={PNG,EPS,ANSI,ANSI256}
	      specify the type of the generated image. (default=PNG)

       -S, --structured
	      make structured symbols. Version must be specified.

       -k, --kanji
	      assume that the input text contains kanji (shift-jis).

       -c, --casesensitive
	      encode lower-case alphabet characters in 8-bit mode. (default)

       -i, --ignorecase
	      ignore case distinctions and use only upper-case characters.

       -8, --8bit
	      encode entire data in 8-bit mode. -k, -c and -i will be ignored.

       -M, --micro
	      encode in a Micro QR Code. (experimental)

       -V, --version
	      display the version number and copyrights of the qrencode.

       [STRING]
	      input data. If it is not specified, data will be taken from standard input.

EXAMPLES

       qrencode -l L -v 1 -o output.png 'Hello, world!'
	      encode into a symbol version 1, level L.

       qrencode -iSv 1 --output=output.png
	      read standard input and encode it into a structured-appended symbols in case-insensitive mode.

AUTHOR

       Written by Kentaro Fukuchi.

RESOURCES

       Main Web Site: http://fukuchi.org/works/qrencode/

       Source code repository: https://github.com/fukuchi/libqrencode/

COPYRIGHT

       Copyright (C) 2006-2012 Kentaro Fukuchi.

qrencode 3.3.0							   Feb. 29, 2012						       QRENCODE(1)