A correlation-Name is given to a table expression in a FROM clause as a new name or alias for that table. You do not qualify a correlation-Name with a schema-Name.
SELECT c11 AS col1, c12 AS col2, c13 FROM t1 FOR UPDATE of c11,c13In this example, the correlation-Name col1 FOR c11 is not permitted because c11 is listed in the FOR UPDATE list of columns. You can use the correlation-Name FOR c12 because it is not in the FOR UPDATE list.
-- C is a correlation-Name SELECT C.NAME FROM SAMP.STAFF C