It worked fine. but how to put the sql output into the xls file.
Now How do i send it to excel sheet.
I have done some part but dont know how to append the sql output
FILENAME: DISNEY09212013.xls
Header Row:
<html><body><table border='1'><caption>DISNEY BOOKING<br/>Delivery Date: ${TDATE_SLASH}</caption><tr><th colspan="13" bgcolor="black"></th></tr><tr bgcolor='#D3D3D3'><th>BOOKING</th><th>ARRIVAL DATE</th><th>STATUS</th><th>LAST_NAME</th><th>FIRST_NAME</th></tr>" >${DISNEY_REPORT_HOME}/${DISNEY_FILE}
+ echo '<html><body><table border='\''1'\''><caption>DISNEY BOOKING<br/>Delivery Date: 09/21/2013</caption><tr><th colspan=13 bgcolor=black></th></tr><tr bgcolor='\''#D3D3D3'\''><th>BOOKING</th><th>ARRIVAL DATE</th><th>STATUS</th><th>LAST_NAME</th><th>FIRST_NAME</th></tr>
Then The SQL QUERY
sqlplus -S /nolog << EOF >> DISNEY09212013.xls
connect tipls/tipls@plsdev
set echo off feedback off linesize 4000 pagesize 0 sqlprompt '' trimspool on
select res.ti_book_no ,res.arrival_date ,res.ti_status,res.last_name,res.first_name from disney_ticket_history res where res.ti_status ='PENDING' and res.request_file_id IN (select req.request_file_id from disney_ticket_request_file req where transaction_date=${TRANSACTION_DATE});
EOF
</table></body></html>" >>DISNEY09212013.xls
Desired Output on file DISNEY09212013.xls(Its not compulsory xls file it can be any file where the output can be easily written:
########################
DISNEY BOOKING
Delivery Date: 09/21/2013
BOOKING ARRIVAL DATE STATUS LAST_NAME FIRST_NAME
X 09222013 PENDING ABC XYZ
A 10122013 PENDING KLM EFG
#######################
---------- Post updated 09-26-13 at 01:56 PM ---------- Previous update was 09-25-13 at 11:25 PM ----------
Hi,
I am writing a ksh script which will use sqlplus to run a sql and pass 2 variables as the SQL request. In the ksh script, I have 2 variables which are $min_snap and $max_snap holding 2 different numbers.
Inside the same script, I am using SQLPLUS to run an Oracle SQL script,... (6 Replies)
if
then
# mail -s "Import failed file does not exist" sanjay.jaiswal@xyz.com
echo "FILE does not exist"
exit 1
fi
echo "FILE EXIST"
size=-1
set $(du /export/home/oracle/nas/scott21.dmp.gz)
while
do
echo "Inside the loop"
size=$1
set $(du... (1 Reply)
Can someone tell me why I'm getting error when I try to run this?
#!/bin/csh -f
source ~/.cshrc
#
set SQLPLUS = ${ORACLE_HOME}/bin/sqlplus
#
set count=`$SQLPLUS -s ${DB_LOGIN} << END
select count(1) from put_groups where group_name='PC' and description='EOD_EVENT' and serial_number=1;... (7 Replies)
So, I would like to run differen select queries on multiple databases..
I made a script wich I thought to be called something like..
./script.sh sql_file_name out.log
or to enter select statement in a command line..
(aix)
and I did created some shell script wich is not working..
it... (6 Replies)
Hello everyone,
I have a RHEL 5 system and have been trying to get a batch of 3-4 scripts each in a separate variables and they are not working as expected.
I tried using following syntax which I saw a lot of people on this site use and should really work, though for some reason it doesn't... (3 Replies)
I need to run a SQL select query in Oracle database and have to capture the list of retrieved records in shell script. Also i would like to modify the query for certain condition and need to fetch it again. How can i do this?
Is there a way to have a persistent connection to oracle database... (9 Replies)
HI,
I want to connect to database and fetch the count from a table.
The sql query is as below :
select count(*) from table_test where test_column='read';
How can I print the output of this statement using shell script.
Thanks in advance. (4 Replies)
Using ksh, I am using SQLPlus to execute a query with a filter using a string variable.
REPO_DB=DEV1
FOLDER_NM='U_nmalencia'
FOLDER_CHECK=$(sqlplus -s /nolog <<EOF
CONNECT user/pswd_select@${REPO_DB}
set echo off heading off feedback off
select subj_name
from subject
where... (5 Replies)
Hi Team,
I am trying to run a sqlplus script against several databases via a FOR/LOOP and also passing the loop variable to a sqlplus script I am calling, as follows:
#!/bin/bash
export ORACLE_SID=plgc1
export ORACLE_HOME=/opt/oracle/product/11.2.0.2/db_1
export... (1 Reply)
Discussion started by: jonnyd
1 Replies
LEARN ABOUT PHP
ovrimos_fetch_row
OVRIMOS_FETCH_ROW(3)OVRIMOS_FETCH_ROW(3)ovrimos_fetch_row - Fetches a row from the result setSYNOPSIS
bool ovrimos_fetch_row (int $result_id, [int $how], [int $row_number])
DESCRIPTION
Fetches a row from the result set. Column values should be retrieved with other calls.
PARAMETERS
o $result_id
- A result identifier, returned by ovrimos_execute(3) or ovrimos_exec(3).
o $how
- Determines how the rows are fetched. This can be one of the following strings (case is not significant):
+---------+---------------------------------------------------+
| Option | |
| | |
| | Notes |
| | |
+---------+---------------------------------------------------+
| | |
| Next | |
| | |
| | Forward direction from current position. This is |
| | the default value. |
| | |
| | |
| Prev | |
| | |
| | Backward direction from current position. |
| | |
| | |
| First | |
| | |
| | Forward direction from the start. |
| | |
| | |
| Last | |
| | |
| | Backward direction from the end. |
| | |
| | |
|Absolute | |
| | |
| | Absolute position from the start. Requires |
| | $rownumber. |
| | |
+---------+---------------------------------------------------+
o $rownumber
- The row number, first one is 0. Only needed when $how is set to Absolute.
RETURN VALUES
Returns TRUE on success or FALSE on failure.
EXAMPLES
Example #1
A fetch row example
<?php
$conn = ovrimos_connect("remote.host", "8001", "admin", "password");
if ($conn != 0) {
echo "Connection ok!";
$res=ovrimos_exec($conn, "select table_id, table_name from sys.tables");
if ($res != 0) {
echo "Statement ok!";
if (ovrimos_fetch_row($res, "First")) {
$table_id = ovrimos_result($res, 1);
$table_name = ovrimos_result($res, 2);
echo "table_id=" . $table_id . ", table_name=" . $table_name . "
";
if (ovrimos_fetch_row($res, "Next")) {
$table_id = ovrimos_result($res, "table_id");
$table_name = ovrimos_result($res, "table_name");
echo "table_id=" . $table_id . ", table_name=" . $table_name . "
";
} else {
echo "Next: error
";
}
} else {
echo "First: error
";
}
ovrimos_free_result($res);
}
ovrimos_close($conn);
}
?>
This will fetch a row and print the result.
SEE ALSO ovrimos_fetch_into(3).
PHP Documentation Group OVRIMOS_FETCH_ROW(3)