how to rename many files with one command

package_cypdba.acapx_p.sql
package_cypdba.ccapx_p.sql
package_cypdba.bcapx_p.sql


these to be renamed as
acapx_p.sql
ccapx_p.sql
bcapx_p.sql

thanx

Assuming the list of file are saved into the file /tmp/FileList and you run this code from the directory on which the files resides.

for v in $(</tmp/FileList) ; do
 cp $v ${v#*.}
done

dears
it not worked i want to replace many files by removing the first words

package_cypdba.acvcd_p.sql
with the new name
acvcd_p.sql

The syntax " cp $v ${v#*.}" is that of korn shell.

You can try,

for v in `cat /tmp/FileList`; do
cp -i $v $(echo $v| cut -d"." -f2- )
done

also i try the output by adding h aftre _p for example

package_body_paldba.abalq_p.sql i need to copy it to abalq_ph.sql

in first step i do the above script but it make ablaq_p.sql and i need to add in every file h after _p