06-11-2010
Hi,
For Guru,
yes, I'm using sqlplus but I don't have this variable "header" ...
For vbe,
I put pages to 0 so that's why filelds name were not displayed. But the problem is that if I don't put it to 0, it displays for me all fields which are not null and null and the output becomes hard to read.
So is there anyway to display only not null fields with their values with a select command ?
Thx,
10 More Discussions You Might Find Interesting
1. UNIX for Dummies Questions & Answers
how to pass values from oracle sql plus to unix shell script (2 Replies)
Discussion started by: trichyselva
2 Replies
2. Shell Programming and Scripting
Hi ,
I have my log file something like this
(07/29/2009 00:02:24.467) 367518 (07/29/2009 00:02:26.214) 949384011
(07/29/2009 00:02:26.236) 367524 (07/29/2009 00:02:28.207) 949395117
(07/29/2009 00:02:28.240) 337710 (07/29/2009 00:02:30.621) 949400864
I am trying to insert the data... (3 Replies)
Discussion started by: rdhanek
3 Replies
3. UNIX for Dummies Questions & Answers
I am a beginner to scripting, please help me in this regard.
How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (1 Reply)
Discussion started by: vukkusila
1 Replies
4. Shell Programming and Scripting
I am a beginner to scripting, please help me in this regard.
How do I create a script that provides a count of distinct values of all the fields in the pipe delimited file ? I have 20 different files with multiple columns in each file. I needed to write a generic script where I give the number... (2 Replies)
Discussion started by: vukkusila
2 Replies
5. Shell Programming and Scripting
Hi,
I need help to find values between two different fields based on $6 (NUM) AND $1 (CD), within the same ID. The result should show the values between the NUMs which will be extracted from within $3 and $2 in data.txt file below.
data.txt
ex 139 142 Sc_1000004 ID 4
CD ... (2 Replies)
Discussion started by: redse171
2 Replies
6. Programming
Am trying to run this :
DECLARE
CURSOR c1
IS
SELECT customer_id, num3
FROM table1
WHERE text1 = 'pp' AND customer_id IS NOT NULL;
custcount INTEGER;
oldtext24 VARCHAR2 (80);
commit_counter INTEGER := 0;
BEGIN
FOR i IN c1
... (1 Reply)
Discussion started by: maiooi90
1 Replies
7. UNIX for Advanced & Expert Users
Hi folks,
I am facing one problem with v$sql, i need to store updating sql query in temp table when one trigger get fired on some update sql statement.
but with "sql_text" , i am not getting correct update statement in temp table.
I am getting sql_text with this cursor statement.
select... (0 Replies)
Discussion started by: apskaushik
0 Replies
8. Shell Programming and Scripting
Gurus,
Thanks so much for your help, in advance.
I'm using ksh and outputting a literal string value to an output file, however, Unix isn't playing by SQL's rules. The ampersand character which I'm trying to disply as a knowledge base link is screwing up the output. Typically, the "&&" is... (1 Reply)
Discussion started by: WhoDatWhoDer
1 Replies
9. Programming
Hi,
I have been frantically googling and checking some sqlplus forums, but can't find the correct syntax.
Basically within sqlplus I want to do a count on a table and if the count is 0 it displays 0 instead of "no rows found".
For eample:
select count(*) from tableA where... (3 Replies)
Discussion started by: chris01010
3 Replies
10. Shell Programming and Scripting
Hello,
I have a file which has the following contents :
thewall............0000000000200000 kmemfreelater......0000000000000000
kmemgcintvl........0000000000000002 kmeminuse..........00000000223411C0
allocated..........0000000029394000 bucket.......... @.F1000A02800C2158
The mentioned... (4 Replies)
Discussion started by: rahul2662
4 Replies
LEARN ABOUT MOJAVE
dbix::class::sqlmaker::oraclejoins
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)