Populate Datatabase Table with timestamp using SQLPLUS inside a shell script

Question

I want to insert the last modified timestamp of a file in the database within a shell script. My script goes like this

#!/usr/bin/ksh
date=date -r /raid/file/test.txt +%d" "%b" "%Y" "% r | awk '{print $1,$2,$3,$4,$5;}'
echo ${date}
sqlplus USR/[email protected] <<ENDOFSQL
INSERT INTO PROD_TABLE VALUES('$date');
exit
ENDOFSQL

I am wondering how to assign the last modified date of the file to a shell variable and use that inside sqlplus.Note that am looking for date in the format 05 May 2011 08:02:27 PM The $date is showing null at the moment and is getting inserted into the table. Would appreciate any recommendations around the same.

mu is too short · Accepted Answer · 2011-05-06 04:35:11Z

3

If you want the output of the date|awk stuff in your date variable, you need to capture it:

date=$(date -r /raid/file/test.txt +%d" "%b" "%Y" "% r | awk '{print $1,$2,$3,$4,$5;}')

Just that should do it but it has been a long time since I've used ksh. You don't need to access your date variable in sqlplus, you just need to access it in a string in your script.

answered May 6, 2011 at 4:35

mu is too short

436k71 gold badges863 silver badges822 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

Populate Datatabase Table with timestamp using SQLPLUS inside a shell script

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related