spoolFunc()
{
sqlplus -s /nolog <<!!|grep -v 'Connected'
connect ${FCP_LOGIN};
set colsep "|"
set term off
set feedback off
set HEADING off
set pagesize 0
set verify off
SET echo off
SPOOL $MSIAP_TOP/bin/success.csv;
SELECT 'ROLLNO|'||'NAME|'||'MARKS' from dual;
select * from student;
Spool OFF;
Exit;
/!!
}
spoolFunc
A Language is not worth knowing unless it teaches you to think differently.
Subscribe to:
Post Comments (Atom)
Oracle Standard Package for Order Totals
Purpose: Sometimes we need to show line-wise or complete order totals (Basic / Tax / Tax+Basic) in reports. Oracle provides a standard...
-
1. To download Ldt file for a Concurent Program FNDLOAD [username]/[password] O Y DOWNLOAD $FND_TOP/patch/115/import/afcpprog.lct file_nam...
-
The profile information available in the HZ_CUSTOMER_PROFILES can be created in three levels namely Party, Customer Account and Customer...
-
Here the article will describe about how to register WebADI to Responsibility menu Go to System Administrator --> Security --> Respo...
No comments:
Post a Comment