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'
```
You might also like to view...
Access is the best tool for creating a chart because there are a wide variety of chart types and formatting options
Indicate whether the statement is true or false
Flash Fill is a function in Microsoft Excel used to enter formulas with multiple calculations.?
Answer the following statement true (T) or false (F)
Windows 8.1 supports the distribution and installation of several different types of updates except ______________________?
a. Daily updates b. Critical security updates c. Optional updates d.Update roll-ups
The ____ is the expected monetary loss every time a risk occurs.
A. Exposure Factor (EF) B. Annualized Loss Expectancy (ALE) C. Annualized Rate of Occurrence (ARO) D. Single Loss Expectancy (SLE)