Show the columns for the Primary Key constraints in tables owned by STUDENT (Note: Constraint Type is 'P' for Primary Key constraint).
What will be an ideal response?
```SELECT column_name, a.table_name
FROM all_constraints a, all_cons_columns b
WHERE a.owner = b.owner
AND a.table_name = b.table_name
AND a.constraint_name = b.constraint_name
AND a.owner = 'STUDENT'
AND constraint_type = 'P'```
Computer Science & Information Technology
You might also like to view...
Which role evaluates the security needs of the organization and develops the internal information security governance documents?
A. Security administrator B. Security analyst C. Data custodian D. Data owner
Computer Science & Information Technology
The VMM _____________________ provides Web access to the VMM environment.
Fill in the blank(s) with the appropriate word(s).
Computer Science & Information Technology