|
|
Sponsored Content
Special Forums
UNIX and Linux Applications
Please help: Oracle gqsql or sqlplus output format like mysql
Post 302777927 by Linusolaradm1 on Friday 8th of March 2013 06:03:26 PM
03-08-2013
|
|
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
Hi,
I am using a query like below in my shell script :
{
{
echo "set echo off"
echo "set head off"
echo "whenever sqlerror exit -1;
select NUMBER ||','||
FNAME ||','||
LOC ||','||
... (2 Replies)
Discussion started by: deepakgang
2 Replies
2. Shell Programming and Scripting
Hi all,
Does anyone know how to format the output from mysql from within a shell script?
i.e.
RESULT=`mysql command`
echo ${RESULT}
the ${RESULT} only displays the output on one line instead of how mysql would display it as columns etc (3 Replies)
Discussion started by: muay_tb
3 Replies
3. Shell Programming and Scripting
a job extracts orcle data into unix as flat file.
a single record breaks into two record in unix flat file. This is the case only for 6 records out of 60 lack records.
(its not single record in two line. but its single record into record. ie., \n come into picture)
can you tell me what... (6 Replies)
Discussion started by: Gopal_Engg
6 Replies
4. UNIX for Dummies Questions & Answers
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (1 Reply)
Discussion started by: shrutihardas
1 Replies
5. Shell Programming and Scripting
Hi,
I am very new to shell scripting and trying to write a simple shell script in which i am trying to achieve the following:
1. Connect to oracle database hosted on a different server
2. fire a query on the oracle db
3. store the output in a variable
4. use this variable for further logic... (26 Replies)
Discussion started by: shrutihardas
26 Replies
6. Shell Programming and Scripting
Hi
I have developed bash script to connect to database and execute .sql files. I am logging some statements in to log file using echo. While logging I am adding the date in front of the log statements which makes sense. I am unable to add date in front of output from the sqlplus and sqlldr,... (8 Replies)
Discussion started by: murtymvvs
8 Replies
7. Shell Programming and Scripting
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
Discussion started by: rockf1bull
3 Replies
8. Shell Programming and Scripting
Good afternoon!
I have been lurking in this forum for awhile now. I have just recently started posting. I think this is a really good site. With that being said, I don't like to just run and get an answer before I try my best first.
I have poured some blood, sweat and tears into... (4 Replies)
Discussion started by: brianjb
4 Replies
9. Shell Programming and Scripting
I have logged into oracle using SQLPLUS. When I type any kind of query, there is only 1 answer - '2'.
What is wrong with it? (1 Reply)
Discussion started by: Subhasis
1 Replies
10. UNIX for Beginners Questions & Answers
Hi,
I have some questions about sqlplus running from bash. I am still new and learning. I have the code shown below:
echo "exit" | sqlplus... (10 Replies)
Discussion started by: mohca2020
10 Replies
LEARN ABOUT DEBIAN
config::model::models::lcdd::picolcd
Config::Model::models::LCDd::picolcd(3pm) User Contributed Perl Documentation Config::Model::models::LCDd::picolcd(3pm) NAME
Config::Model::models::LCDd::picolcd - Configuration class LCDd::picolcd VERSION
version 2.021 DESCRIPTION
Configuration classes used by Config::Model generated from LCDd.conf Elements KeyTimeout KeyTimeout is the time in ms that LCDd spends waiting for a key press before cycling through other duties. Higher values make LCDd use less CPU time and make key presses more detectable. Lower values make LCDd more responsive but a little prone to missing key presses. 500 (.5 second) is the default and a balanced value. Optional. Type integer. upstream_default: '500'. Backlight Sets the initial state of the backlight upon start-up.Optional. Type enum. choice: 'on', 'off'. upstream_default: 'on'. Brightness Set the initial brightness . Works only with the 20x4 device. Optional. Type integer. upstream_default: '1000'. OffBrightness Set the brightness while the backlight is 'off' . Works only with the 20x4 device.Optional. Type integer. upstream_default: '0'. Contrast Set the initial contrast Optional. Type integer. upstream_default: '1000'. Keylights Light the keys? Optional. Type enum. choice: 'on', 'off'. upstream_default: 'on'. Key0Light If Keylights is on, the you can unlight specific keys below: Key0 is the directional pad. Key1 - Key5 correspond to the F1 - F5 keys. There is no LED for the +/- keys. This is a handy way to indicate to users which keys are disabled. Optional. Type enum. choice: 'on', 'off'. upstream_default: 'on'. Key1Light Optional. Type uniline. default: 'on'. Key2Light Optional. Type uniline. default: 'on'. Key3Light Optional. Type uniline. default: 'on'. Key4Light Optional. Type uniline. default: 'on'. Key5Light Optional. Type uniline. default: 'on'. LircHost Host name or IP address of the LIRC instance that is to receive IR codes If not set, or set to an empty value, IR support is disabled.Optional. Type uniline. default: '127.0.0.1'. LircPort UDP port on which LIRC is listening Optional. Type integer. upstream_default: '8765'. LircFlushThreshold Threshold in jiffies of synthesized gap that triggers flushing the IR data to lirc 100 means 6.1ms. legal: 16 - 32767; Use 0 to disable.Optional. Type integer. upstream_default: '100'. SEE ALSO
o cme perl v5.14.2 2012-11-09 Config::Model::models::LCDd::picolcd(3pm)