Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::storage::dbi::oracle::wherejoins(3) [osx man page]

DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)	User Contributed Perl Documentation	  DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)

NAME
DBIx::Class::Storage::DBI::Oracle::WhereJoins - Oracle joins in WHERE syntax support (instead of ANSI). PURPOSE
This module is used with Oracle < 9.0 due to lack of support for standard ANSI join syntax. SYNOPSIS
DBIx::Class should automagically detect Oracle and use this module with no work from you. DESCRIPTION
This class implements Oracle's WhereJoin support. 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
See DBIx::Class::SQLMaker::OracleJoins for implementation details. BUGS
Does not support full outer joins. Probably lots more. SEE ALSO
DBIx::Class::SQLMaker DBIx::Class::SQLMaker::OracleJoins DBIx::Class::Storage::DBI::Oracle::Generic DBIx::Class 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.16.2 2012-08-16 DBIx::Class::Storage::DBI::Oracle::WhereJoins(3)

Check Out this Related Man Page

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)
Man Page

15 More Discussions You Might Find Interesting

1. Shell Programming and Scripting

Multiple co-processor file descriptors

I have a script that creates a KSH co-process for Oracle sqlplus and I am presently interacting with it via print -p and read -p. I also need to interact with another Oracle database what isn't permitted to have any direct connection to the first. Presently, I simply disconnect from the first... (10 Replies)
Discussion started by: tmarikle
10 Replies

2. Shell Programming and Scripting

Unix Oracle

Through a shell script ... I am invoking sql plus.. Code is as follows... echo " set feedback off verify off pagesize 0 select column from table " | sqlplus -s/@dbname | read var_col Now if oracle throws an exception for above select statement ...then how can i catch it ?... (15 Replies)
Discussion started by: dhananjaysk
15 Replies

3. Shell Programming and Scripting

Calling SQL scripts through Shell Script

Oracle and Scripting gurus, I need some help with this script... I am trying to add the query SELECT * FROM ALL_SYNONYMS WHERE SYNONYM_NAME = 'METADATA' in the current script.... Read the result set and look for the TABLE_NAME field. If the field is pointing to one table eg.... (18 Replies)
Discussion started by: madhunk
18 Replies

4. UNIX for Advanced & Expert Users

Capturing Oracle Shutdown error

Hi, Iam calling 3 sql scripts through one shell script 'rmia.sh'. Till now this was working fine, but last time while calling the SQL scripts, Oracle was down. But amazingly the exit status was '0' (success)!!! Below is the shell code: #!/usr/bin/ksh -x assign_file asql a.sql 1... (15 Replies)
Discussion started by: ganapati
15 Replies

5. HP-UX

HP-Unix; .net application creates processes

I have a .net application that works with an Oracle database in HP-Unix. Problem: .net application creates Oracle processes that don't close. By default Oracle can work with 200 active processes and after that crashes. I doubled this number and I don't have to many problems. I want: to... (12 Replies)
Discussion started by: NicoMan
12 Replies

6. Shell Programming and Scripting

How to COnnect to Oracle database from UNIX Box

I am trying to connect to Oracle Databse from UNIX box using sqlplus command. But i get sqplus not found message. $ sqlplus sqlplus: not found I have searched in forums and all are suggesting to set environment varaibles...can somebody tell me what variables to set and how to set.and the... (12 Replies)
Discussion started by: angelarosh
12 Replies

7. UNIX for Advanced & Expert Users

Gurus needed to diagnose severe performance degradation

Hi everyone, newbie forum poster here. I'm an Oracle DBA and I require some guidance from the Unix gurus here about how to pinpoint where a problem is within a Solaris 9 system running on an 8 CPU Fujitsu server that acts as our Oracle database server. Our sysadmins are trying their best to... (13 Replies)
Discussion started by: DBA_guy
13 Replies

8. What is on Your Mind?

What do you think of the Oracle-Sun deal?

Sound off with your thoughts on Oracle's acquisition of Sun Microsystems here! (12 Replies)
Discussion started by: Neo
12 Replies

9. Shell Programming and Scripting

Shell script to catch PL/SQL return values

I tried searching the forum for similar posts but its closed now. Would appreciate any help on this. I am trying to capture return value from a select query into a variable. DB is Oracle I am able to spool it to a file but I donot intend to use it. Here is my script that does not work ;) I... (27 Replies)
Discussion started by: monie2717
27 Replies

10. Solaris

IPMP on Private interconnects

I have a Oracle dbase running in a Solaris 10 cluster and have two private interconnects that are being used for communication. Is there any way to connect these two interconnects together using IPMP for redundancy? I've made several attempts with no luck so far and was wondering if anyone had... (17 Replies)
Discussion started by: goose25
17 Replies

11. UNIX for Advanced & Expert Users

uuencode problem

Hi, I am making a shell script on HP-UX that will do some Oracle db query and fetch data. Then after formatting the output files (there are two files) in a csv format, I want to send them as email attachments. Unfortunately the email contains garbage. I could not find solution to the problem... (13 Replies)
Discussion started by: asutoshch
13 Replies

12. Shell Programming and Scripting

Permission to Oracle server

i need to give permission to ORACLE SERVER to create a directory in a particular path. How to do it?Oracle server is installed in Unix (11 Replies)
Discussion started by: rafa_fed2
11 Replies

13. Shell Programming and Scripting

Permission to Oracle server to create a directory in a particular path

i need to give permission to ORACLE SERVER to create a directory in a particular path. How to do it?Oracle server is installed on SOLARIS (16 Replies)
Discussion started by: rafa_fed2
16 Replies

14. Hardware

Old RS/6000 lost its mind

Some time ago I bought an old microchannel RS/6000 39H as a hobby toy. I mostly deal with newer Sun/Oracle equipment so I'm a bit out of my element. The machine was running, AIX 4.1.3 I believe. Using it via IBM terminal. I stored it for what was apparently too long, and now it stalls out... (11 Replies)
Discussion started by: drjohnnyfever
11 Replies

15. AIX

[Opinion] A Public Answer To Rob McNelly

Why Do We Need Root on the HMC? In this article in IBMSystems Magazine Rob McNelly asked the question Why Don't We Have Root on the HMC? and he goes on to justify why we indeed shouldn't have root - kinda. I think his arguments are not as valid as he perhaps thinks they are and what's more... (11 Replies)
Discussion started by: bakunin
11 Replies

Featured Tech Videos