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.
SQL Query/echo not working
Hey all,I'm trying to run (what I thought) was a simple operation and it isn't working. I haven't coded anything in about 2 years, and I'm self taught at that so I know I've got quite a few gaps in
I need desperate help with this php code integrated with flash please
Can someone please help me with this php code which I have been stuck on for weeks . I am trying to send mail from a flash movie to an email address using php but the mail does not appear at the
PHP Programming error. Please help!
Hi there,Am making a website for a friend and have encountered a problem that i need fixing fast.I get this error when i try to run the code below: QuotePHP Error MessageWarning: Unexpected character
Display search result
Hi!I have a SQL database with information about albums and track (music). This is where the user inputs a search term(entersearch.php): Code: <form name="form"
Creating a function
Basically i wanna put all this code in a seperate file Code: <?php $query = "select product.ProductID, product.ProductName, product.ProductCategory,
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.
Multiple server callbacks (NOT POSTBACKS)
Hello,
Undefined index on my form
ok im getting Undefined index on this line.. print_r($_REQUEST['form']);below is the full script its formCode: <?phpini_set("display_errors",
Expandable Post Code
Hi,Hope you can help. Which currently I haven't upgraded to connect to a mysql server, so its all just plain html and php coding. I have a page that displays short news articles of about 25 30 words
ECC6 - Single sign-on
We are in the process of upgrading to ECC 6 which will support single sign on with user passwords aligned by our active directory to the same as those used to access the Network. My query is that we