SQL Security - creating a secure SQL command

Question

I am wondering how best to ensure that security in Oracle databases can be assured.

Answer 1

you can use

SELECT TITLE, SUPERVISOR FROM PROJ_DETAILS WHERE STUDENT =
DBMS_ASSERT.ENQUOTE_LITERAL(' The name entered and stored in username')

OR

EXECUTE IMMEDIATE 'SELECT TITLE, SUPERVISOR FROM PROJ_DETAILS WHERE STUDENT = 
:1 ' USING vstudent;