Dear buddies!
Right now I am generating a report with some details for all the dealers.
I am required to separate the report for each dealer respectively in separate reports. I tried this method and its not of help.
Please advice.
procedure convert_excel
IS
dealer_name varchar2(100);
begin
-- Test statements here
for dealer_name in (select dealer_long_name from tbl_dealers) loop
print_report(
'select dealer_region as "Dealer Region",
dealer_long_name as "Dealer Name",
"# of Received" as "#of Customer Received",
"#of Converted",
"%of Conversion" ,
from dealer_performance t
where dealer_name = t.dealer_long_name',
'dealer_performance||dealer_name||.xml','Y');
end loop;
I didn't receive any compilation error. Compilation is successful.
I received an error when I was executing.
ORA-00904: "DEALER_NAME": invalid identifier
Please advice, where I am making the mistake.
Thanks.
SMTP server...
I recently found a tutorial online on SMTP authentification for sending emails from webpages, here is the tutorial
Help on query replacing the date
Hi Pals,
Parse Error
Hi Guys,I have a function in my class which returns a string link variable. The problem is it keeps giving me a parse error. See code below followed by error message:Code: function
Read from forum
Haven't written anything forever and I would like to get back.What I'm trying to do is getting the data from all the threads in a sub forum.Can someone roughly point out which functions I'll need for
Taylor Series Function
So I am working a a project for my intro C++ class, and I am having some trouble with a function for approximating exp(x) using a taylor series. The taylor series approximations for exp(x) is:
reading xml faster than DB call?
I am trying to optimize a high traffic website, and I enabled a feature where there are three photos selected from the most recently submitted ones, and displayed at the top of the page. I figured
Apart from cron
I need to run a php file every one hour. Is there any other solution apart from cron job?
Bandwidth monitoring?
Hi guys,I need a little information I have written a php app and I occurred to that I need to track the bandwidth that the user is using. I have done a google search and looked through my php books
extending tidy
I have problem with type-hinting and extending tidy. This code creates error:Code: class cMyTidy extends tidy{ public $tralala;}$oMyTidy = new cMyTidy();doSomething($oMyTidy);function
Day of week
I am using PHP version 5.0.5I have a varaible ($DATE (date format yyyy-mm-dd)) that is being incremented to populate a table with each day of the month. I am then trying to get the day of week
