How do I insert the current date into an Oracle table using a Unix shell script?

Question

I am using the Bash shell and am new to shell scripting.

I have to insert the current system date and time into an Oracle table which has one "date" column (datatype is timestamp(6)) using a shell script.

How can I do it?

Answer 1

to get the time stamp from shell, you can use date +%s (long value) and insert into your table.