skip to main
|
skip to sidebar
Novice in Oracle
Monday, October 13, 2008
PL/SQL | Query to find Primary Key columns of a Table
select DISTINCT dc.table_name, dc.constraint_name, ucc.column_name
from dba_constraints dc,
user_cons_columns ucc
where dc.table_name = '
'
and dc.constraint_type = 'P'
and dc.table_name = ucc.table_name
and dc.constraint_name = ucc.constraint_name
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
Author
Ranjeeth Shetty
Senkang, Singapore, Singapore
View my complete profile
Blog Archive
▼
2008
(17)
►
November
(1)
▼
October
(9)
Oracle PL/SQL | Sorting with NULL
Oracle PL/SQL | To returns single line query outpu...
Oracle PL/SQL | Finding Errors in compiled Objects
Oracle PL/SQL | A Debugger Procedure
Oracle PL/SQL | Query to Find loacked Objects
Oracle PL/SQL | Calling Java function in Oracle Pr...
Oracle PL/SQL | Script to generate SQL for Primary...
PL/SQL | Query to find Primary Key columns of a Table
Oracle PL/SQL | Using wmsys.wm_concat()
►
September
(7)
No comments:
Post a Comment