Howzit
9/25/2006, 11:17 AM
After me, because I am not.
I got a certified letter once.
BlondeSoonerGirl
9/25/2006, 11:28 AM
SELECT funny
FROM south_oval
SELECT funny
FROM south_oval
You get an error message with that?
NormanPride
9/25/2006, 11:38 AM
ORA-011341 TOO MANY ROWS RETURNED
BlondeSoonerGirl
9/25/2006, 11:40 AM
SELECT fockturds
FROM south_oval
WHERE poster_id = OUDoc
SELECT fockturds
FROM south_oval
WHERE poster_id = OUDoc
There's an excellent chance I was just insulted. Can someone translate for me. :(
SoonerInKCMO
9/25/2006, 11:56 AM
$dbh = DBI->connect('DBI: Oracle:CLRTY'.$db_env.'.AD.DSTSYSTEMS.COM', 'id', 'pwd')
or die "Couldn't connect: " . DBI->errstr;
$sql_statement = 'select a.invoiceno,b.entrydate,a.bill_to_company_code,a.i nvoicedate,c.amount,c.currency_code,d.departcode,d .entity,
d.transdate,e.prname,a.invtype,g.shortdesc,b.proje ct_code,b.transno,j.name,f.dst_department, aa.invoiceamount
from invoiceheader a, ppa_billings b, ppa_billing_values c, ppa_wip d, prtask e, odf_ca_task f,
transclass g,srm_companies h, odf_ca_company i, cmn_lookups_v j, invoiceheader_values aa
where
a.invoiceno = b.invoiceno
and b.applyto = d.transno
and a.invoiceno like \'INV%\'
and b.transno = c.transno
and a.invoiceno = aa.invoiceno
and aa.currency_type = \'HOME\'
and c.currency_type = \'HOME\'
and d.TASK_ID = e.prid
and d.chargeable = 1
and e.prid = f.id
and a.arposted = 0
and d.transclass = g.transclass
and a.bill_to_company_code = h.company_id
and h.id = i.id
and j.lookup_type = \'DST_COMPANY_TERMS\'
and j.language_code = \'en\'
and j.lookup_code = i.dst_terms
UNION
select
a.invoiceno,b.entrydate,a.bill_to_company_code,a.i nvoicedate,c.amount,c.currency_code,d.departcode,d .entity,
d.BILLSCHEDULEDATE,b.project_code,a.invtype,g.shor tdesc,b.project_code,b.transno,j.name,d.departcode ,aa.invoiceamount
from invoiceheader a, ppa_billings b, ppa_billing_values c, ppa_billingdetails d, transclass g,
srm_companies h, odf_ca_company i, cmn_lookups_v j, invoiceheader_values aa
where
a.invoiceno = b.invoiceno
and b.transno = d.transno
and a.invoiceno like \'INV%\'
and a.arposted = 0
and b.transno = c.transno
and a.invoiceno = aa.invoiceno
and aa.currency_type = \'HOME\'
and c.currency_type = \'HOME\'
and d.transclass = g.transclass
and a.bill_to_company_code = h.company_id
and h.id = i.id
and j.lookup_type = \'DST_COMPANY_TERMS\'
and j.language_code = \'en\'
and j.lookup_code = i.dst_terms
UNION
select a.invoiceno,b.entrydate,a.bill_to_company_code,a.i nvoicedate,c.amount,c.currency_code,d.departcode,d .entity,
d.transdate,e.prname,a.invtype,g.shortdesc,b.proje ct_code,b.transno,j.name,f.dst_department, aa.invoiceamount
from invoiceheader a, ppa_billings b, ppa_billing_values c, ppa_wip d, prtask e, odf_ca_task f,
transclass g,srm_companies h, odf_ca_company i, cmn_lookups_v j, invoiceheader_values aa
where
a.invoiceno like \'CRM%\'
and a.invoiceno_applyto = b.invoiceno
and b.applyto = d.transno
and b.transno = c.transno
and a.invoiceno = aa.invoiceno
and aa.currency_type = \'HOME\'
and c.currency_type = \'HOME\'
and d.TASK_ID = e.prid
and d.chargeable = 1
and e.prid = f.id
and a.arposted = 0
and d.transclass = g.transclass
and a.bill_to_company_code = h.company_id
and h.id = i.id
and j.lookup_type = \'DST_COMPANY_TERMS\'
and j.language_code = \'en\'
and j.lookup_code = i.dst_terms
UNION
select
a.invoiceno,b.entrydate,a.bill_to_company_code,a.i nvoicedate,c.amount,c.currency_code,d.departcode,d .entity,
d.BILLSCHEDULEDATE,b.project_code,a.invtype,g.shor tdesc,b.project_code,b.transno,j.name,d.departcode ,aa.invoiceamount
from invoiceheader a, ppa_billings b, ppa_billing_values c, ppa_billingdetails d, transclass g,
srm_companies h, odf_ca_company i, cmn_lookups_v j, invoiceheader_values aa
where
a.invoiceno like \'CRM%\'
and a.invoiceno_applyto = b.invoiceno
and b.transno = d.transno
and a.arposted = 0
and b.transno = c.transno
and a.invoiceno = aa.invoiceno
and aa.currency_type = \'HOME\'
and c.currency_type = \'HOME\'
and d.transclass = g.transclass
and a.bill_to_company_code = h.company_id
and h.id = i.id
and j.lookup_type = \'DST_COMPANY_TERMS\'
and j.language_code = \'en\'
and j.lookup_code = i.dst_terms
order by 1, 10';
$sth = $dbh->prepare($sql_statement);
$sth->bind_col (1, \$invoiceno);
$sth->bind_col (2, \$invoicedate);
$sth->bind_col (3, \$bill_to_cust_id);
$sth->bind_col (4, \$entry_dt);
$sth->bind_col (5, \$bal_amount);
$sth->bind_col (6, \$currency_code);
$sth->bind_col (7, \$proj_department);
$sth->bind_col (8, \$entity);
$sth->bind_col (9, \$transaction_dt);
$sth->bind_col (10, \$task_name);
$sth->bind_col (11, \$invtype);
$sth->bind_col (12, \$gl_account);
$sth->bind_col (13, \$project_id);
$sth->bind_col (14, \$transno);
$sth->bind_col (15, \$payment_terms);
$sth->bind_col (16, \$task_department);
$sth->bind_col (17, \$invoice_header_total);
while ($sth->fetch) {
#Place values in the Transno and Invoice Number arrays
load_array();
#Format several output fields
format_output();
#Write a line to each file
write_output();
}
BlondeSoonerGirl
9/25/2006, 11:59 AM
He just made that up.
That's a dolemite post if I ever saw one.
sooner_born_1960
9/25/2006, 12:00 PM
7,8,8i,9i,10g... SQL is SQL.
yermom
9/25/2006, 12:02 PM
i think i just had a seizure
Howzit
9/25/2006, 12:04 PM
7,8,8i,9i,10g... SQL is SQL.
That is a common response from non-10g-certified-ers.
;)
SoonerInKCMO
9/25/2006, 12:05 PM
He just made that up.
That's a dolemite post if I ever saw one.
It's sexy, ain't it.
Want me to show you how I used pointers to simulate multi-dimensional arrays in Perl? :hot:
StoopTroup
9/25/2006, 12:05 PM
I can borrow a certificate and probably get a job with it.
That's where things will probably go all Castanza.
Howzit
9/25/2006, 12:06 PM
It's sexy, ain't it.
Want me to show you how I used pointers to simulate multi-dimensional arrays in Perl? :hot:
I'll start a different thread for that...
BlondeSoonerGirl
9/25/2006, 12:06 PM
It's sexy, ain't it.
Want me to show you how I used pointers to simulate multi-dimensional arrays in Perl? :hot:
Lay it on me...
And then I'll show you how purty I can use PLSQL...
:les: SCANDALOUS!!!
sooner_born_1960
9/25/2006, 12:08 PM
Lay it on me...
And then I'll show you how purty I can use PLSQL...
:les: SCANDALOUS!!!
Careful there. A person could actually make a living with PLSQL skillz. SQL, not so much.
StoopTroup
9/25/2006, 12:13 PM
This Oracle you speak of...
Is this some sort of code for a SO secret society?
http://images.allmoviephoto.com/1999_Eyes_Wide_Shut/EWS_Tom_Cruise_022.jpg
NormanPride
9/25/2006, 12:18 PM
Lay it on me...
And then I'll show you how purty I can use PLSQL...
:les: SCANDALOUS!!!
Your cursors are so... explicit! :hot:
mdklatt
9/25/2006, 12:18 PM
libpgsql++: The C++ library I wrote on top of the PostgreSQL C API and use as part of my object-oriented database application framework. Suck it, script kiddies. :texan:
OCUDad
9/25/2006, 12:25 PM
This just in... everyone who posts in this thread is certifiable.
Oh, wait...
NormanPride
9/25/2006, 12:43 PM
Oracle sucks.
You got better?
SoonerInKCMO
9/25/2006, 12:56 PM
libpgsql++: The C++ library I wrote on top of the PostgreSQL C API and use as part of my object-oriented database application framework. Suck it, script kiddies. :texan:
Dork.
opksooner
9/25/2006, 12:57 PM
[insert "Holiday Inn Express" reference].
sooner_born_1960
9/25/2006, 01:38 PM
Oracle sucks.
Sounds like you need fewer sql guys and more dba's.
ten grams is not a whole lot
Apparently, it is for computer people. :D
SELECT fockturds
FROM south_oval
WHERE poster_id = OUDoc
BTW, PQ is such a bastard for not having my back.
Powered by vBulletin® Version 4.2.1 Copyright © 2024 vBulletin Solutions, Inc. All rights reserved.