Script to create a folder with contents

Shell Programming and Scripting
1

I am working on HP Unix. Require a script for the below requirement.

Requirement are:

  1. Need to create a folder with files.
  2. The folder should have a naming convention like -
LRIC_ARCHIVE_ddmmyyhhmmss_version_nnn

, the version number needs to be selected from an oracle table.
3. When the folder is created the files from the working directory path /usr/lric/data.. to be moved to the newly created folder, making the above folder empty.

Please do let me know if I had not been able to clarify the requirements.

2

What have you done so far?

3

My major concern is creation of the folder rest I can manage.
I am stuck here and unable to proceed.

4

This may help a bit (to be adapted of course):

 
VERSION=`sqlplus -s "/as sysdba" <<EOF
set head off
select version from product_component_version where PRODUCT like 'Oracle%';
exit;
EOF
`

 
mkdir LRIC_ARCHIVE_$(date +%d%m%y%H%M%S)_version_$VERSION
5

Thanks, would try it out and get back on it.