Question

SQL

a "DROP TABLE" command for the external table that will be created in the following step

s an external table based on the data stored in the "ResearchData.csv$"$ file. This file contains data related to my Ph$.$D$.$ Computer Science research rele ontains multiple fields separated by commas. The first field represents the name identifier for a protein $($i$.$e$.$ Protein ID and Chain ID$,$ e$.$g$.1$ADF A imp ield names are "Protein ID$","$RMSD$\_1"....."$RMSD$\_32".$

es a query $($using a substitution variable to represent the Protein identifier$)$ that retrieves all of the RMSD values associated with that protein.

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.

directory ResearchData;

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

read, write on directory ResearchData to DBA:

table Research:

te table Research$($

ein ID VARCHAR$2(6),$

in ID VARCHAR$(2)$

GANIZATION EXTERNALI

E oracle$\_$loader

$=$AULT DIRECTORY ResearchData

CESS PARAMETERS

ELDS TERMINATED BY $$

CATION $($Z:AResearchData$-1$Csv$\text{'})$