#!/bin/sh
RPTDATE=`date "+%Y%m%d"`
OUTFILE="FavoriteThings.${RPTDATE}.csv"
echo "START $0 at `date`"
sqlplus -s myuser/mypassword@mydb <<EOF
SET PAGESIZE 50000
SET COLSEP ","
SET LINESIZE 500
SET FEEDBACK OFF
SPOOL $OUTFILE
select '"'&Person, &'"'Favorite from FavoriteThings;
SPOOL OFF
EXIT
EOF
echo "END $0 at `date`"
I got
Code:
START ./TryFavoriteThings.sh at Fri Jan 25 19:47:50 GMT 2019
Enter value for person: old 1: select '"'&Person, &'"'Favorite from FavoriteThings
new 1: select '"'SPOOL OFF, &'"'Favorite from FavoriteThings
select '"'SPOOL OFF, &'"'Favorite from FavoriteThings
*
ERROR at line 1:
ORA-00923: FROM keyword not found where expected
Since i'm new to scripting i'm findind it difficult to code a script. The script has to be an executable with 2 paramters passed to it.The Parameters are
1. The Control file name(.ctl file)
2. The Data file name(.csv file)
Does anybody have an idea about it? :confused: (3 Replies)
TEST_HEME,"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1",CELL
when I split by
FS=","
then
$0=TEST_HEME
$1="SubNetwork=ONRM_RootMoR
$2=SubNetwork=ARNC1"
but I need this will be single value
"SubNetwork=ONRM_RootMoR,SubNetwork=ARNC1" (4 Replies)
Friends...This is the first time i am trying the report generation using shell script... any suggestions are welcome.
Is there a way to set the font size & color when i am exporting the data from unix shell script as a CSV file ?
The following sample data is saved as a .csv file in the... (2 Replies)
I need to read data from a file called "test.csv" through shell script where the file contains values like name,price,descriptor etc. There are rows where descriptor (& in some rows name) are written as string & other characters like "car_+" OR "bike*" etc where it should contains strings like... (3 Replies)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 5 columns having values say column 1,column 2.....column 5 as below along with their valuesm.... (1 Reply)
Hi Guys,
I am new to shell script.I need your help to write a shell script.
I need to write a shell script to extract data from a .csv file where columns are ',' separated.
The file has 7 columns having values say column 1,column 2.....column 7 as below along with their values.
Name, Address,... (7 Replies)
Hi everyone,
I have a csv file which has data with different heading and column names as below.
Static Data Ingested
,,,,,,,,,,,,Known Explained Rejections
Column_1,column_2,Column_3,Column_4,,Column_6,Column_7,,% Column_8,,Column_9 ,Column_10 ,... (14 Replies)
Hi List,
I have a chunk of data like so:
User Account Control:
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
User Account Control:
Disabled
User Account Control:
User Account Control:
... (3 Replies)
i have data as below
123,"paul phiri",paul@yahoo.com,"po.box 23, BT","Eco Bank,Blantyre,Malawi"
i need an output to be
123,"paul phiri",paul@yahoo.com,"po.box 23 BT","Eco Bank Blantyre Malawi" (5 Replies)
Discussion started by: mathias23
5 Replies
LEARN ABOUT PHP
datetime.gettimestamp
DATETIME.GETTIMESTAMP(3) 1 DATETIME.GETTIMESTAMP(3)DateTime::getTimestamp - Gets the Unix timestamp
Object oriented style
SYNOPSIS
public int DateTime::getTimestamp (void )
DESCRIPTION
int DateTimeImmutable::getTimestamp (void ) int DateTimeInterface::getTimestamp (void )
Procedural style
int date_timestamp_get (DateTimeInterface $object)
Gets the Unix timestamp.
PARAMETERS
This function has no parameters.
RETURN VALUES
Returns the Unix timestamp representing the date.
EXAMPLES
Example #1
DateTime.getTimestamp(3) example
Object oriented style
<?php
$date = new DateTime();
echo $date->getTimestamp();
?>
Procedural style
<?php
$date = date_create();
echo date_timestamp_get($date);
?>
The above examples will output something similar to:
1272509157
NOTES
Using U as the parameter to DateTime.format(3) is an alternative when using PHP 5.2.
SEE ALSO DateTime.setTimestamp(3), DateTime.format(3).
PHP Documentation Group DATETIME.GETTIMESTAMP(3)