I am using the pl\sql cartridges for creating the Applications and then placing in Oracle Application
which i have created the User(SEENU) which i have created the User(SEENU) having forms and reports .............
But i want the Columns be bold in the EXCEL Sheet when it was opened.. or any other option....
( p_customer_id IN NUMBER ,
p_customer_name IN VARCHAR2 ,
p_customer_Address IN VARCHAR2 DEFAULT NULL,
p_Type IN VARCHAR2 DEFAULT 'EXCEL'
SELECT customer_id, customer_name, customer_Address
ORDER BY customer_name;
i NUMBER := 0;
IF ( p_Type = 'EXCEL' ) THEN
fldSep := CHR(9);
owa_util.mime_header( 'application/vnd.ms-excel', TRUE );
htp.print( 'Customer No'
|| fldSep || 'Customer Name'
|| fldSep || 'Customer Address'
FOR v_cust IN c_cust
|| fldSep || v_cust.Customer_Name
|| fldSep || v_cust.Customer_Address
---------*** The OUTPUT is ***----------
Customer No Customer Name Customer Address
1001 John Laaat pet
1002 Abhi Nungam pet
1003 Seenu Thiru pet