Hi
I am trying to run sql query from solaris in csh script and send the output to email. Below is my sql query
Anyone can help to make the above sql query output in nicer format prefer in table format with border?
Hi,
My requirement is :
We are calling an sql statement from a UNIX session, and fetching data into some variables from a table .. now we are unable to access these variables from outside the SQL part. Please let me know how can I achieve this.
Can you please share a code snippet which... (4 Replies)
Hi,
I am executing sql files in my unix shell script. Now i want to find whether its a success or a failure record and redirect the success or failure to the respective files. meaning.
success records to success.log file
failure record to failure.log file.
As of now i am doing like... (1 Reply)
Hello Guys,
This message is somewhat relates with last thread. But I need to re-write thing. I start over a little. I am stuck now and need your help.
Here is my script-
#! /bin/ksh
export ORACLE_HOME=/opt/oracle/app/oracle/product/9.2
/opt/oracle/app/oracle/product/9.2/bin/sqlplus -s... (5 Replies)
I know little SQL and could really use a hand here. I need to get the fields last_name, first_name and email from the table users and only if the entery with the same pkey in the table addresses, in the city column is Seattle.
So if the city in the addresses table is Seattle, go to the table... (2 Replies)
I have written a shell script that calls below sql file. It is not sending the query data in table in the body of email.
spool table_update.html;
SELECT * FROM PROCESS_LOG_STATS where process = 'ActivateSubscription';
spool off;
exit;
Please use code tags next time for your code and data.... (9 Replies)
Hi
iam new to shell scripting
how to declare variables as redshift query and I have to compare two counts by using if condition .
ex:count=select count(*) from prd;
select count(*) from prd;
select count(*) from tag;
can any one help me .
Please use CODE tags when displaying... (1 Reply)
Hello,
In my shell script, I extract table data from HP Vertica DB into a csv file using vsql -c command. But the problem is the file getting created is in binary format and hence some of the data becomes unreadable which has chinese characters as part of data.
file -i filename.csv - gives... (2 Replies)
Hi Team,
below sql rerturn 20 records, the result set i am going to assign to one variable and it showing count is 1.
and i don't use count() in sql query... based on count, i need to fail the script.
No_of_step=`echo ${g_count} | wc -l`
function gf_count()
{
g_count=`sqlplus -s... (8 Replies)
Discussion started by: bmk123
8 Replies
LEARN ABOUT MOJAVE
dbix::class::sqlmaker::oraclejoins5.18
DBIx::Class::SQLMaker::OracleJoins(3) User Contributed Perl Documentation DBIx::Class::SQLMaker::OracleJoins(3)NAME
DBIx::Class::SQLMaker::OracleJoins - Pre-ANSI Joins-via-Where-Clause Syntax
PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax.
SYNOPSIS
Not intended for use directly; used as the sql_maker_class for schemas and components.
DESCRIPTION
Implements pre-ANSI joins specified in the where clause. Instead of:
SELECT x FROM y JOIN z ON y.id = z.id
It will write:
SELECT x FROM y, z WHERE y.id = z.id
It should properly support left joins, and right joins. Full outer joins are not possible due to the fact that Oracle requires the entire
query be written to union the results of a left and right join, and by the time this module is called to create the where query and table
definition part of the sql query, it's already too late.
METHODS
select
Overrides DBIx::Class::SQLMaker's select() method, which calls _oracle_joins() to modify the column and table list before calling
next::method().
BUGS
Does not support full outer joins (however neither really does DBIC itself)
SEE ALSO
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Storage class using this
DBIx::Class::SQLMaker - Parent module
DBIx::Class - Duh
AUTHOR
Justin Wheeler "<jwheeler@datademons.com>"
CONTRIBUTORS
David Jack Olrik "<djo@cpan.org>"
LICENSE
This module is licensed under the same terms as Perl itself.
perl v5.18.2 2014-01-22 DBIx::Class::SQLMaker::OracleJoins(3)