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.
Using CSS to format MySQL query
Hi,If i want to have a news page on my site, which displays all records of a table in descending order by date I am using the below code. I can display it all in a big table but this is a bit boring.
simple ping code
been searchin the site/web and found code thats simple but doesnt work.I have a personal web server running with various things and a place to upload or down load files from out side my lan.I am
BAPI BBP_INB_DELIVERY_CREATE - material number missing in delivery
Hi Experts,
$GPRMC and NMEA how to extract from report
Hi There,Im a little bi lost and not sure where to start with this one, ive got a small gps receiver which impolling over a serial connection, each time i poll the device i get a load of rubbish back
simple php table loop
Hi all,I've the following code <?php // Create category options $query = "SELECT * FROM categories ORDER BY category ASC"; $result = mysql_query
PHP time (deadline within one week)
I have a column ['projdue'], which stores the deadline for a project.I have PHP code and <span class>'s to show projects that are within timescale, due today and overdue:Code:
How to set pass login name from htaccess to php
When the user logs into my members page via htaccess, I'd like to retain the username so that I can call upon his account info later. Is there a way to save his user name in a cookie (or some other
Quick Question about echo value
Hey guys, I'm trying to get something to show differently in one of my scripts. I'm trying to make it so that people that are a certain rank in my game will have their names show up bold in the users
How do I know when getBounds Method is ready to be called.
I have an application that changes out stylesheets client side. Once I change stylesheet the browser changes immediately but there is a lag until the Sys.UI.DomElement.getBounds method will return
Where do I put CRON code
So I've figured out alot about how to automatically run a php function. I can't figure out where to put the CRON code do I put it in the header between the head tags? do I put it before any html code?
