Solved:

Oracle SQL

Issues a "DROP TABLE" command for the external table that will be created in the following step table field names are "Protein ID$","$RMSD$\_1"....."$RMSD$\_32".$

Creates a query $($using a substitution variable to respresent the Protein Identifier$)$ that retrieves all of the RMSD values associated with that protein.

I have started the question, but I$\text{'}$m stuck in the query part if you could help me any way you can it will be greatly appreciated.

drop directory ResearchData;

create directory ResearchData as $\text{'}$Z:$\backslash$ResearchData$-1.$csv$\text{'}$;

grant read, write on directory ResearchData to DBA;

drop table Research;

create table Research$($

Protein$\_$ID VARCHAR$2(6),$

Chain$\_$ID VARCHAR$(2)$

ORGANIZATION EXTERNAL$($

TYPE oracle$\_$loader

DEFAULT DIRECTORY ResearchData

ACCESS PARAMETERS

$($FIELDS TERMINATED BY $$

LOCATION $(\text{'}$Z:IResearchData$-1.$csv$\text{'})$

;