If you use xigole jisql, you get the same presentation from all JDBC databases, and all JDBC drivers are available and free. There is also unixODBC isql and the various unixODBC drivers.
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)
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)
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)
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)
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)
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)
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)
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)
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 REDHAT
reset
RESET(7) SQL Commands RESET(7)NAME
RESET - restore the value of a run-time parameter to a default value
SYNOPSIS
RESET variable
RESET ALL
INPUTS
variable
The name of a run-time parameter. See SET [set(7)] for a list.
ALL Resets all settable run-time parameters to default values.
DESCRIPTION
RESET restores run-time parameters to their default values. Refer to SET [set(7)] for details. RESET is an alternate spelling for
SET variable TO DEFAULT
The default value is defined as the value that the variable would have had, had no SET ever been issued for it in the current session. The
actual source of this value might be a compiled-in default, the postmaster's configuration file or command-line switches, or per-database
or per-user default settings. See the Administrator's Guide for details.
See the SET manual page for details on the transaction behavior of RESET.
DIAGNOSTICS
See under the SET [set(7)] command.
EXAMPLES
Set DateStyle to its default value:
RESET DateStyle;
Set geqo to its default value:
RESET GEQO;
COMPATIBILITY
RESET is a PostgreSQL extension.
SQL - Language Statements 2002-11-22 RESET(7)