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 Replies)
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 Replies)
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... (1 Reply)
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... (3 Replies)
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 (1 Reply)
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 (2 Replies)
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 . (2 Replies)
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";... (5 Replies)
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... (1 Reply)
Discussion started by: Unregistered
1 Replies
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)