Shell Programming and Scripting

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 -

Code:

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.

What have you done so far?

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

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

Code:

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

Code:

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

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