Linux and UNIX Man Pages

Linux & Unix Commands - Search Man Pages

dbix::class::sqlmaker::oraclejoins(3) [osx 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.16.2 2012-08-16 DBIx::Class::SQLMaker::OracleJoins(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

shellscript.query Oracle table..populate in a text file

Hi Guys, I'm new to this forum as well as to UNIX shell scripting. I'm looking for a shellscript to query an Oracle database table and populate the result set of the query in a text file. Could you someone help me out with a sample code? Thanks, Bhagat (7 Replies)
Discussion started by: bhagat.singh-j
7 Replies

2. Shell Programming and Scripting

Query Oracle tables and return values to shell script that calls the query

Hi, I have a requirement as below which needs to be done viz UNIX shell script (1) I have to connect to an Oracle database (2) Exexute "SELECT field_status from table 1" query on one of the tables. (3) Based on the result that I get from point (2), I have to update another table in the... (6 Replies)
Discussion started by: balaeswari
6 Replies

3. UNIX for Advanced & Expert Users

Tough Oracle Logic in Ux

How Can this logic be implemented in Unix SELECT B.SERVICE_TYPE || '|' || B.TOTAL_TYPE || '|' || B.CALL_INDICATOR || '|' || B.A_NUMBER || '|' || B.APN || '|' || B.DAY || '|' || B.HOUR ||... (3 Replies)
Discussion started by: magedfawzy
3 Replies

4. Shell Programming and Scripting

Fixed-Width file from Oracle

Hi All, I have created a script which generates FIXED-WIDTH file by executing Oracle query. SELECT RPAD(NVL(col1,CHR(9)),20)||NVL(col2,CHR(9))||NVL(col3,CHR(9) FROM XYZ It generates the data file with proper alignment. But if same file i transfer to windows server or Mainframe... (5 Replies)
Discussion started by: Amit.Sagpariya
5 Replies

5. UNIX for Advanced & Expert Users

Script which will run every 10minutes and Send SMS to mobile

Hello Genuis guys, I am running Aix5 and Oracle 9 on it. I have sql query which only count a particular rows. I need to prepare a script which will run that sql query every 10 minutes and if the ouput count is greate than 20. It will send SMS to mobile numbers. Need your kind help to... (8 Replies)
Discussion started by: thepurple
8 Replies

6. Shell Programming and Scripting

Shell script to query Oracle table

Hi, unix gurnis I need help for following requirement for writing a shell scritp. log in to oracle database, query one table total records (select count(*) from table1), pass the return value to a file. Thanks in advance (2 Replies)
Discussion started by: ken002
2 Replies

7. UNIX for Dummies Questions & Answers

My join command only joins the first few lines!!

Hi new to all this so bear with me. I have two lists. List A has the old names and some values for each of the names e.g. List A: snpa 3.2 snpb -2 snpc 0 List B has old names and new names equivalent: snpa rs1234 snpb rs2345 snpc re3456 Now I have over 50,000 lines in each and... (3 Replies)
Discussion started by: qnc
3 Replies

8. Programming

Select and group by excluding one field

Dear community, I have a very simple query (on Oracle 11g) to select 3 fields: select field1, field2, field3, count(*) from table where... group by field1, field2, field3 having count(*) > 10;Now, what I need, is exclude "field3" from the "group by" since I only need field 1 and 2 to be... (2 Replies)
Discussion started by: Lord Spectre
2 Replies

9. Shell Programming and Scripting

Capture rows for a column in file from delete sql -Oracle

Hi, This may not be the right forum but i am hoping someone knows an answer to this. I have to capture rows for a column that was deleted. How can i do that without having to write a select query? delete from myschema.mytable where currentdatetimestamp > columnDate this should delete 5... (4 Replies)
Discussion started by: jakSun8
4 Replies

10. UNIX for Dummies Questions & Answers

Removing unnecessary eol ($) character from Oracle sql query output

Hi All, I am fetching oracle query result in shell variable. As columns numbers are more the output wraps in unix terminal .i.e one complete record in db gets store in multiple lines. with each line ends with $ character. I want to remove these unnecessary $ character but to keep required $... (8 Replies)
Discussion started by: Harshal22
8 Replies

11. Programming

Oracle Variable Passing Test

Hi, I am trying to get the oracle variables and pass the values in sql placed in procedure. VARIABLE vstat='ASDS,FGDS,VCGD,VCXC' Query : select distinct dept from College where section in ('C','D') AND CODES ='' AND NAMES IN ('RAJ','SAM'); I want CODES values to be taken from vstat... (1 Reply)
Discussion started by: Perlbaby
1 Replies

12. Shell Programming and Scripting

Problems with fetching data from Oracle database

Here's a database query which looks up the NAME column of PRODUCT table SELECT NAME FROM PRODUCT ; And this query retrieves me the following output SUGAR COCOA HONEY WHEAT CABBAGE CAULI FLOWER Please note the last record CAULI FLOWER contains TWO blank spaces between the two words. ... (4 Replies)
Discussion started by: kumarjt
4 Replies

13. Shell Programming and Scripting

How to write a update query in perl script?

can any one suggest me on how to write a update query in perl script for Oracle database and also tell me abt how we can write a code for sending mails with report as attachment to appropriate persons? (1 Reply)
Discussion started by: Ramesh V Kumar
1 Replies

14. Programming

Oracle 11g optimizer best join order question

Hi team Optimizer max permutations and search limit are set to 3.5 million and 10 respectively.The parameter instruct optimizer to evaluate up to 3.5 million permutations for max 10 table joins I have query with 9 tables joined. How many combinations will optimizer perform to find best... (1 Reply)
Discussion started by: Perlbaby
1 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